[CAUAJM_E_112508] An error occurred while connecting to the database

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• Autosys Workload Automation

Issue/Introduction

Hello,

We have a couple of issues when attempting to upgrade to R12.

During the R12 upgrade, received the following error:

[CAUAJM_E_112508] An error occurred while connecting to the "<name of database>" database

server.

java.sql.SQLRecoverableException: IO Error: could not resolve the connect

identifier  "<database service name>"

Able to connect to the db from that server with no problem manually and the server was previously functioning just fine so previous to this and outside of the install, the app was connecting just fine.

 

Environment

Release : 11.3.6 SP8 CUM1

Component : CA Workload Automation AE (AutoSys)

Operating System: Redhat7

Cause

The tnsnames.ora file was not formatted correctly for the database used for AutoSys.  This was observed using Zulu JRE.

Resolution

To resolve the oracle error messages that was causing the R12 upgrade to fail, updated the tnsnames.ora file

From:

<database name> =
(DESCRIPTION = (ENABLE = BROKEN)(CONNECT_TIMEOUT = 90)(RETRY_COUNT = 30)(RETRY_DELAY = 3)
     (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname where database resides>)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = <database name>)
     )

To:

<database name> =
  (DESCRIPTION =
     (ENABLE = BROKEN)
     (CONNECT_TIMEOUT = 90)
     (RETRY_COUNT = 30)
     (RETRY_DELAY = 3)
     (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname where database resides>)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = <database name>)
     )
  )