Testing Oracle Database Data Server Connection in ODI Fails with "java.security.NoSuchAlgorithmException: SSO KeyStore not available"
(Doc ID 2473941.1)
Last updated on DECEMBER 02, 2020
Applies to:
Oracle Data Integrator - Version 12.1.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
While testing a new Oracle Data Integration (ODI) data server connection to an Oracle database (using TCPS) with a collocated agent, the following error occurs:
2018-11-15 13:20:05.799 ERROR ODI-1592 Error occurred testing connection to dataserver with agent AGENT_TEST
2018-11-15 13:20:05.806 ERROR ODI-1131 Agent AGENT_TEST encountered an error: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
2018-11-15 13:20:05.809 ERROR oracle.odi.runtime.agent.ExecutionException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:170)
...
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:475)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:569)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:620)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:239)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1606)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:539)
... 13 more
Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.
at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketFactory(CustomSSLSocketFactory.java:350)
at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:120)
at oracle.net.nt.ConnOption.connect(ConnOption.java:162)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:431)
... 18 more
Caused by: oracle.net.ns.NetException: Unable to initialize the key store.
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:392)
at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketFactory(CustomSSLSocketFactory.java:327)
... 21 more
Caused by: java.security.KeyStoreException: SSO not found
at java.security.KeyStore.getInstance(KeyStore.java:628)
at oracle.net.nt.CustomSSLSocketFactory.getKeyManagerArray(CustomSSLSocketFactory.java:380)
... 22 more
Caused by: java.security.NoSuchAlgorithmException: SSO KeyStore not available
at sun.security.jca.GetInstance.getInstance(GetInstance.java:159)
at java.security.Security.getImpl(Security.java:695)
at java.security.KeyStore.getInstance(KeyStore.java:625)
... 23 more
The error occurs even after setting the "oracle.net.ssl_version" and "oracle.net.wallet_location" properties.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |