Oracle database Startup report ORA-00704 ORA-39714 Error Resolution

Database failed to start, reported ORA-00704, ORA-39714 error
[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 Log Error
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
By analyzing the Utlmmig.sql script, the database will insert Bootstrap_upgrade_error related records in the props$ table before upgrading bootstrap$, and the database will detect the value when it is started, if it is found, The database can only start in upgrade mode, clean up the related records, the database can start normally
[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 a 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>
The database is successfully started, but because the Bootstrap$ object upgrade failed, there is a significant follow-up risk, we recommend the analysis of the cause of the error, and then continue to upgrade the bootstrap$ base table

Contact: Mobile Phone (13429648788) QQ (107644445)

Link: http://www.xifenfei.com/5579.html