Splunk DB Connect: How to connect to Oracle DB?

[uma2356]

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

[rmoss84]

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 jdbc:oracle:thin:@server1.example.com:1521/database1.example.com.

Hope this helps.

[yackle_official]

This worked for me. Thank you a ton!

[tmuth_splunk]

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

[diogofgm]

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.

[YaaseenSalie1]

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