JDBC URL Format Recommended for Connecting to DataGuard (Doc ID 2303116.1)

Last updated on OCTOBER 06, 2023

Applies to:

Goal

Customer is trying to connect to a data guard broker via our JDBC connections (DataSources) in WebLogic.

Here is the  Connection string in the TNSNames file:

 UATSIE.WORLD=

(DESCRIPTION_LIST=

(FAILOVER=true)

(LOAD_BALANCE=no)

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST= HOSTNAME1.COM)

(PORT=port)

)

(CONNECT_DATA=

(SERVER=dedicated)

(SERVICE_NAME=ABC)

)

)

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=HOSTNAME2.com)

(PORT=port)

)

(CONNECT_DATA=

(SERVER=dedicated)

(SERVICE_NAME=Service-name)

)

)

)

Having a hard time figuring out the proper way to create the string to connect to this. Is there any Oracle documentation that details the configuration steps ?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.