-
Título
Error: "The Network Adapter could not establish the connection" -
Descripción
While using the Auto Discovery agent to discover a RAC database the following error appears for one node after clicking on "Validate connectivity":
"The Network Adapter could not establish the connection"
In the log file the following error appears:
---
2019-05-08 11:30:00.261 INFO [OracleInstaller-1557304053925-1557304121138-1557304129250] com.quest.qsi.fason.oracle.installer.callback.database.DBOInstallerDbConnectionValidation - [Node connection fail:Timeout occurred: 60[seconds] - Profile:OracleProfile{host='nikiradb01', instance='YourInstance', username='FOGLIGHT', asSysDBA=false, ports='1521'}]2019-05-08 11:31:24.332 ERROR [ConnectionManagementThread-[OraclePool-Oracle-Installer]-[Wed May 08 11:30:00 AST 2019][OracleProfile{host='YourHost', instance='YourInstance', username='FOGLIGHT', asSysDBA=false, ports='1521'}]] com.quest.qsi.fason.framework.connections.jdbc.JDBCConnectionImpl - Failed to create new connection. [OracleProfile{host='YourHost', instance='YourInstance', username='FOGLIGHT', asSysDBA=false, ports='1521'}]java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
--- -
Causa
Misconfigured Oracle listener or DNS entries on the RAC nodes
-
Resolución
Please check the listener.ora and the tnsnames.ora if the configuration is correct, for example: ports, host names, ...
If that does not help, check the DNS setup on each node.
After corrected the configuration, please validate the connectivity again.
-
Información adicional
To test the DB connection, please use SQL*Plus or Toad to do a remote connection to the single RAC nodes.