Getting error SP2-1503/0152 when running Autosys jobs with sqlplus commands

Products

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

Issue/Introduction

Description:

When running an Autosys job executing a script with an sqlplus command, we are getting below error... ==============. SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

Solution:

The problem you are seeing with the SQL command being used by an AutoSys job is commonly encountered when the "ORA_TZFILE" is set.

The way this problem is typically resolved is by going into the file: /etc/auto.profile

You will need to delete the line starting with: #AUTOENV#ORA_TZFILE=

Environment

Release: ATSY1C99000-4.5-AutoSys-Job Management-Class 1 Remote Agent
Component: