Cauajm_e_18409 Unable To Load

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

Description:

CAUAJM_E_18498 Unable To Load Oracle client libraries

Solution:

We have found the following to work in our test environments and provide it here as a courtesy. As always please check with your DBA before attempting to configure Oracle!

These instructions correct 2 different types of Oracle client load library issues:

  1. Where a system is being prepared, prior to installing an AutoSys Scheduler/Appserver

  2. Where the Autosys product was installed without 32bit library support, and then the oracle client was installed "post facto"
  1. Create a directory for the Oracle Instant client i.e. </home/autosys/oracli>

  2. Download and extract the oracle 32bit instant client into that directory

  3. Change perms/ownership, if necessary so that autosys owns or can, at the very least, use those client libraries

  4. While inside of /home/autosys/oracli create symbolic links for bin, lib, and libclntsh

    • ln -s . bin

    • ln -s . lib

    • ln -s <libclntsh.so[sl].11.1> libclntsh.so[sl] # sub sl/so appropriately

  5. Set the following variables in the autosys OS users profile - example is with /usr/bin/bash "bash shell"

    1. export ORACLE_HOME=/home/autosys/oracle

    2. export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
      //c. export SHLIB_PATH=$ORACLE_HOME/lib:$SHLIB_PATH # applicable to HPUX
      //c. export LIBPATH=$ORACLE_HOME/lib:$LIBPATH # applicable to AIX

    3. export PATH=$ORACLE_HOME/bin:$PATH

    4. export TNS_ADMIN=$ORACLE_HOME

  6. Copy over the tnsnames.ora file from the <11.2 64-bit oracle home>/network/admin to $ORACLE_HOME (/home/autosys/oracli)

  7. Optional download the sqlplus (32-bit) binary from the same site where oracle s instant client was downloaded and place it within
    $ORACLE_HOME - this comes in handy for doing native troubleshooting, but is not necessary.

  8. Perform your autosys install uajm_setup.sh # if AutoSys was already installed go to 9.

  9. cd to $AUTOUSER (/opt/CA/UnicenterAutoSysJM/autouser.ACE is default)

  10. vi autosys.<shell>.<hostname> scripts

  11. Locate variables and modify if incorrect:

    • ORACLE_HOME=/home/autosys/oracli

    • TNS_ADMIN= /home/autosys/oracli

    • Modify the variable "aslibs=" in scripts

    • aslibs=$aslibs:$ORACLE_HOME/lib

  12. Repeat steps in 11. on all env scripts in $AUTOUSER

  13. su - root #become root

  14. unisrvcntr start uajm_agent uajm_sched.$AUTOSERV uajm_server.$AUTOSERV #test out the server - it should start