Database Networking (MOSC)

MOSC Banner

How to connect Splunk using DB Connect and Oracle Wallet

edited Mar 30, 2023 12:20AM in Database Networking (MOSC) 11 commentsAnswered

We are using Splunk version 8.2.2, soon to upgrade to 9.x in a few months.

Splunk uses DB Connect version 3.5.1 to connect to Oracle over jdbc:oracle:thin client.

We use this to run queries which populate Splunk search results. Our current non-wallet connection string is

jdbc:oracle:thin:@SERVERNAME:1526:SIDNAME

In order to implement the Wallet (Oracle SEPS), we wish to change the username to "/" with no password, and the connect string to

jdbc:oracle:thin:@CONNECTION?TNS_ADMIN=\\UNC\Wallets

This causes an error:

IO Error: Invalid connection string format, a valid format is: "host:port:sid"

❓️ How can we set the connection properties in Splunk?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center