After Upgrading ORACLE_HOME (from 10.2.0.1 to 10.2.0.4), I was started my database by using startup command, then got below error.
After I saw my alert log and got ORA-00704 error,
Alert Log :
Errors in file /oracle/product/db/10.2.0/dbhome/admin/test/udump/test_ora_11338.trc: ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Wed Jun 19 11:43:30 2013 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 11338 ORA-1092 signalled during: ALTER DATABASE OPEN....
Solution:
I missed to run catupgrd.sql script after upgrade, so got above errors while starting the database.
Go to ORACLE_HOME/rdbms/admin sqlplus / as sysdba sql>startup upgrade sql>@catupgrd.sql sql>@utlrp.sql sql>shut immediate sql>startup
Bruce Lee (born Lee Jun-fan; 27 November 1940 – 20 July 1973) was a Chinese American Hong Kong actor, martial arts instructor, philosopher, film director, film producer, screenwriter, and founder of the Jeet Kune Do martial arts movement. He is widely considered by many commentators, critics, media and other martial artists to be the most influential martial artist and pop culture icon of the 20th Century. He is often credited with changing the way Asians were presented in American films.
Other Ways To Take Trace in Oracle Application :
SQL> ALTER SESSION SET sql_trace=TRUE; SQL> ALTER SESSION SET sql_trace=FALSE; SQL> EXEC DBMS_SESSION.set_sql_trace(sql_trace => TRUE); SQL> EXEC DBMS_SESSION.set_sql_trace(sql_trace => FALSE); SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 8'; SQL> ALTER SESSION SET EVENTS '10046 trace name context off'; SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>TRUE); SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>FALSE); SQL> EXEC DBMS_SYSTEM.set_ev(si=>123, se=>1234, ev=>10046, le=>8, nm=>' ');
