All Apps and Add-ons

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

kochera
Communicator

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
Builder

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.

0 Karma

kochera
Communicator

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

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!