oracle3135和3114错误,数据库启动报ORA-00704 ORA-39714错误解决

数据库启动失败,报ORA-00704、ORA-39714错误

[oracle@www.xifenfei.com ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Aug 7 08:15:35 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> startup

ORACLE instance started.

Total System Global Area 663945216 bytes

Fixed Size 2291808 bytes

Variable Size 369100704 bytes

Database Buffers 289406976 bytes

Redo Buffers 3145728 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-39714: upgrade script utlmmig.sql failed

Process ID: 11592

Session ID: 1 Serial number: 5

SQL> startup upgrade

SP2-0642: SQL*Plus internal error state 2133, context 3114:0:0

Unsafe to proceed

ORA-03114: not connected to ORACLE

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

alert日志报错

Thu Aug 07 07:42:25 2014

SMON: enabling cache recovery

Thu Aug 07 07:42:25 2014

Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_11592.trc:

ORA-39714: upgrade script utlmmig.sql failed

Thu Aug 07 07:42:25 2014

Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_11592.trc:

ORA-00704: bootstrap process failure

ORA-39714: upgrade script utlmmig.sql failed

Thu Aug 07 07:42:25 2014

Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_11592.trc:

ORA-00704: bootstrap process failure

ORA-39714: upgrade script utlmmig.sql failed

Thu Aug 07 07:42:25 2014

Error 704 happened during db open, shutting down database

USER (ospid: 11592): terminating the instance due to error 704

通过分析utlmmig.sql脚本知道,数据库在升级bootstrap$之前会先在props$表中插入BOOTSTRAP_UPGRADE_ERROR相关记录,数据库在启动之时会检测该值,如果发现该值存在,数据库只能以upgrade模式启动,清理掉相关记录,数据库即可正常启动

[oracle@www.xifenfei.com ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Aug 7 07:42:44 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup upgrade

ORACLE instance started.

Total System Global Area 663945216 bytes

Fixed Size 2291808 bytes

Variable Size 369100704 bytes

Database Buffers 289406976 bytes

Redo Buffers 3145728 bytes

Database mounted.

Database opened.

SQL> delete from props$ where name = 'BOOTSTRAP_UPGRADE_ERROR';

1 row deleted.

SQL> delete from props$ where name = 'LOGMNR_BOOTSTRAP_UPGRADE_ERROR';

0 rows deleted.

SQL> commit;

Commit complete.

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 663945216 bytes

Fixed Size 2291808 bytes

Variable Size 369100704 bytes

Database Buffers 289406976 bytes

Redo Buffers 3145728 bytes

Database mounted.

Database opened.

SQL>

数据库虽然正常启动成功,但是由于bootstrap$对象升级失败,后续还是有很大风险,建议分析报错原因,解决原因然后继续升级bootstrap$基表