Harvest/SCM installation on Linux/Unix using Oracle instant client v19

Products

• CA Harvest Software Change Manager

Issue/Introduction

Client found that the odbc/install script failed due to the fact the Oracle install client has slightly different installed file structure. Basically the \lib and \bin directories are not present and their files now are directly under Oracle_Home. Oracle install client version is v19 

Environment

SCM 14.5

Linux/Unix

Resolution

Please check out these steps, especially step7 where you would need to create symbolic links

1. Download the InstantClient modules:
   - Basic
   - Jdbc
   - Odbc
   - Sdk
   - Sqlplus

2. Copy all these zip files to the folder you want to become the Oracle Home folder ($ORACLE_HOME).  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 $ORACLE_HOME/network/admin/tnsnames.ora file that will contain connection information to your Harvest database.

6. Set permissions on this file so that it's world-readable (chmod 755 ...)

7. 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:
   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

9. After sourcing the profile, check to be sure you can connect to the Harvest database with
   sqlplus userid/password@service