Skip to Main Content

transaction application continuity

cptkirkshJun 16 2022

I thought I might put this out here while I work through my little problem. I am trying to test TAC on an Oracle 19 2 node RAC. I have followed the steps from this link
(0 Bytes)Here is the config for the service for the TAC.
[oracle@rac1 ~]$ srvctl config service pdb_tac database -db orcl
Service name: pdb_tac
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: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: pdb
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: orcl1,orcl2
Available instances:
CSS critical: no
Service uses Java: false
When I run the connection string like this it times out on the connection.
(DESCRIPTION = (CONNECT_TIMEOUT=120) (RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST =(LOAD_BALANCE=on)(ADDRESS = (PROTOCOL = TCP)(HOST=rac-scan)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME = pdb_tac.localdomain)))

if I remove the (CONNECT_TIMEOUT=120) (RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3) it will connect.

My question is why does that cause my connection to not connect? Thanks in advance

Comments
Post Details
Added on Jun 16 2022
0 comments
3 views