Hi,
We have an Oracle RAC environment with dataguard. We don't know which instance is the active one and which is the passive one. The JDBC connection string looks like:
jdbc:oracle:thin:@(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = <hostA-scan>) (PORT = 1532))
(ADDRESS = (PROTOCOL = TCP) (HOST = <hostB-scan>) (PORT = 1532))
(CONNECT_DATA =
(SERVICE_NAME = kudaps_rw.T.pnet.ch)
(CONNECT_TIMEOUT=5)(RETRY_COUNT=2)
)
)
Any idea how to make DB Connect 'dataguard aware'?
Cheers,
Andy
Because DBX builds the JDBC uri dynamically from parameters in the database.conf file (host, port, and service name), I do not believe this kind of connect string is currently possible.
Basically we should have a list of hosts and ports DB connect tries to connect to.