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:
(ADDRESS = (PROTOCOL = TCP) (HOST = <hostA-scan>) (PORT = 1532))
(ADDRESS = (PROTOCOL = TCP) (HOST = <hostB-scan>) (PORT = 1532))
(SERVICE_NAME = kudaps_rw.T.pnet.ch)
Any idea how to make DB Connect 'dataguard aware'?
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.