12.1.0.1 DBCA Fails to Start Database (db) Resource With ASM Diskgroup
(Doc ID 2107094.1)
Last updated on APRIL 12, 2024
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Dbca failed to start db resource with asm diskgroup and below trace generated
DBCA_PROGRESS : 85%
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5010: Update of configuration file "/etc/oratab" failed: details at "(:CLSN00011:)" in
"/u01/app/12.1.0/grid/log/rachost1/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-5016: Process "/u01/app/12.1.0/grid/bin/setasmgidwrap" spawned by agent "oraagent" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/12.1.0/grid/log/rachost1/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/12.1.0/grid/log/rachost1/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.orcl.db' on 'rachost1' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
DBCA_PROGRESS : 86%
ORA-01034: ORACLE not available
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5010: Update of configuration file "/etc/oratab" failed: details at "(:CLSN00011:)" in
"/u01/app/12.1.0/grid/log/rachost1/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-5016: Process "/u01/app/12.1.0/grid/bin/setasmgidwrap" spawned by agent "oraagent" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/12.1.0/grid/log/rachost1/agent/crsd/oraagent_oracle/oraagent_oracle.log"
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-12547: TNS:lost contact
. For details refer to "(:CLSN00107:)" in "/u01/app/12.1.0/grid/log/rachost1/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.orcl.db' on 'rachost1' failed
CRS-2632: There are no more servers to try to place resource 'ora.orcl.db' on that would satisfy its placement policy
DBCA_PROGRESS : 86%
ORA-01034: ORACLE not available
With database creation manually, below error seen
CREATE DATABASE "test1"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-12547: TNS:lost contact
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-12547: TNS:lost contact
The disk group is already mounted in ASM.
This issue also hit when upgrading the database from 12.1.0.1 to 12.1.0.2 with ASM storage or while restore a 12.1.0.1 database on 12.1.0.2 ASM storage.
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 |
| Cause |
| Solution |