All Apps and Add-ons
Highlighted

Error when configuring DB Connect 3.1.4 and Oracle Wallets.

Explorer

Hello,

I'm trying to configure a DB Connect connection that uses Oracle Wallets, but keep running into the following error:

PKI classes not found. To use 'connect /' functionality, oraclepki.jar must be in the classpath: java.lang.NoClassDefFoundError: oracle/security/pki/OracleWallet

I've put the osdt_cert.jar, osdt_core.jar, ojdbc8.jar and oraclepki.jar in the splunk_app_db_connect/drivers directory, and I've tried several entries to put the above files in the java classpath via the General --> JVM Options in the GUI but nothing has seemed to work.

If you have any suggestions on how to resolve the above error, please let me know. Thanks

Dan

0 Karma
Highlighted

Re: Error when configuring DB Connect 3.1.4 and Oracle Wallets.

Engager

We're you able to find a solution to this? Seeking a solution to this problem as well. We're stumped.

Highlighted

Re: Error when configuring DB Connect 3.1.4 and Oracle Wallets.

Explorer

Sorry for the delay in getting back to you.

To resolve the above issue, we ended up having to do the following:

  • Whichever Oracle driver that you use (ojdbc8.jar, etc), put that file in the drivers dir: /opt/splunk/etc/apps/splunk_app_db_connect/drivers
  • Create another directory called this: /opt/splunk/etc/apps/splunk_app_db_connect/drivers/ojdbc8-libs
  • If you're using the version 7 of the drivers, then name it /opt/splunk/etc/apps/splunkappdb_connect/drivers/ojdbc7-libs instead. If you're using version 6, ojdbc6-libs should work as well
  • Put the following jar files in this new directory: oraclepki.jar osdtcert.jar osdtcore.jar

You will probably also need to do the following:

  • Modify the java.security for the java version that you're using. It will typically be in the following location: /jre/lib/security/java.security
  • If you are using the sso wallet (cwallet.sso), add an entry for the OraclePKIProvider towards the bottom of the provider list (the list that begins with security.provider.1, etc). Ex:

security.provider.7=oracle.security.pki.OraclePKIProvider

  • If you are using the PCS12 wallet (ewallet.p12), that needs to go in the third spot in the same list. Ex:

security.provider.3=oracle.security.pki.OraclePKIProvider

  • Make sure to renumber the rest of the providers below it if using this method (4, 5, 6, etc).

That should get you past the error above, but you might encounter other issues with configuring Oracle Wallets. If you run into other issues, let me know and I'll see what I can post. It might be easier for me to post the whole thing, let me know

Thanks

Dan

View solution in original post

0 Karma
Highlighted

Re: Error when configuring DB Connect 3.1.4 and Oracle Wallets.

Explorer

Thank you very very much! It worked just fine! cmwin2 and I were having a hard time attempting to make it work and the only missing piece to the puzzle was the ojdbc8-lib directory 🙂

0 Karma
Highlighted

Re: Error when configuring DB Connect 3.1.4 and Oracle Wallets.

Explorer

You're welcome, happy to help! If you or cmwin2 can mark or vote for the solution, please do

0 Karma
Highlighted

Re: Error when configuring DB Connect 3.1.4 and Oracle Wallets.

Explorer

Yes, just did it.

0 Karma
Highlighted

Re: Error when configuring DB Connect 3.1.4 and Oracle Wallets.

@wittenst1234 Thank you. These worked great.

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.