Can someone post steps on how to configure Oracle connection using Splunk DB connect?
I've installed Splunk DB Connect
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:
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.
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.