All Apps and Add-ons
Highlighted

Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Communicator

I am concerned there is a real issue with Oracle Drivers on the latest Splunk DB Connect app.
ojdbc6.jar & ojdbc7.jar do not seem to work at all.

I am wondering if I am just grabbing the incorrect thin driver from Oracle.

IE: The Drivers Tab in settings displays these drivers as installed, but (unsupported) I am concerned as the overview explaining the app says Oracle is supported. I must be doing something wrong.

Screen from Driver Tab (ojdbc6.jar)
Oracle (unsupported) 11.1
Oracle Service (unsupported) 11.1

& also attempt at 12

Screen from Driver Tab (ojdbc7.jar)
Oracle (unsupported) 12.1
Oracle Service (unsupported) 12.1

Thanks,
Daniel MacGillivray
DTCC

0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Communicator

Sorry all, how about an error message 🙂

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Contributor

Hi,

I get exactly the same error while trying to conect to a AWS Oracle database.
Any suggestions?

Thanks,
Skender

0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Communicator

All, I am going to try this.
When your getting this error "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

Solution: Open Services, and start OracleServiceXE, after that try to connect...
Funny thing, I know the listener is running on this host..

View solution in original post

0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Communicator

Manually Wrapping the connection string not working either, with parenthesis and / or quotes.

"jdbc:oracle:thin:@myhost:1521:mydatabase"

("jdbc:oracle:thin:@myhost:1521:mydatabase")

0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Communicator

Just figured it out. Unfortunately you have to be absolutely sure that this driver is set up per the database Matrix instructions.

http://download.oracle.com/otn/utilities_drivers/jdbc/11204/ojdbc6.jar

0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Communicator

Hey DB connectors,

I am going to assume that this base Java version(below) is my issue. I believe Mr Coates let me know this on the get go for the new version. I believe he mentioned Version 8 is absolutely necessary for Oracle Java.

Do you all concur?

--Our Server below--
java -version
java version "1.7.0111"
OpenJDK Runtime Environment (rhel-2.6.7.2.el6
8-x86_64 u111-b01)
OpenJDK 64-Bit Server VM (build 24.111-b01, mixed mode)

Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Splunk Employee
Splunk Employee

Yup. OpenJDK version 7 isn't Oracle JDK version 8. You should be seeing a red dot and "RPC Server: Down" in your nav bar, and you should be seeing a red border on the Settings - JRE Installation Path box.

0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Communicator

Hi Jcoates,

I see that I did have this version in /opt. But the prereq clearly states V31 of 1.8
Does that mean the build # below? or the version suffix?

The GUI shows build 25.91-b14 has the green light
but that may not be enough.

Thanks in advance.

java version "1.8.091"
Java(TM) SE Runtime Environment (build 1.8.0
91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

0 Karma
Highlighted

Re: Splunk DB Connect 2.3.0: Why do Oracle drivers ojdbc6.jar and ojdbc7.jar not seem to work?

Contributor

You might need to go and check on the server where this is actually installed and update the path accordingly.

After update, for me , it was

/usr/local/jdk1.8.0_91/jre

0 Karma