ORA-01092: ORACLE instance terminated.

Issue : ORA-01092: ORACLE instance terminated. Disconnection forced errors will occur and the error ORA-39700: database must be opened with UPGRADE option will be in the alert log.

Resolution : Run the following steps to fix the above issue


Shut down the database:
SQL> SHUTDOWN
Start the listener
$ lsnrctl start
$ sqlplus "/ as sysdba"
sql>start upgrade
For some reason if its not starting with upgrade option, the instance get crashed due to this issue
Process LGWR died, see its trace fileUSER: terminating instance due to error 443Instance terminated by USER, pid = 14136 or BW3 started with pid=8, OS id=15094Thu Aug 7 21:52:44 2008Process startup failed, error stack:Thu Aug 7 21:52:45 2008

Kill all the existing runing process for that oracle unix account and try starting up the database with upgrade option

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF


Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.SQL> @?/rdbms/admin/utlrp.sql


For more detail you can also check readme of 5337014. I faced this issue recently and it got fix with the above steps. I hope this will help you.