Test Connection to ATP DB On Private Subnet Through Agent Fails With Error "java.lang.Exception: Network Adapter could not establish the connection" And Connection From SQL Plus Works Fine From Same Agent Host
(Doc ID 2887779.1)
Last updated on DECEMBER 03, 2022
Applies to:
Oracle Integration-OIC - Version 21.2.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
ISSUE
----------
Test connection to ATP DB on private subnet through Agent fails with error.
Error:
---------------
<Aug 1, 2022 10:56:56,077 PM UTC> <Emergency> <oracle.dfw.incident> <BEA-000000> <incident 15 created with problem key "ICS-11070 [oic_server2][oracle.ics.webconsole.connection.test]">
<Aug 1, 2022 10:56:55,830 PM UTC> <Error> <oracle.ics.webconsole.connection.test> <ICS-11070> <Failed to test connection <Conection Name>. The failure message returned for connection ping is: Unable to establish connection. Please check connection parameters>
<Aug 1, 2022 10:56:57,772 PM UTC> <Error> <oracle.ics.webconsole.connection.test> <ICS-11071> <Failed to test connection <Conection Name>. The error cause returned for connection ping is: java.lang.Exception: Network Adapter could not establish the connection. Please check the wallet credentials and ensure database is reachable.>
<Aug 1, 2022 10:56:57,772 PM UTC> <Error> <oracle.ics.webconsole.connection.test> <ICS-11072> <Failed to test connection <Conection Name>. The error detail returned for connection ping is : Error Code: CLOUD-0005, Error Message: Unable to establish connection. Please check connection parameters, Error Cause: java.lang.Exception: Network Adapter could not establish the connection. Please check the wallet credentials and ensure database is reachable.
java.lang.Exception: Network Adapter could not establish the connection. Please check the wallet credentials and ensure database is reachable.
at oracle.tip.tools.ide.adapters.db.common.plugin.connection.CloudDatabaseRemoteConnector.ping(CloudDatabaseRemoteConnector.java:163)
at oracle.tip.tools.ide.adapters.db.atp.plugin.connection.CloudDatabaseConnection.ping(CloudDatabaseConnection.java:205)
at oracle.ics.webconsole.model.manager.AppConfigManager.testApplicationInstance(AppConfigManager.java:2476)
at oracle.ics.services.rest.suite.v1.implementation.ConnectionResourceBuilderImpl.validateConnectionMultipart(ConnectionResourceBuilderImpl.java:2271)
at oracle.ics.services.rest.suite.v1.implementation.ConnectionResourceBuilderImpl.testConnection(ConnectionResourceBuilderImpl.java:448)
at oracle.ics.services.rest.suite.v1.ConnectionSuiteRestService.testConnectionWithAttachments(ConnectionSuiteRestService.java:449)
at sun.reflect.GeneratedMethodAccessor6869.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
STEPS TO REPRODUCE:
--------------------------
- Create connection to ATP DB (on Private subnet) through Agent.
- Test connection
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 |
Cause |
Solution |
References |