All Apps and Add-ons

Splunk DB Connect: How to connect to Oracle DB?

uma2356
Engager

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
Explorer

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
New Member

This worked for me. Thank you a ton!

0 Karma

tmuth_splunk
Splunk Employee
Splunk Employee

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

0 Karma

diogofgm
SplunkTrust
SplunkTrust

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

YaaseenSalie1
Observer

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!

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

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

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...