KBI 310514 Oracle Server Requires Reboot After Installation of Oracle Client Tools

Version

Argent for Oracle — all versions

Date

11 Jun 2013

Summary

After installing Oracle Client Tools, customers are able to successfully connect to the database from the Argent Advanced Technology – Argent for Oracle User Interface.

Relator tests also run successfully

When the Relator is placed into Production Mode the following error messages appear in the Supervising and Monitoring Engine Logs:

   ARGENT svc_argent (Result) A database exception occurred, please check the log file of Monitoring Engine for details

   ARGENT CONTOSSO\svc_argent 02477 Database exception F=L350_OpenDatabaseThroughOCI

   ARGENT CONTOSSO\svc_argent 03172 *** ERROR *** Failed L350_OpenDatabaseThroughOCI F=CSQLQueryRule::L200_OpenSet

Technical Background

Certain System Environment Variables need to be set for the Argent Service to utilize Oracle Client Tools to connect to an Oracle Database, while these variables may be set for the user it may not be necessarily set for the System.

In Production Mode, the Argent Service account uses the System Environment Variables.

Resolution

Ensure the PATH variables are set correctly and the Oracle Home path is defined.

Oracle requires a full system reboot is required after Installing Oracle Client Tools to ensure that all the System Environmental Variables are set.