Solved: db connect oracle error

a212830 · ‎03-25-2013

Hi,

I installed db connect, including the jdk. I am now attempting to connect to oracle, and I'm getting a "JDBC driver (oracle.jdbc.OracleDriver) for database type Oracle is not installed" error.

I'm assuming that Oracle drivers are needed. Is that correct? If so, where do they get installed within splunk?

rsennett_splunk · ‎03-25-2013

The installation location isn't unique to Splunk.
It is JAVA that has to find it so you can put it anywhere on the JAVA classpath or more commonly in the extensions directory of the JRE.
For JAVA JRE this is $JAVA_HOME/jre/lib/ext (i.e. /usr/lib64/jvm/jre-1.6.0-ibm/lib/ext)

The file will be ojdbc5.jar for Java 1.5, or ojdbc6.jar for version 1.6

You might look here for the version you need:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Of course, you'll adjust that if you're not on Oracle 11g Release 2

With Splunk... the answer is always "YES!". It just might require more regex than you're prepared for!

View solution in original post

rsennett_splunk · ‎03-25-2013

The installation location isn't unique to Splunk.
It is JAVA that has to find it so you can put it anywhere on the JAVA classpath or more commonly in the extensions directory of the JRE.
For JAVA JRE this is $JAVA_HOME/jre/lib/ext (i.e. /usr/lib64/jvm/jre-1.6.0-ibm/lib/ext)

The file will be ojdbc5.jar for Java 1.5, or ojdbc6.jar for version 1.6

You might look here for the version you need:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Of course, you'll adjust that if you're not on Oracle 11g Release 2

With Splunk... the answer is always "YES!". It just might require more regex than you're prepared for!

db connect oracle error

Detecting Remote Code Executions With the Splunk Threat Research Team

Observability | Use Synthetic Monitoring for Website Metadata Verification

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk