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

[dmacgillivray]

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

[dmacgillivray]

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.0_111"
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)

[jcoates_splunk]

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.

[dmacgillivray]

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.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

[vr2312]

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

[dmacgillivray · Accepted solution]

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..

[dmacgillivray]

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

"jdbc:oracle:thin:@my_host:1521:my_database"

("jdbc:oracle:thin:@my_host:1521:my_database")

[dmacgillivray]

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

[dmacgillivray]

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

[skender27]

Hi,

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

Thanks,
Skender