How to reconfigure Harvest server on UNIX/LINUX when $ORACLE_HOME and/or $ORACLE_SID changed?

Document ID : KB000025690
Last Modified Date : 14/02/2018
Show Technical Document Details

Background:  

During installation, the CA Harvest SCM server keeps the $ORACLE_HOME and or $ORACLE_SID environment variable values (among other information) in the wrapper scripts in the $HARVESTHOME/bin folder on the Unix and Linux platforms.  This configuration information is also kept inside some scripts in the folder where caiptodbc is installed.

When the broker (bkrd) and harvest server (hserver) start, the wrapper scripts set up necessary run time environments for the daemon processes. If later $ORACLE_HOME and or $ORACLE_SID change due to upgrade or by simply directory move/rename, then those scripts need to be updated as well.

Environment:  

CA Harvest SCM all versions, Unix/Linux platforms

Instructions: 

Following are the steps to reconfigure those scripts.

A. Ensure login user profile that starts harvest broker process has latest $ORACLE_HOME and or $ORACLE_SID

B. Execute $ODBC_HOME/CONFIG.SH and enter or confirm the new $ORACLE_HOME and or $ORACLE_SID on prompts.

C. Stop broker [down time is needed]

D. Execute $CA_SCM_HOME/install/install.sh

E. After the license agreement and other prompt then we get the main installation menu:

    [1] - Install server for the first time

    [2] - Upgrade Harvest

    [3] - Change Harvest installation configuration

    [x] - Exit

   Select option 3 to change the installation configuration

F. Then enter or confirm the new $ORACLE_HOME and or $ORACLE_SID on prompts, and confirm all the other settings (such as location of PEC and location of caiptodbc).

G. After successful installation restart broker/server processes.