OCI: Unable To Create 11.2 Database
(Doc ID 2941454.1)
Last updated on APRIL 29, 2024
Applies to:
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]Information in this document applies to any platform.
Symptoms
OCI EXACS
Customer trying to create a 11.2 Database , its failing at 60% progress with following error: Database job: Failed. Running ocde
In backend dbda log found below error
dbda log
=========
2023-04-09 06:29:47.106086 - INFO : startdb : first db and nodelist does not have first_node :hostname
2023-04-09 06:29:47.110333 - Output from cmd export ORACLE_HOME=/u02/app/oracle/product/11.2.0/dbhome_2 ; /u02/app/oracle/product/11.2
.0/dbhome_2/bin/srvctl start database -d DBPOC01_PRIM run on localhost is:
2023-04-09 06:32:50.836060 - PRCR-1079 : Failed to start resource ora.dbpoc01_prim.db
CRS-5017: The resource action "ora.dbpoc01_prim.db start" encountered the following error:
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 0
Session ID: 0 Serial number: 0
In DB alert log can see below messages
Mon Apr 10 06:28:19 2023
No connectivity to other instances in the cluster during startup. Hence, LMON is terminating the instance. Please check the LMON trace file for details. Also, please check the network logs of this instance along with clusterwide network health for problems and then re-start this instance.
LMON (ospid: 143853): terminating the instance
Mon Apr 10 06:28:19 2023
ORA-1092 : opitsk aborting process
Mon Apr 10 06:28:19 2023
ORA-1092 : opitsk aborting process
Mon Apr 10 06:28:19 2023
License high water mark = 1
Instance terminated by LMON, pid = 143853
USER (ospid: 146171): terminating the instance
Instance terminated by USER, pid = 146171
Changes
NIL
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |