Hi,
in my case I have:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
What I need is to communicate from "database" to web service over https using this certificate "Server certificate for establishing TLS session" (http://datoteke.durs.gov.si/dpr/files/test-tls.cer ).
The problem I have is that the "web service provider" has disabled TLS1.0 protocol (only TLS1.1 and TLS1.2 are supported). Since now my code worked well using java stored procedure + plsq as wrapper to communicate with web service.
Now when they have disabled TLS1.0, I get a Java error (javax.net.ssl.SSLHandshakeException: Received fatal alert: handshake_failure) an error because JVM on the database does not support TLS1.1. and TLS1.2.
What is the best way to resolve this kind of a problem?
1.) Is there maybe some "patch" for 11.2.0.4.0 to upgrade only JVM on database side? because currently on the database is installed Java 1.6.0_43 version but if I could install 1.6.0_121 (http://www.oracle.com/technetwork/java/javase/overview-156328.html#R160_121 ) this will resolve my problem.
2.) Is there a way to use/install a certificate (above) into Oracle wallet? and move logic from Java stored procedure into PLSQL procedures using UTL_HTTP? (I'm using Java stored procedures because I must sign XML and send signed XML over https to the external company)
3.) some third options?
thank you
Peter