日期:2014-05-16  浏览次数:20588 次

oracle10.2.0.1打补丁升级到10.2.0.4,造成数据库打不开,报ORA-00704:
   一个星期前在linux上安装好oracle10g,并且已经在使用,今天从ORACLE官网下载10.2.0.4补丁进行升级,安装好后,启动报错:

SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  2083368 bytes
Variable Size              88081880 bytes
Database Buffers          188743680 bytes
Redo Buffers                6303744 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> 


   进入/opt/app/oracle/admin/orcl/bdump目录下打开alert_orcl.log日记查看,有以下报错信息:
......省略部分

Sun Dec 12 09:33:41 2010
Completed redo application
Sun Dec 12 09:33:41 2010
Completed crash recovery at
 Thread 1: logseq 13, block 3, scn 936985
 0 data blocks read, 0 data blocks written, 1 redo blocks read
Sun Dec 12 09:33:41 2010
Thread 1 advanced to log sequence 14 (thread open)
Thread 1 opened at log sequence 14
  Current log# 1 seq# 14 mem# 0: /opt/app/oracle/oradata/orcl/redo01.log
Successful open of redo thread 1
Sun Dec 12 09:33:41 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Dec 12 09:33:42 2010
Errors in file /opt/app/oracle/admin/orcl/udump/orcl_ora_3758.trc:

ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 3758
ORA-1092 signalled during: ALTER DATABASE OPEN...



   在网上查了下资料,知道了原因:

我已经有一个10.2.0.1的数据库,而且已经在使用,升级到10.2.0.4,只安装补丁软件,没

升级数据字典,而造成数据库打不开,报ORA-00704:bootstrap process failure错误


   解决方法:就按正常升级数据字典步骤即可
     SQL> STARTUP UPGRADE
    SQL> SPOOL patch.log
    SQL> @/opt/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
    SQL> SPOOL OFF

   编译失效对象
     SQL>@/opt/app/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sql

   启动OK了。