An error occurred after Oracle 10201 was upgraded to 10204.
SQL> startup
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Alert
Errors in file/oracle/admin/mydb2/udump/mydb2_ora_5811.trc:
ORA-00704: bootstrap process failure.
ORA-39700: database must be opened with UPGRADE option
Mon Mar 2 06:11:29 2009
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704.
Instance terminated by USER, pid = 5811
ORA-1092 signalled during: alter database open...
Solution:
SQL> startup upgrade
Rebuilding a data dictionary table
SQL> @? /Rdbms/admin/catupgrd. SQL
Compile Invalid object
SQL> @? /Rdbms/admin/utlrp. SQL
SQL> @? /Rdbms/admin/catalog. SQL
SQL> shutdown immediate
SQL> startup
Database started successfully
For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12