Hi, in setting up Splunk DB connect on one of my search heads, I ran into the same errors. In the end, this is what I had to do:
On Red Hat EL5 server:
$ yum install java-1.6.0-openjdk-devel
$ /usr/sbin/alternatives --config java (only had one, just installed, selected that installation)
$/usr/sbin/alternatives --config javac (same as above)
The java binary is now in: /usr/lib/jvm/java-1.6.0-openjdk.x86_64/bin/java
What you have to put in the Splunk DB connect app as the java home is: /usr/lib/jvm/java-1.6.0-openjdk.x86_64/ (this works!)
Also, if you are going to use the app for Oracle, you can grab the ojdbc6.jar file from: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html You need to put it in: /Splunk/etc/apps/dbx/bin/lib. chown splunk:splunk ojdbc6.jar then restart Splunk and you'll be off and running.
I hope it works for you!
... View more