Return
-
Title
IO Error: The Network Adapter could not establish the connection -
Description
The Oracle database agent was unable to collect data and connect to database server, when user activated "Inbound connections that do not match a rule are blocked" under "Windows Firewall with Advanced Security", with the below exceptions.
ECHO <fb8be857-fbcf-4747-973d-295a8570e581/DB_Oracle/5.7.5.7/DB_Oracle/OracleXXXX-agent> ERROR [ConnectionManagementThread-[OraclePool-OracleXXXX-XXX][OracleProfile{host='XXXXX', instance='XXX', username='XXXXX', asSysDBA=false, ports='1521', properties={oracle.jdbc.ReadTimeout=900000}}]] com.quest.qsi.fason.framework.connections.jdbc.JDBCConnectionImpl - Failed to create new connection. [OracleProfile{host='XXXXX', instance='XXX', username='XXXXX', asSysDBA=false, ports='1521', properties={oracle.jdbc.ReadTimeout=900000}}]java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connectionBut the agents could successfully collect data when the above option was disabled.
-
Cause
Although the credentials were fine, whenever "Inbound connections that do not match a rule are blocked" under "Windows Firewall with Advanced Security" was activated, the database agent was not able to communicate via the port 1521, as there were no rules which could have allowed communication from port 1521. -
Resolution
Creating a Firewall rule to allow communication from port 1521 first and then activating "Inbound connections that do not match a rule are blocked" resolved the issue as after creation of rule database agent was able to communicate properly with server via the opened up port. -
Additional Information
Below errors were also found from the agent logs. oracle.net.ns.NetException: The Network Adapter could not establish the connection java.net.ConnectException: Connection refused com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkConnectionException: IO Error: The Network Adapter could not establish the connection- Profile:OracleProfile{host='OracleXXXX', instance='XXX', username='XXXXX', asSysDBA=false, ports='1521', properties={oracle.jdbc.ReadTimeout=900000}}