Database Administration (MOSC)

MOSC Banner

Failover connect string for pluggable databases (primary RAC + standby)

edited Dec 1, 2020 1:43AM in Database Administration (MOSC) 4 commentsAnswered ✓

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


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

$ 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center