WCC installer failing while connecting to the database server

Products

• Autosys Workload Automation

Issue/Introduction

Getting below error while installing

Database Validation
-------------------

Error:
[CAUAJM_E_112508] An error occurred while connecting to the "xxxxxxxx"
database server.
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not
establish the connection

Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:903)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:820)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:80)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:820)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:624)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:208)
    at com.ca.autosys.db.connection.DBConnectionOracle.openConnection(DBConnectionOracle.java:194)
    ... 690 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
    at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:720)
    at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:586)
    at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:729)
    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:340)
    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1702)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:627)
    ... 697 more
Caused by: java.net.UnknownHostException: xxxxxxxx: Name or service not known
    at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
    at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:867)
    at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1302)
    at java.net.InetAddress$NameServiceAddresses.get(InetAddress.java:815)
    at java.net.InetAddress.getAllByName0(InetAddress.java:1291)
    at java.net.InetAddress.getAllByName(InetAddress.java:1144)
    at java.net.InetAddress.getAllByName(InetAddress.java:1065)
    at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:162)
    at oracle.net.nt.ConnOption.connect(ConnOption.java:195)
    at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:653)
    ... 702 more

Environment

WCC 12.X

All Unix environments

Cause

Cannot ping the database server xxxxxxxx from the machine that WCC is being installed on.

Resolution

Work with Unix System Administrators to get the hosts to resolve properly. The work around is to add the host's ip address and hostname to the /etc/hosts file.