Hi all,
I have 2 nodes rac database 19c with 1 node Data Guard.
In my production I create the service for the pdb PDBMW called PDBMWSRV:
Service name: PDBMWSRV
Server pool:
Cardinality: 2
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: true
Global: false
Commit Outcome: true
Failover type: AUTO
Failover method:
Failover retries: 1
Failover delay: 3
Failover restore: AUTO
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: THROUGHPUT
TAF policy specification: NONE
Edition:
Pluggable database name: PDBMW
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 600 seconds
Drain timeout: 300 seconds
Stop option: immediate
Session State Consistency: AUTO
GSM Flags: 0
Service is enabled
Preferred instances: CDB11,CDB12
Available instances:
CSS critical: no
Service uses Java: false
Yesterday i power off the the data guard node and when I connect from sqlplus to the production service PDBMWSRV the exit hanging for 30 sec. When I use the default service PDBMW I dont have this issue.
In my tns I have:
PDBMWSRV =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclung.animasgr.net)(PORT = 1541))
(ADDRESS = (PROTOCOL = TCP)(HOST = oradrclung.animasgr.net)(PORT = 1541))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBMWSRV)
)
)
PDBMW =
(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclung.animasgr.net)(PORT = 1541))
(ADDRESS = (PROTOCOL = TCP)(HOST = oradrclung.animasgr.net)(PORT = 1541))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PDBMW)
)
)
What is the cause of this issue?