[OCI] Oracle Database Startup Failed with ORA-00210/ ORA-00202 / ORA-15001/ ORA-15040 after Patching DB System OCI
(Doc ID 2514240.1)
Last updated on MAY 16, 2022
Applies to:
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
The Oracle Database Instance startup failed after Patching OCI DB system from Cloud UI
In Oracle Database alert log file, we will have following message reported
WARNING: group 2 (RECO) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 2 is being dismounted.
WARNING: ASMB force dismounting group 2 (RECO) due to missing disks
SUCCESS: diskgroup RECO was dismounted
Sun Mar 03 10:10:36 2019
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+RECO/ORCL_IAD1D8/CONTROLFILE/current.256.1976719585'
ORA-17503: ksfdopn:2 Failed to open file +RECO/ORCL_IAD1D8/CONTROLFILE/current.256.1976719585
ORA-15001: diskgroup "RECO" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: ALTER DATABASE MOUNT...
NOTE: ASMB mounting group 2 (RECO)
or
NOTE: ASMB mounting group 1 (DATA)
NOTE: ASM background process initiating disk discovery for grp 1 (reqid:0)
WARNING: group 1 (DATA) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 1 is being dismounted.
WARNING: ASMB force dismounting group 1 (DATA) due to missing disks
SUCCESS: diskgroup DATA was dismounted
Sun Mar 03 10:56:57 2019
ORA-01565: Unable to open Spfile +DATA/ORCL_IAD1D8/PARAMETERFILE/spfile.268.976719827.
ORA-15040: diskgroup is incomplete
WARNING: group 2 is being dismounted.
WARNING: ASMB force dismounting group 2 (RECO) due to missing disks
SUCCESS: diskgroup RECO was dismounted
Sun Mar 03 10:10:36 2019
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+RECO/ORCL_IAD1D8/CONTROLFILE/current.256.1976719585'
ORA-17503: ksfdopn:2 Failed to open file +RECO/ORCL_IAD1D8/CONTROLFILE/current.256.1976719585
ORA-15001: diskgroup "RECO" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: ALTER DATABASE MOUNT...
NOTE: ASMB mounting group 2 (RECO)
or
NOTE: ASMB mounting group 1 (DATA)
NOTE: ASM background process initiating disk discovery for grp 1 (reqid:0)
WARNING: group 1 (DATA) has missing disks
ORA-15040: diskgroup is incomplete
WARNING: group 1 is being dismounted.
WARNING: ASMB force dismounting group 1 (DATA) due to missing disks
SUCCESS: diskgroup DATA was dismounted
Sun Mar 03 10:56:57 2019
ORA-01565: Unable to open Spfile +DATA/ORCL_IAD1D8/PARAMETERFILE/spfile.268.976719827.
Changes
After applying PSU Patch, the database instance was started using sqlplus
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 |