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!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...