Uprocs abort with sqlplus is not recognized

Products

• CA Automic Dollar Universe

Issue/Introduction

On our new windows server we have installed oracle 19 and our dollar universe user who executes the Uprocs has been added to the local admin group of the server.

When I run a simple sql plus command with our dollar universe user, this works on the server its own:



But in dollar universe we can see below error message:

'sqlplus' is not recognized as an internal or external command, operable program or batch file.
The final return code is : 9009
"Errorlevel: 9009"

$U doesn't know the sqlplus command.

Environment

Release : 6.x, 7.x

Component: Automic Dollar Universe

OS: Windows

Cause

The cause for errors:

'sqlplus' is not recognized as an internal or external command, operable program or batch file.

Is a wrong definition of the PATH environment variable for the User launching the Uproc.

Resolution

Two possible workarounds:

- server must be rebooted after installing Oracle to be able to use sqlplus command.

- add next step to every Uproc, e.g.:

set PATH=D:\Oracle\product\19.0.0\client_1\bin;%PATH%