AE install fails with [CAUAJM_E_112508] error

book

Article ID: 212876

calendar_today

Updated On:

Products

CA Workload Automation AE

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/[email protected] -> 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

 

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.

Environment

Release : 12.0

Component : WORKLOAD CONTROL CENTER

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)))