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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.