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 / / 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: Unable to initialize the key store.
… 48 common frames omitted
Caused by: SSO not found
at java.base/
… 49 common frames omitted
Caused by: SSO KeyStore not available
at java.base/
at java.base/
at java.base/
… 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 file from the wallet, un-comment the JKS properties, and comment the poperty.

In case of any problem, follow this manual.

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