CAUAJM_E_112508 An error occurred while connecting to the "DATABASE_NAME" database

Products

• CA Workload Automation AE

Issue/Introduction

 

While testing the autosys upgrade, we are encountering below error on our shadow server:

 Error:

[CAUAJM_E_112508] An error occurred while connecting to the "AUTOXX" database

server.

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=huZsTj/4QrGk+QnD+9HYdw==)

We have dual event servers – AUTOXX and AUTOYY – Hosted on primary and secondary scheduler servers.

Please note – we are able to connect to autod2 db from shadow server and tnsping is also working fine.

Environment

Release : 11.3.6 SP8 

Upgrade Installer: r12.1

Autosys version – R11.3.6 SP8
DB version – Oracle 19c
Autosys server OS version – AIX 7.2

Cause

Autosys Installer validates DB connection by comparing the "EventServer_x" parameters with SID mentioned over "tnsnames.ora" file which had a character difference which is causing the error.

 

Resolution

Noticed "tnsnames.ora" files SID is specified with ".world" extension. To avoid DB validation error update config.<INS> with  both  Primary and Secondary parameters i.e eventserver_1 and eventserver_2 from AUTOxx to AUTOxx.world and AUTOxx to AUTOyy.world to successfully validate the DB parameters.

 

Note: mentioned Database SIDs are as examples and not taken from any environments.