Oracle Database Error：ORA-39700
有时候，你可能会在ALERT日志中发现如下的错误：
|
1 2 3 4 5 6 7 8 9 |
Fri Oct 03 23:37:33 CST 2014 Errors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_7704.trc: ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Fri Oct 03 23:37:33 CST 2014 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 7704 ORA-1092 signalled during: ALTER DATABASE OPEN... |
通常，该错误发生的时候，SQL*Plus的呈现是：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
[root@ora10g ~]# su - oracle [oracle@ora10g ~]$ export ORACLE_SID=orcl [oracle@ora10g ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Fri Oct 3 23:36:55 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 2095704 bytes Variable Size 88081832 bytes Database Buffers 188743680 bytes Redo Buffers 6291456 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@ora10g ~]$ |
该错误发生在升级10g数据库为：10.2.0.[……]
- Posted on:
-
Author:
Adamhuan
- Categories: Oracle Database
- Tags: 10.2.0.5.0, 10g, catupgrd.sql, Instance, ORA-39700, Oracle, Upgrade, utlrp.sql, 升级
- Leave a comment: Oracle Database Error：ORA-39700