EM 13c: Creating an Enterprise Manager 13c Cloud Control Repository using a Database Template Fails: ORA-00603: ORACLE server session terminated by fatal error
Last updated on APRIL 19, 2018
Applies to:
Enterprise Manager Base Platform - Version 13.2.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Enterprise Manager (EM) 13.2 Cloud Control repository database template
Oracle Database 12.2.0.1 for use as a repository store
The EM 13.2 Cloud Control repository database instance can be created using dbca with a template supplied by Oracle to shorten the time requried for repository creation during EM 13C installation using the procedure posted here in the product docuemntation:
Enterprise Manager Cloud Control Basic Installation Guide
Release 13.2
Appendix C Creating a Database Instance with Preconfigured Repository Using Database Templates
Exercising this procedure using the small deployment db template (with dbca) option, logs the following database errors:
trace.log:
[Thread-157] [ 2017-07-11 10:09:40.347 COT ] [CloneDBCreationStep.executeImpl:513] Shutdown database
[Thread-157] [ 2017-07-11 10:09:40.351 COT ] [CloneDBCreationStep.executeImpl:549] Startup ......nomount......
[Thread-157] [ 2017-07-11 10:09:43.646 COT ] [CloneDBCreationStep.executeImpl:663] Enabling restricted session.
[Thread-157] [ 2017-07-11 10:09:44.724 COT ] [CloneDBCreationStep.executeImpl:667] alter database "emrep" open resetlogs;
[Thread-166] [ 2017-07-11 10:09:53.448 COT ] [BasicStep.handleNonIgnorableError:509] oracle.sysman.assistants.util.InteractiveMessageHandler@6d5f4657:messageHandler
[Thread-166] [ 2017-07-11 10:09:53.448 COT ] [BasicStep.handleNonIgnorableError:510] ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "[]#": invalid identifier
alert.log:
Errors in file /u01/app/oracle/diag/rdbms/emrep/emrep/trace/emrep_ora_8248.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "[]#": invalid identifier
2017-07-11T10:09:51.423425-05:00
Errors in file /u01/app/oracle/diag/rdbms/emrep/emrep/trace/emrep_ora_8248.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "[]#": invalid identifier
2017-07-11T10:09:51.423726-05:00
Errors in file /u01/app/oracle/diag/rdbms/emrep/emrep/trace/emrep_ora_8248.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "[]#
Changes
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms