All Apps and Add-ons

Splunk DB Connect: How to connect to Oracle DB?


Can someone post steps on how to configure Oracle connection using Splunk DB connect?
I've installed Splunk DB Connect
Java jdk-8u71-windows-x64
i copied the ojdbc6 &7 jars and i'm still not able to establish a db connection to Oracle


I was having the same issue until I changed the query for the connection. Try this:

Under the connection, click on the checkbox for "Edit JDBC URL"

Use the format: jdbc:oracle:thin:<host>@:1521/<db>

For us, it wouldn't work unless you used the FQDN on both the host and the database. An example of this would be

Hope this helps.

New Member

This worked for me. Thank you a ton!

0 Karma

Splunk Employee
Splunk Employee

What version of splunk? What version of DBX? What is the error you are getting?

0 Karma


I'm having the same problems connecting to oracle db. Currently using 6.6.2 and Splunk DB Connect 3.0.3.

Currently if I use the proper service name, I get an error saying Connection is invalid! "Internal server error, originalErrorMessage=IO Error: The Network Adapter could not establish the connection".
If I use a random service name I get a message saying Connection is invalid! "Internal server error, originalErrorMessage=Listener refused the connection with the following error: ORA-12514, TNS: listener does not currently know of service requested in connect descriptor".

Already tested using ojdbc6 and 7 both unsuccessfully.

I already checked a number of answers about this ORA-12514 but none pointed me in the right direction.

Hope I was able to help you. If so, some karma would be appreciated.
0 Karma


Hi @diogofgm , I'm struggling with this exact issue, did you manage to get pass it? If so, please could you share it with me. Thanks

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...