Good morning fellow members
I'm having a issue with my Dataguard configuration and i need some help. The issue is that, whenever i try to execute the command SHOW CONFIGURATION on the Broker it throws the following error:
DGMGRL> SHOW CONFIGURATION;
Configuration - tpmp_dataguard
Protection Mode: MaxPerformance
Databases:
test - Primary database
testdrp - Physical standby database
Error: ORA-16665: timeout waiting for the result from a database
Fast-Start Failover: DISABLED
The redo logs are being shipped and applied on the standby, so far the redo transport is working fine. It seems that the standby is not able to reach the primary. The following are details of the configuration:
Primary:
Oracle RAC 2-nodes 11.2.0.4.0 under solaris 11.
Standby:
Single instance 11.2.0.4.0 under solaris 11
Listener output on Standby
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 12.2.0.1.0 - Production
Start Date 10-MAR-2020 16:42:29
Uptime 50 days 19 hr. 24 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12c/oracleasm/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/SRVBBDDCTG01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SRVBBDDCTG01)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.167.1.9)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_DATA" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_FRA" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_FRA12C" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "test.domain.local" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "testdrp.domain.local" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "testdrp_DGB.domain.local" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Listener output on Primary:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 12.2.0.1.0 - Production
Start Date 15-MAR-2020 13:40:58
Uptime 45 days 22 hr. 27 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/product/12c/oracleasm/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/SRVDBPRD01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.25)(PORT=1521)))
Services Summary...
Service "+APX" has 1 instance(s).
Instance "+APX1", status READY, has 1 handler(s) for this service...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_FRA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_INFRA12C" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_OCFS" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "test.domain.local" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "testXDB.domain.local" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "test_DGB.domain.local" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
Service "test_srv.domain.local" has 1 instance(s).
Instance "test1", status READY, has 1 handler(s) for this service...
The command completed successfully
Any help will be really appreciated.
Regards.
DMX