Login process hannging

book

Article ID: 4248

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

The hserver processes are getting error:

[CAI/PT][ODBC Oracle Dynamic driver]Environment variable ORACLE_HOME="@" does not point to a valid directory.
SQLSTATE=08001



Cause

The read and execute privileges for the 32bit Oracle client driver directory

may not be granted to the cascm userID.

Environment

Oracle database

Resolution

Check to see if the cascm userId that is used to start the broker has full read - execute privileges under the entire ORACLE_HOME directory. This where the 32bit Oracle client driver and the TNSNames.ora files should reside. Correct this access, stop the broker, hservers, and rtserver, then run hdbsetup with CO option and reestablish the proper ODBC DSN connection object [harvest] and test connectivity. If connectivity is good the restart the broker and retest workbench activity.

Additional Information

As always, please contact CA Technologies support for CA Harvest Software Change Manager if you have further questions.