上星期升级以后重新启动database发生这样的情况ORA-01092: ORACLE instance terminated. Disconnection forced

 

检察alertfile发现

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

 

主要原因是升级以后数据字典的一些基表的内容修改了。catalog.sql和catproc.sql这2个脚本需要在运行一下把数据字典视图在更新一下。

oerr ora 39700

 

解决方法:使用startup upgrade启动就可以了。

 

[oracle@localhost bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on ÐÇÆÚÒ» 7ÔÂ 31 09:26:28 2006

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> STARTUP UPGRADE
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1259744 bytes
Variable Size              75499296 bytes
Database Buffers           88080384 bytes
Redo Buffers                2932736 bytes
Database mounted.
Database opened.
SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql

...

 

No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP RUL        2006-07-31 10:37:41
DBUA_TIMESTAMP RUL        VALID       2006-07-31 10:37:41

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UPGRD_END  2006-07-31 10:37:41
.
Oracle Database 10.2 Upgrade Status Utility           07-31-2006 10:37:41
.
Component                                Status         Version  HH:MM:SS
Oracle Database Server                    VALID      10.2.0.2.0  00:14:58
JServer JAVA Virtual Machine              VALID      10.2.0.2.0  00:03:58
Oracle XDK                                VALID      10.2.0.2.0  00:00:58
Oracle Database Java Packages             VALID      10.2.0.2.0  00:01:03
Oracle Text                               VALID      10.2.0.2.0  00:00:27
Oracle XML Database                       VALID      10.2.0.2.0  00:01:42
Oracle Data Mining                        VALID      10.2.0.2.0  00:00:27
OLAP Analytic Workspace                   VALID      10.2.0.2.0  00:00:32
OLAP Catalog                              VALID      10.2.0.2.0  00:01:04
Oracle OLAP API                           VALID      10.2.0.2.0  00:01:06
Oracle interMedia                         VALID      10.2.0.2.0  00:08:36
Spatial                                   VALID      10.2.0.2.0  00:00:58
Oracle Expression Filter                  VALID      10.2.0.2.0  00:00:21
Oracle Enterprise Manager                 VALID      10.2.0.2.0  00:01:04
Oracle Rule Manager                       VALID      10.2.0.2.0  00:00:20
.
Total Upgrade Time: 00:37:41
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC>   The above PL/SQL lists the SERVER components in the upgraded
DOC>   database, along with their current version and status.
DOC>
DOC>   Please review the status and version columns and look for
DOC>   any errors in the spool log file.  If there are errors in the spool
DOC>   file, or any components are not VALID or not the current version,
DOC>   consult the Oracle Database Upgrade Guide for troubleshooting
DOC>   recommendations.
DOC>
DOC>   Next shutdown immediate, restart for normal operation, and then
DOC>   run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#