Install with Oracle autonomous database

I have configured an Ubuntu 20.04 LTS instance with sonarqube-8.3.1
I’m trying to connect to Oracle autonomous database from OCI free tier.
jdbc driver is copied to the folder extensions/jdbc-driver/oracle/ it comes from SQLcl 19.4.

-rw-r–r-- 1 sonar gsonar 249 May 7 13:22 README.txt
-rw-r–r-- 1 sonar gsonar 4448361 May 23 15:59 ojdbc8.jar

Connection, tested with oracle client is working fine, there is no network error.

But can’t connect to the database and I don’t know why. the first error in the stack-trace is
“SSO KeyStore not available”

Any clue?

Detailed stacktrace with the connection used.

2020.05.24 11:44:06 INFO web[o.s.s.p.LogServerVersion] SonarQube Server / 8.3.1.34397 / 054c18b025be038b6343115894bf3ade0508f1e9
2020.05.24 11:44:06 INFO web[o.sonar.db.Database] Create JDBC data source for jdbc:oracle:thin:@db202005092134_medium?TNS_ADMIN=/home/ubuntu/db
2020.05.24 11:45:07 ERROR web[o.s.s.p.PlatformImpl] Web server startup failed
java.lang.IllegalStateException: Fail to connect to database

Caused by: oracle.net.ns.NetException: Unable to initialize the key store.
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:619)
at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:324)
… 48 common frames omitted
Caused by: java.security.KeyStoreException: SSO not found
at java.base/java.security.KeyStore.getInstance(KeyStore.java:878)
at oracle.net.nt.CustomSSLSocketFactory.getKeyStoreInstance(CustomSSLSocketFactory.java:767)
at oracle.net.nt.CustomSSLSocketFactory.loadKeyStore(CustomSSLSocketFactory.java:901)
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:610)
… 49 common frames omitted
Caused by: java.security.NoSuchAlgorithmException: SSO KeyStore not available
at java.base/sun.security.jca.GetInstance.getInstance(GetInstance.java:159)
at java.base/java.security.Security.getImpl(Security.java:700)
at java.base/java.security.KeyStore.getInstance(KeyStore.java:875)
… 52 common frames omitted

Ok, I fix the issue
1.- The path to tnsmanes must end with “/” so the correct path was /home/ubuntu/db/
2- I can’t connect using using Oracle wallets but works fine with JKS. Just edit the ojdbc.properties file from the wallet, un-comment the JKS properties, and comment the oracle.net.wallet_location poperty.

In case of any problem, follow this manual.

https://www.oracle.com/database/technologies/java-connectivity-to-atp.html

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.