Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to make clm application to connect DB on tcps port

visarMar 15 2018 — edited Mar 19 2018

we are using clm 6.0.3 with liberty profile and oracle db 12c for our applications.

Java.runtime= Java™ SE Runtime Environment (pxa6470_27sr3fp40-201604220_01 (SR3 FP40))

our IBM clm applications are hosted on Websphere Liberty Server 8.5.5.9 (wlp-1.0.12.cl50920160227-1523)

java version - 1.7.0_75

ojdbc driver-ojdbc7.jar

Implementation setup

______________________

We want to enable mutual ssl authentication with DB server to application.

Steps followed.

We are using the default keystore of liberty profile , where we imported the DB certificate and also extracted the applicationcertificate and imported the same oracle DB wallet.

we are using default server.xml file and startup file and java.security files. For making this tcps communication, where exactly we need to make changes

Issue detrails

______________

we are able to connect the db through tcp string. But not able to connect by tcps string.

           tcp string – thin:jts-user/{password}@//192.168.100.216:1521/vmtestdb

           tcps String - thin:jts_user/{password}@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.168.100.216)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=vmtestdb)))

  

  

Error Code:-

______________

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:445)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:464)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)

... 80 more

Caused by: oracle.net.ns.NetException: The ssl protocol specified is not supported.

at oracle.net.nt.TcpsConfigure.configureVersion(TcpsConfigure.java:179)

at oracle.net.nt.TcpsNTAdapter.setSSLSocketOptions(TcpsNTAdapter.java:253)

at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:172)

at oracle.net.nt.ConnOption.connect(ConnOption.java:133)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:411)

... 85 more

Caused by: java.lang.IllegalArgumentException: SSLv2Hello is not a recognized protocol.

at com.ibm.jsse2.pb.a(pb.java:105)

at com.ibm.jsse2.pb.b(pb.java:96)

at com.ibm.jsse2.pb.<init>(pb.java:115)

at com.ibm.jsse2.qc.setEnabledProtocols(qc.java:805)

at oracle.net.nt.TcpsConfigure.configureVersion(TcpsConfigure.java:175)   

      

  

For reproducing the issue, we will get the same error when we put tcps string to connect the db.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2018
Added on Mar 15 2018
5 comments
528 views