oracle 10201升级到10204后出现下现问题
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 数据库启动成功
