Harvest/SCM installation using Oracle instant client v19

Products

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

Issue/Introduction

When initially configuring Harvest to use Oracle InstantClient, or when converting from Oracle Full Client to Oracle InstantClient, this article describes the steps necessary to complete the process.

Environment

Harvest Software Change Manager v14.x and higher
Oracle 19c and higher database
Windows and Linux/Unix operating systems

Resolution

These are the steps necessary to complete the process

1. Download the InstantClient modules:
   

      - Basic
      - Jdbc  (only needed if Harweb is to be installed on the server)
      - Odbc
      - Sqlplus

2. Copy all these zip files to the folder you want to become the Oracle Home folder (%ORACLE_HOME% or $ORACLE_HOME).  On Linux and Unix, make the SCM user the owner of this folder.
   
   
3. Unzip the files.
   
   
4. Inside your Oracle Home folder create a network folder ($ORACLE_HOME/network) and a network/admin folder ($ORACLE_HOME/network/admin).
   
   
5. Copy or create the tnsnames.ora file that will contain connection information to your Harvest database into the $ORACLE_HOME/network/admin (%ORACLE_HOME%\network\admin) folder
   
   
6. On Linux and Unix set permissions on this file so that it's world-readable (chmod 755 ...)
   
   
7. On Linux and Unix create symbolic links:
   

      $ORACLE_HOME/bin -> $ORACLE_HOME
      (ex: ln -s $ORACLE_HOME bin)
      $ORACLE_HOME/lib -> $ORACLE_HOME
      (ex: ln -s $ORACLE_HOME lib)
      libclntsh.so.11.1 (or whatever the latest version of libclnt is) -> libclntsh.so
      (ex: ln -s libclntsh.so.11.1 libclntsh.so)
      cd $ORACLE_HOME

8. Set environment variables in SCM user owner's profile:
   On Linux/Unix:
   

      ORACLE_HOME=<InstantClient installation folder>
      PATH=$ORACLE_HOME:$PATH
      LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH (for operating systems that have this)
      LIBPATH=$ORACLE_HOME:$LIBPATH (for operating systems that have this)
      TNS_ADMIN=$ORACLE_HOME/network/admin
      SQLPATH=$ORACLE_HOME

   
   On Windows:
   

      ORACLE_HOME=<InstantClient installation folder>
      PATH=%ORACLE_HOME%;%PATH
      TNS_ADMIN=%ORACLE_HOME%\network\admin
      SQLPATH=%ORACLE_HOME%

9. After sourcing the profile in Linux or Unix, or opening a new command prompt window in Windows, check to be sure you can connect to the Harvest database with
   

      sqlplus userid/password@service

10. Try starting or restarting the broker to ensure broker hservers can start correctly.

Additional Information

See also:

When your broker won't start - troubleshooting tips

E0302004d: Cannot connect to the datasource <datasourcename> as user <userid>