ORA-39700錯誤(一般升級資料庫容易遇到)

perry_shi發表於2008-08-09
資料庫

  最近有人遇到了ORA-39700錯誤是在DB升級後遇到的,查了下解釋如下:

  SQL> !oerr ora 39700 

39700, 00000, "database must be opened with UPGRADE option"
// *Cause:  A normal database open was attempted, but the database has not
//          been upgraded to the current server version.
// *Action: Use the UPGRADE option when opening the database to run
//          catupgrd.sql (for database upgrade), or to run catalog.sql
//          and catproc.sql (after initial database creation).

    說明需要執行這些資料字典指令碼,也就是資料字典裡的東西被改變了

    順便查閱了其他人遇到的這個問題解決方法,也歸納如下:

   

ORA-39700

上星期升級以後重新啟動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>#
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area  167772160 bytes
Fixed Size                  1259744 bytes
Variable Size             121636640 bytes
Database Buffers           41943040 bytes
Redo Buffers                2932736 bytes
Database mounted.
Database opened.
SQL>

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/127656/viewspace-422869/，如需轉載，請註明出處，否則將追究法律責任。

相關文章