Error "sqlplus: command not found" on SURUN Job

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

An SURUN Job may fail with the following error:

/opt/appworx/bin/test.sh: line 2: sqlplus: command not found

Environment

Release : 9.4.x

Cause

The SURUN program type allows Applications Manager to switch from the Applications Manager OS User to the User that owns the Job script.

Depending on the authoriz.lis configuration, the active environment may be changed resulting in the error as the Oracle environment is now lost.

Resolution

Review the $AW_HOME/exec/authoriz.lis file for all entries that matches the Job script path and confirm if the configuration is correct. 

The issue is likely due to having the authoriz.lis entry having a blank value or a one value. Depending on the value, the Applications Manager environment may remain intact or dropped for the script owner's environment.

This is described in the doc link below:

Creating an authoriz.lis File