Cannot Create A New Datasource In AACG Instance - Caused by: java.net.SocketTimeoutException: connect timed out (Doc ID 2041747.1)

Last updated on AUGUST 24, 2015

Applies to:

Oracle Preventive Controls Governor - Version 7.3.1 and later
Information in this document applies to any platform.

Symptoms

On : 8.6.5 version, Application Access Contr. Gov.

AACG is used to report segregation of duties(SOD) in the business applications. DataSource Test Connection Failed in GRC, When configured the Application datasource.


ERROR
-----------------------

Application:

When trying to save the datasource created, it takes a long time and then time out.

Grc.log:

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:398)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:438)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:711)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:257)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)
... 105 more
Caused by: java.net.SocketTimeoutException: connect timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Setup and Administration > Manage Application Datasources.
2. Create a datasource.
3. Save and Test Connection.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create datasource and run ETL for the datasource.

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