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.
Getting error SP2-1503/0152 when running Autosys jobs with sqlplus commands
Article ID: 17367
Updated On:
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:
Component:
Feedback
Yes
No
Powered by
