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
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..
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)
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.
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)
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
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..
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")
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
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
Hi,
I get exactly the same error while trying to conect to a AWS Oracle database.
Any suggestions?
Thanks,
Skender