All Apps and Add-ons

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

dmacgillivray
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
1 Solution

dmacgillivray
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

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

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

0 Karma

vr2312
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

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

0 Karma

dmacgillivray
Communicator

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")

0 Karma

dmacgillivray
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

dmacgillivray
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

skender27
Contributor

Hi,

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

Thanks,
Skender

0 Karma
Get Updates on the Splunk Community!

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...