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
Sorry for the delay in getting back to you.
To resolve the above issue, we ended up having to do the following:
/opt/splunk/etc/apps/splunk_app_db_connect/drivers
/opt/splunk/etc/apps/splunk_app_db_connect/drivers/ojdbc8-libs
You will probably also need to do the following:
security.provider.7=oracle.security.pki.OraclePKIProvider
security.provider.3=oracle.security.pki.OraclePKIProvider
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
@wittenst1234 Thank you. These worked great.
Sorry for the delay in getting back to you.
To resolve the above issue, we ended up having to do the following:
/opt/splunk/etc/apps/splunk_app_db_connect/drivers
/opt/splunk/etc/apps/splunk_app_db_connect/drivers/ojdbc8-libs
You will probably also need to do the following:
security.provider.7=oracle.security.pki.OraclePKIProvider
security.provider.3=oracle.security.pki.OraclePKIProvider
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
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 🙂
You're welcome, happy to help! If you or cmwin2 can mark or vote for the solution, please do
Yes, just did it.
We're you able to find a solution to this? Seeking a solution to this problem as well. We're stumped.