EM 13c: Creating an Enterprise Manager 13c Cloud Control Repository using a Database Template Fails: ORA-00603: ORACLE server session terminated by fatal error (Doc ID 2291220.1)

Last updated on AUGUST 01, 2017

Applies to:

Enterprise Manager Base Platform - Version 13.2.0.0.0 and later
Information 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:19.927 COT ] [CloneDBCreationStep.executeImpl:503]  calling zerodbid
[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:

2017-07-11T10:09:51.422957-05:00
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