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.
ORA-01092 oracle instance terminated. Disconnection force.
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
THNX
ReplyDeletewelcome :-)
ReplyDeletewelcome :-)
ReplyDeletethankyou sir for good explanation .... sir i need more issues where u came across .. Thankyou
ReplyDeleteHi
ReplyDeleteWe have two oracle homes(11 and 10) and when i tried to open a 10 ora home db i am getting this error. Please let me know from which ora home(10 or 11) i need to run the above script
thanks
kk
hi ram,
ReplyDeleteI have faced the issue after upgrade from 10.2.0.1 to 10.2.0.4. In your case, its different set the correct ORACLE_HOME in oratab with right dbname.
This is known issue
ReplyDelete
ReplyDeleteSP2-0310: unable to open file "catupgrd.sql"
what is the solution for this??