DG association fails with : CDG-50606 | One or more instances of db ‘<dbname>’ are disabled or down or not in 'READ WRITE' mode
(Doc ID 2968347.1)
Last updated on MAY 02, 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
Data guard association fails at stage VERIFY_DG_PRIMARY with ORA-01034 error while logging in to the database, despite all the instances being up and running.
2023-08-15 12:11:48.680137 - INFO : The (EXADB) database is running on all the nodes
2023-08-15 12:11:48.683567 - Running Check: db_status
2023-08-15 12:11:48.690095 - Checking Database Status
2023-08-15 12:11:48.696578 - Output from cmd /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/srvctl status database -d EXADB_PR -f run on localhost is:
2023-08-15 12:11:49.459912 - Instance EXADB1 is running on node oraexadb01 <<<<<<
Instance EXADB2 is running on node oraexadb02 <<<<<<
<exe>
<ts>2023-08-15 12:11:48.699789</ts>
<cmd>/u02/app/oracle/product/19.0.0.0/dbhome_1/bin/srvctl status database -d EXADB_PR -f</cmd>
<tsb>1692101508.702984</tsb>
<tse>1692101509.456071</tse>
<ret>0</ret>
<out>Instance EXADB1 is running on node oraexadb01
Instance EXADB2 is running on node oraexadb02</out>
</exe>
2023-08-15 12:11:49.463351 - cmd took 0.753086805343628 seconds
2023-08-15 12:11:49.466817 - Checking Database mode
2023-08-15 12:11:49.474578 - Output from sql select open_mode from gv$database is:
<exe>
<ts>2023-08-15 12:11:49.471456</ts>
<sql>select open_mode from gv$database</sql>
<tsb>1692101509.471456</tsb>
2023-08-15 12:11:49.481995 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set newpage none set feedback off prompt =START= select open_mode from gv$database; quit
2023-08-15 12:11:51.011606 - select open_mode from gv$database
*
ERROR at line 1:
ORA-01034: ORACLE not available <<<<
Process ID: 0
Session ID: 0 Serial number: 0
2023-08-15 12:11:48.683567 - Running Check: db_status
2023-08-15 12:11:48.690095 - Checking Database Status
2023-08-15 12:11:48.696578 - Output from cmd /u02/app/oracle/product/19.0.0.0/dbhome_1/bin/srvctl status database -d EXADB_PR -f run on localhost is:
2023-08-15 12:11:49.459912 - Instance EXADB1 is running on node oraexadb01 <<<<<<
Instance EXADB2 is running on node oraexadb02 <<<<<<
<exe>
<ts>2023-08-15 12:11:48.699789</ts>
<cmd>/u02/app/oracle/product/19.0.0.0/dbhome_1/bin/srvctl status database -d EXADB_PR -f</cmd>
<tsb>1692101508.702984</tsb>
<tse>1692101509.456071</tse>
<ret>0</ret>
<out>Instance EXADB1 is running on node oraexadb01
Instance EXADB2 is running on node oraexadb02</out>
</exe>
2023-08-15 12:11:49.463351 - cmd took 0.753086805343628 seconds
2023-08-15 12:11:49.466817 - Checking Database mode
2023-08-15 12:11:49.474578 - Output from sql select open_mode from gv$database is:
<exe>
<ts>2023-08-15 12:11:49.471456</ts>
<sql>select open_mode from gv$database</sql>
<tsb>1692101509.471456</tsb>
2023-08-15 12:11:49.481995 - DEBUG: SQL Executing set hea off set pagesize 5000 set linesize 400 set newpage none set feedback off prompt =START= select open_mode from gv$database; quit
2023-08-15 12:11:51.011606 - select open_mode from gv$database
*
ERROR at line 1:
ORA-01034: ORACLE not available <<<<
Process ID: 0
Session ID: 0 Serial number: 0
Primary database was up and running and allowing connections.
Issue happens only when the DG association is attempted.
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 |
References |