topic Re: Splunk DB Connect: How to connect to Oracle DB? in All Apps and Add-ons

Splunk DB Connect: How to connect to Oracle DB?

uma2356 — Mon, 15 May 2017 11:25:23 GMT

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

Re: Splunk DB Connect: How to connect to Oracle DB?

tmuth_splunk — Fri, 14 Jul 2017 20:45:36 GMT

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

Re: Splunk DB Connect: How to connect to Oracle DB?

diogofgm — Mon, 07 Aug 2017 13:08:59 GMT

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.

Re: Splunk DB Connect: How to connect to Oracle DB?

rmoss84 — Tue, 08 Aug 2017 21:03:17 GMT

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.

Re: Splunk DB Connect: How to connect to Oracle DB?

YaaseenSalie1 — Wed, 27 Jan 2021 10:53:21 GMT

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

Re: Splunk DB Connect: How to connect to Oracle DB?

yackle_official — Fri, 02 Dec 2022 17:17:19 GMT

This worked for me. Thank you a ton!