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:

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

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