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

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
数据库启动成功更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle中的soaptestOracle教程：Redo write触发的四种情况相关资讯 Oracle高级培训

delete表的数据后恢复（08/30/2012 08:59:58）
使用ASH信息，发现高CPUsession （08/14/2012 07:21:32）
如何阅读Oracle Errorstack Output （08/14/2012 07:15:47）

Oracle Apps Patching:adpatch（（08/16/2012 15:41:37）
话说V$SQL_MONITOR （08/14/2012 07:19:54）
Oracle Apps DBA工具:ADADMIN使用（08/14/2012 07:00:09）

本文评论查看全部评论（0）