Not able to connect oracle DB from Devtest Workstation

Article Id: 75037
Status: Published
Updated On: 29-03-2018 10:10
Products:
CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder)
Issue/Introduction:

Trying to  connect to Oracle DB using a JDBC step in DevTest, gives the below error.  

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) 
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) 

Cause:

We tried to  Telnet to the host and port  Oracle DB was running,  and got an error. 
telnet <host> 1521 

"java.sql.SQLException: IO Error: The Network Adapter could not establish the connection" - This error message is Oracle's way of saying either 'Connection refused' or 'Connection timeout' or 'no route to host' or 'unknown host'. 

It might be that there is no route to the host, nothing listening at the IP:port you specified, or there is a firewall in the way. And that includes a possible Windows firewall on the server host itself. 

Environment:

DevTest 10.1

Resolution:

Work with your Network team to resolve the Oracle issue.  

Additional Information:

https://community.oracle.com/thread/2275195