topic In our Oracle RAC environment with dataguard, how do we make Splunk DB Connect 'dataguard aware'? in All Apps and Add-ons

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

kochera — Fri, 09 Jan 2015 13:28:07 GMT

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

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

kochera — Fri, 09 Jan 2015 13:44:03 GMT

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

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

pmdba — Wed, 14 Jan 2015 00:10:31 GMT

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.