AE install fails with [CAUAJM_E_112508] error

Products

• Autosys Workload Automation

Issue/Introduction

Trying to upgrade from 11.3.6 SP8 to 12.0 on our Qualification environment.

The upgrade went successfully on our LAB environment, but not in QA. 

Install 64b oracle client version HC-12.1.0.2

-Define entry in tnsnames.ora (since it's mandatory during the installation, we don't use it otherwise)

ORACL=(DESCRIPTION_LIST=(LOAD_BALANCE=OFF) (FAILOVER=ON) (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3) (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORACL)))(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORACL))))

sqlplus aedbadmin/password@ORACL -> works

Launch the installation -> FAILED with the message

Error:
[CAUAJM_E_112508] An error occurred while connecting to the "ORACL" database
server.
java.sql.SQLRecoverableException: IO Error: SO Exception was generated

 

Environment

Release : 12.0

Component : WORKLOAD CONTROL CENTER

Cause

When an installer runs database check validates database connection through jdbc jar file, so it expects tnsnames.ora file in correct format otherwise it treats as invalid tnsnames file.

Resolution

To resolve the error, need to update tnsnames.ora file entries in correct format.

below example would help:

net_service_name= 
 (DESCRIPTION= 
   (ADDRESS=(protocol_address_information))
   (CONNECT_DATA= 
     (SERVICE_NAME=service_name)))