Forum Stats

  • 3,824,872 Users
  • 2,260,435 Discussions
  • 7,896,336 Comments

Discussions

transaction application continuity

cptkirksh
cptkirksh Member Posts: 89 Red Ribbon

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

Here is the config for the service for the TAC.

[[email protected] ~]$ 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