How to enable WLP SSL connection with Oracle database
We have CLM 6.0.3 environment with bundled Liberty profile. Our requirement is to have SSL connection between the application and Oracle database.
Accepted answer
There is way to establish secure db connection with Oracle. The detailed steps can found in Missing documentation on how to establish secure Oracle DB connection with ELM (537626)
One other answer
This old post gives a pretty good example, for WebSphere Application Server that is.
https://jazz.net/forum/questions/214634/how-can-i-use-a-secure-oracle-port-for-my-clm-repositories
For the equivalent in WLP, notice the first sentence in the answer - you can pass the necessary configuration parameters through the JVM using Java parameters. If you open the server.startup script, you will see many lines containing "JAVA_OPTS", and that's where you add the Java parameters.
Note that with the "javax.net.ssl.trustStore" parameter, the JVM uses a non-default truststore, and you may need to re-import certificates from other servers if you did cross-server SSL certificate import before.
Comments
Hi Donald,
JAVA_OPTS="$JAVA_OPTS -Djavax.net.ssl.trustStore=/opt/truststore/clienttrststre.jks"
JAVA_OPTS="$JAVA_OPTS -Djavax.net.ssl.trustStoreType=JKS"
JAVA_OPTS="$JAVA_OPTS -Djavax.net.ssl.trustStorePassword=xx"
JAVA_OPTS="$JAVA_OPTS -Djavax.net.ssl.keyStore=/opt/keystre/clit.jks"
JAVA_OPTS="$JAVA_OPTS -Djavax.net.ssl.keyStoreType=JKS"
It appears that you have the exact same error as the other user did.
https://jazz.net/forum/questions/250527/sslv2hello-is-not-a-recognized-protocol
Check my answer there, and you may have to take it up to Oracle Support if the Tech Doc cannot resolve your issue.