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

Document ID : KB000017367
Last Modified Date : 14/02/2018
Show Technical Document Details

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=