oracle10.2.0.1打补丁升级到10.2.0.4,促成数据库打不开，报ORA-00704

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了。

oracle10.2.0.1打补丁升级到10.2.0.4,促成数据库打不开，报ORA-00704

相关推荐