oracle数据库打不开 遇到ora-00704引导程序失败 ora-39700必须使用upgra
发布网友
发布时间:2022-05-06 04:26
我来回答
共2个回答
懂视网
时间:2022-05-06 08:48
ORA-39700: database must be opened with UPGRADE option
1. 错误
操作系统和数据库都是服务提供商安装的,过了几个月才想起要用这个数据库,,启动时出现如下错误。
SQL> startup
Oracle instance started.
Total System Global Area 4932501504 bytes
Fixed Size 2103096 bytes
Variable Size 889194696 bytes
Database Buffers 4026531840 bytes
Redo Buffers 14671872 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
2. 查看alert.log
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
3. 查看数据库版本为:10.2.0.5.0,应该是他们做过数据库的升级而没有执行这个脚本造成的
$ORACLE_HOME
dbmsadmincatupgrd.sql;
4.处理过程很简单
startup upgrade;
@$ORACLE_HOME
dbmsadmincatupgrd.sql;
@$ORACLE_HOME/rdbms/admin/utlrp.sql; --重新编译失效的object,跟这个问题本身关系不大
重启数据库
shutdwon immediate;
startup
ok
热心网友
时间:2022-05-06 05:56
$ oerr ora 704
00704, 00000, "bootstrap process failure"
// *Cause: Failure in processing bootstrap data - see accompanying error.
// *Action: Contact your customer support representative.
$ 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).
Recovery of Online Redo Log: Thread 1 Group 3 Seq 9 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\orcl\REDO03.LOG
Tue Dec 10 09:33:56 2013
Completed redo application
Tue Dec 10 09:33:56 2013
Completed crash recovery at
Thread 1: logseq 9, block 5, scn 10226857380
0 data blocks read, 0 data blocks written, 2 redo blocks read
Tue Dec 10 09:33:56 2013
Thread 1 advanced to log sequence 10 (thread open)
Thread 1 opened at log sequence 10
Current log# 1 seq# 10 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\orcl\REDO01.LOG
Successful open of redo thread 1
Tue Dec 10 09:33:57 2013
SMON: enabling cache recovery
Tue Dec 10 09:33:57 2013
Errors in file d:\oracle\proct\10.2.0\admin\orcl\ump\orcl_ora_1596.trc:
ORA-00704: 引导程序进程失败
ORA-39700: 必须用 UPGRADE 选项打开数据库
Tue Dec 10 09:33:57 2013
Error 704 happened ring db open, shutting down database
USER: terminating instance e to error 704
Tue Dec 10 09:33:57 2013
Errors in file d:\oracle\proct\10.2.0\admin\orcl\bmp\orcl_mman_4060.trc:
ORA-00704: bootstrap process failure
Tue Dec 10 09:33:57 2013
Errors in file d:\oracle\proct\10.2.0\admin\orcl\bmp\orcl_dbw0_1800.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
The following is observed in the sqlplus session
SQL> startup;
ORACLE instance started.
Total System Global Area 1954160640 bytes
Fixed Size 2227752 bytes
Variable Size 1325400536 bytes
Database Buffers 620756992 bytes
Redo Buffers 5775360 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: 22861
Session ID: 1705 Serial number: 5
以上的ORA-00704和ORA-39700 2个错误一般出现在升级数据库数据字典操作不当的场景中,可能是使用了版本错误的ORACLE BINARY也可能是数据字典本身有严重的问题了。
一般建议调整正确的 ORACLE PATH ,同时重新运行字典升级的脚本例如 catupgrd.sql; 如仍无法解决,则可能需要手动patch 数据字典了。
如果自己搞不定可以找ASKMACLEAN专业数据库修复团队成员帮您恢复!