Oracle 10201升级到10204的ORA-01092问题的解决

2015-02-02 19:28:12 · 作者: · 浏览: 17

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


重建数据字典表
SQL> @?/rdbms/admin/catupgrd.sql


编译失效对象
SQL>@?/rdbms/admin/utlrp.sql
SQL>@?/rdbms/admin/catalog.sql


SQL>shutdown immediate


SQL>startup
数据库启动成功