Oracle 10201升級(jí)到10204的ORA-01092問(wèn)題的解決

Oracle 10201升級(jí)到10204后出現(xiàn)下現(xiàn)問(wèn)題

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…

解決方法：
SQL> startup upgrade

重建數(shù)據(jù)字典表
SQL> @?/rdbms/admin/catupgrd.sql

編譯失效對(duì)象
SQL>@?/rdbms/admin/utlrp.sql
SQL>@?/rdbms/admin/catalog.sql

SQL>shutdown immediate

SQL>startup
數(shù)據(jù)庫(kù)啟動(dòng)成功

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]