New install failing with sqlplus command not found

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Running a new installation of Applications Manager fails with a "sqlplus command not found" or "sqlldr command not found"

Environment

Release:
Component: APPMGR

Cause

Oracle database or client is not installed or pathed correctly

Resolution

Make sure Oracle database or client is installed and pathed. If Oracle is installed, the which command or where command (Windows) can be used to list the location of the slqplus or sqlldr commands. A couple examples below.

Windows:
C:\user_tests\PHM\AM9AGENT>where sqlplus
C:\app\oracle\product\11.2.0\client_1\BIN\sqlplus.exe

Unix/Linux:
[qa4@vwasrsb01 ~]$ which sqlldr
/export/home/oracle/product/11.2.0/dbhome_1/bin/sqlldr

If Oracle is installed and pathed, review the paths returned by the which or where commands, and ensure that sqlplus and/or sqlldr commands exists.