ORA-39700: database must be opened with UPGRADE option

数据库启动的时候报错:
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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值