Reconfiguring Harvest server on UNIX/LINUX when $ORACLE_HOME and/or $ORACLE_SID changed?

Products

• CA Harvest Software Change Manager - OpenMake Meister
• CA Harvest Software Change Manager

Issue/Introduction

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

Resolution

Following are the steps to reconfigure those scripts.

1. Ensure login user profile that starts harvest broker process has latest $ORACLE_HOME and or $ORACLE_SID
2. Execute $ODBC_HOME/CONFIG.SH and enter or confirm the new $ORACLE_HOME and or $ORACLE_SID on prompts.
   
   
3. Stop broker [down time is needed]
   
   
4. Execute $CA_SCM_HOME/install/install.sh
   
   
5. 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
   
   
6. 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).
   
   
7. After successful installation restart broker/server processes.