Failover connect string for pluggable databases (primary RAC + standby)
host1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBX READ WRITE NO
4 PDBY READ WRITE NO
5 PDBDT MOUNTED
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBX READ WRITE NO
4 PDBY READ WRITE NO
5 PDBDT MOUNTED
host2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBX READ WRITE NO
4 PDBY READ WRITE NO
5 PDBDT READ WRITE NO
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBX READ WRITE NO
4 PDBY READ WRITE NO
5 PDBDT READ WRITE NO
$ sqlplus system/**********@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host1-vip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = host2-vip)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = pdbdt)))
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 24 14:39:26 2020
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 24 14:39:26 2020
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
2