DUAS: OAPP Uprocs fail with "sqlplus not found"

Products

• CA Automic Dollar Universe

Issue/Introduction

OAPP Uprocs launched as a specific user fail stating that sqlplus cannot be found.

The same Uprocs can be launched correctly as the user starting the node.

Environment

Release : 6.x

Component : DOLLAR UNIVERSE

Cause

Missing execution permissions to the user launching the jobs on the binary sqlplus

Resolution

The issue was that the binary sqlplus could not be launched by the specific user (csorsyp).
Reason being that the user csorsyp had not been added to the group oainstall who is the only group that can execute sqlplus.

Issue was fixed via the command usermod

usermod -a -G oainstall csorsyp