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

二月 23rd, 2010 Posted in oracle | 阅读次数: 344 次

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
数据库启动成功

相关日志：

Tags:

This entry was posted on 星期二, 二月 23rd, 2010 at 19:14 and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “10201升级到10204的ORA-01092问题的解决”

  1. Resources Says:

    五月 9th, 2011 at 20:03

    My Recommended Websites…

    [...]some new websites on the web we love, even if they are not related to ours. Check them out[...]…


  2. Treat a Yeast Infection Says:

    五月 9th, 2011 at 21:31

    Recent Favourite Sites…

    [...]below you’ll find my recommended links page http://www.yeastinfectiontreatmentcure.net/links/ with some fantastic sites that I think you should visit[...]…


留下您的脚印