oracle10.2.0.1打补丁升级到10.2.0.4,造成数据库打不开,报ORA-00704:
一个星期前在linux上安装好oracle10g,并且已经在使用,今天从ORACLE官网下载10.2.0.4补丁进行升级,安装好后,启动报错:
SQL> startupORACLE instance started.Total System Global Area 285212672 bytesFixed Size 2083368 bytesVariable Size 88081880 bytesDatabase Buffers 188743680 bytesRedo Buffers 6303744 bytesDatabase mounted.ORA-01092: ORACLE instance terminated. Disconnection forcedSQL>
进入/opt/app/oracle/admin/orcl/bdump目录下打开alert_orcl.log日记查看,有以下报错信息:
......省略部分Sun Dec 12 09:33:41 2010Completed redo applicationSun Dec 12 09:33:41 2010Completed crash recovery at Thread 1: logseq 13, block 3, scn 936985 0 data blocks read, 0 data blocks written, 1 redo blocks readSun Dec 12 09:33:41 2010Thread 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.logSuccessful open of redo thread 1Sun Dec 12 09:33:41 2010MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setSun Dec 12 09:33:42 2010Errors in file /opt/app/oracle/admin/orcl/udump/orcl_ora_3758.trc:ORA-00704: bootstrap process failureORA-39700: database must be opened with UPGRADE optionError 704 happened during db open, shutting down databaseUSER: terminating instance due to error 704Instance terminated by USER, pid = 3758ORA-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了。