ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 226900

calendar_today

Updated On:

Products

CA Workload Automation DE - System Agent (dSeries) Workload Automation Agent CA Workload Automation Agents 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)

 
 

Cause

TNS name or service name is incorrect in agentparm.txt

Environment

Release : 12.3

Component : CA Workload Automation Database Agent

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.