Oracle database Startup report ORA-00704 ORA-39714

Oracle database Startup report ORA-00704 ORA-39714 

Database failed to start, reported ORA-00704, ORA-39714 error


TRY below first

ORA-39714: upgrade script utlmmig.sql failed

Cause: A normal database open was attempted, but the upgrade script utlmmig.sql failed to complete.

Action: Use the UPGRADE option when opening the database and then run utlmmig.sql.




If not working, you can check the below workaround, but on own risk

Sqlplus/as SYSDBA

Sql*plus:release 12.1.0.2.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.2.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



Alert Log Error
~~~~~~~~~~~~~~~~~~~~~~~~
Thu Aug 07 07:42:25 2014
Smon:enabling Cache Recovery
Thu Aug 07 07:42:25 2014
Errors in FILEAPPL/ORA12102/DIAG/RDBMS/PROD/PROD/TRACE/ORCL_ORA_11592.TRC:
Ora-39714:upgrade Script Utlmmig.sql failed
Thu Aug 07 07:42:25 2014
Errors in FILEAPPL/ORA12102/DIAG/RDBMS/PROD/PROD/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 FILEAPPL/ORA12102/DIAG/RDBMS/PROD/PROD/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



Sqlplus/as SYSDBA

Sql*plus:release 12.1.0.2.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