10201升級到10204的ORA-01092問題的解決

guyuanli發表於2009-08-04

oracle 10201升級到10204後出現下現問題

SQL> startup

ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

[@more@]

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...

解決方法:
SQL> startup upgrade

重建資料字典表
SQL> @?/rdbms/admin/catupgrd.sql

編譯失效物件
SQL>@?/rdbms/admin/utlrp.sql

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7490392/viewspace-1024880/,如需轉載,請註明出處,否則將追究法律責任。

相關文章