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

Article Id: 17367

Status: Published

Updated On: 14-02-2018 08:06

Legacy Id: TEC618434

Products:

CA Workload Automation AE - Business Agents (AutoSys) , CA Workload Automation AE - Scheduler (AutoSys) , CA 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: