Issue shutdown abort

Check your alertSID.log for the primary cause of the problem. Is it your test/prod/dev server?


Issue the commands one by one and let us know the status.


Set your ORACLE_SID= in the env

$ svrmgrl
SVRMGR> connect internal as sysdba
SVRMGR> startup nomount;
SVRMGR> alter database mount;
SVRMGR> recover database; (If your database is in the archive mode)
SVRMGR> alter database open;




Here are some of the secanrios and their displays

SVRMGR> connect internal
Connected.
SVRMGR> startup nomount;
ORACLE instance started.
Total System Global Area 278446240 bytes
Fixed Size 73888 bytes
Variable Size 101072896 bytes
Database Buffers 177119232 bytes
Redo Buffers 180224 bytes
SVRMGR> select database_status, status from v$instance;
DATABASE_STATUS STATUS
----------------- -------
ACTIVE STARTED
1 row selected.
SVRMGR> alter database mount;
Statement processed.
SVRMGR> select database_status, status from v$instance;
DATABASE_STATUS STATUS
----------------- -------
ACTIVE MOUNTED
1 row selected.
SVRMGR> alter database open;
Statement processed.
SVRMGR> select database_status, status from v$instance;
DATABASE_STATUS STATUS
----------------- -------
ACTIVE OPEN
1 row selected.
SVRMGR>


Hope this would help you.

Sam