DB jobs fails with Suberror, ORA-01034: java.sql.SQLRecoverableException: ORA-01034 (WA Agent)

Products

• CA Workload Automation DE - System Agent (dSeries)
• Workload Automation Agent
• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation DE - Business Agents (dSeries)

Issue/Introduction

Database SQL jobs fail with the following error.

When running the job, I am seeing the below error.

LStatus java.sql.SQLRecoverableException: ORA-01034: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available.ORA-27101: shared memory realm does not exist.Linux-x86_64 
Error: 2: No such file or directory.Additional information: 4376.Additional information: 271991163.: shared memory realm does not exist.Linux-x86_64 Error: 2: No such file or directory.Additional information: 4376.Additional information: 271991163

 

Database is pluggable (CDB)

 

 

Environment

Release : 12.3

Component : CA Workload Automation Database Agent

Cause

TNS name or service name is incorrect in agentparm.txt

Resolution

When defining the DB string in JDBC, use the following format for Pluggable database:

jdbc:oracle:thin:@[HOST][:PORT]/SERVICE

The 'lsnrctl service' command provides all the available service on the Oracle DB.