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>
......省略部分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...