db connect oracle error

[a212830]

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 · Accepted solution]

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