读书人

oracle10.2.0.1打补丁升级到10.2.0.4,

发布时间: 2012-07-19 16:02:20 作者: rapoo

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

读书人网 >其他数据库

热点推荐