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 jdbc:oracle:thin:@server1.example.com:1521/database1.example.com.
Hope this helps.
This worked for me. Thank you a ton!
What version of splunk? What version of DBX? What is the error you are getting?
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.
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