In our Oracle RAC environment with dataguard, how do we make Splunk DB Connect 'dataguard aware'?

[kochera]

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

[pmdba]

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.

[kochera]

Basically we should have a list of hosts and ports DB connect tries to connect to.