Command Line startloadplan.sh Fails when Standalone Agent is Configured with SSL

(Doc ID 2383585.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Symptoms

A Load plan will execute successfully in the Oracle Data Integrator (ODI) Studio client. However, running the same Load Plan via a command line errors out with the following message:

startloadplan.sh -INSTANCE=<ODIInstanceName> <load_plan_name> -AGENT_URL=<agent_url> 2018-02-26 09:57:59.921

NOTIFICATION Ignoring Exception in method isSupportsHeaderAuth() : java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)
2018-02-26 09:58:00.108 ERROR ODI-1651 Agent https://host:port/oraclediagent error while executing: https://host:port/oraclediagent:java.net.SocketException: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)

 The ...ODI/OracleDIAgent1/logs/oracledi/start_lp.log shows the following error:

[2018-03-07T09:11:13.875-08:00] [odi] [NOTIFICATION] [] [oracle.odi.agent] [tid: 1] [ecid: 0000M81SWf^1VckLGyd9if1Qc1ol000001,0] Ignoring Exception in method isSupportsHeaderAuth() : java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)
[2018-03-07T09:11:14.055-08:00] [odi] [ERROR] [ODI-1651] [oracle.odi.agent] [tid: 1] [ecid: 0000M81SWf^1VckLGyd9if1Qc1ol000001,0] Agent https://host:port/oraclediagent error while executing: https://host:port/oraclediagent:java.net.SocketException: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)[[
oracle.odi.runtime.agent.invocation.InvocationException: https://host:port/oraclediagent:java.net.SocketException: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:465)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartLoadPlan(RemoteRuntimeAgentInvoker.java:1561)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeStartLoadPlan(RemoteRuntimeAgentInvoker.java:1489)
at oracle.odi.StartLoadPlan.run(StartLoadPlan.java:139)
at oracle.odi.StartLoadPlan.main(StartLoadPlan.java:171)
Caused by: java.net.SocketException: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)
at javax.net.ssl.DefaultSSLSocketFactory.throwException(SSLSocketFactory.java:248)
at javax.net.ssl.DefaultSSLSocketFactory.createSocket(SSLSocketFactory.java:255)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.commons.httpclient.protocol.ReflectionSocketFactory.createSocket(ReflectionSocketFactory.java:116)
at org.apache.commons.httpclient.protocol.SSLProtocolSocketFactory.createSocket(SSLProtocolSocketFactory.java:130)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:393)
... 4 more
Caused by: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)
at java.security.Provider$Service.newInstance(Provider.java:1617)
at sun.security.jca.GetInstance.getInstance(GetInstance.java:236)
at sun.security.jca.GetInstance.getInstance(GetInstance.java:164)
at javax.net.ssl.SSLContext.getInstance(SSLContext.java:156)
at javax.net.ssl.SSLContext.getDefault(SSLContext.java:96)
at javax.net.ssl.SSLSocketFactory.getDefault(SSLSocketFactory.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.commons.httpclient.protocol.ReflectionSocketFactory.createSocket(ReflectionSocketFactory.java:112)
... 11 more
Caused by: java.security.UnrecoverableKeyException: Cannot recover key

 

Changes

 The Standalone Agent was configured for Secure Sockets Layer (SSL).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms