ORA-39700: database must be opened with UPGRADE option

来源：互联网发布：英语小说阅读软件编辑：程序博客网时间：2024/06/08 16:16

数据库启动的时候报错：

SQL> startup

ORACLE instance started.

Total System Global Area 534462464 bytes

Fixed Size 2215064 bytes

Variable Size 360711016 bytes

Database Buffers 163577856 bytes

Redo Buffers 7958528 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Process ID: 10040

Session ID: 191 Serial number: 7

[oracle@200-168-1-4 admin]$ 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).

--在nomout状态下用sys用户执行如下两个脚本即可（原因是我们的数据库当时并未完整执行这两个脚本就启动数据库了，数据库升级的时候也会出现上面的情况）：

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

0 0