Using Oracle 11g Instant Client with AutoSys

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation Agent

Issue/Introduction

Description:

Oracle Instant Clients offer a quick and easy way to setup database connectivity for AutoSys. Using the Oracle 11g Instant Client, however, requires a few more steps to setup.

Note: Only the 32-bit Oracle client libraries are supported. Use of 64-bit client libraries can result in errors, for example:

CAUAJM_E_18409 Unable to load Oracle client libraries <libclntsh.so: wrong ELF class: ELFCLASS64>

In some cases Oracle 11g Release 2 may not install 32-bit client libraries so it will be necessary to install the Instant or full 32-bit Oracle client libraries when using AutoSys 11.0 with Oracle 11g.

For HP-UX Itanium (AI-64) support, you must install the 32-bit HP-UX PA-RISC Oracle client libraries.

Solution:

Once the Oracle 11g Instant Client has been downloaded and extracted, the following additional steps are required to establish the correct client library environment for AutoSys:

For Unix/Linux:

Create a symbolic link in the Instant Client directory for libclntsh.so, for example: ln -s libclntsh.so.11.1 libclntsh.so

1. 1. Modify the $AUTOUSER/autosys.sh.$hostname environment script:
   
   
   1. Under the # Set Oracle variables section, modify the TNS_ADMIN variable (if necessary) to point to the Instant Client, for example:
      
      
      1. TNS_ADMIN=/u01/app/instantclient_11_2/network/admin ; export TNS_ADMIN
         
         
   2. Under the # Set Oracle variables section, modify the aslibs variable to place the Instant Client directory before the $ORACLE_HOME/lib entry, for example:
      
      
      1. aslibs=$aslibs:/u01/app/instantclient_11_2:$ORACLE_HOME/lib

For Windows:

1. 1. Either at the Operating System level or within the AutoSys Admin GUI System screen:
   
   
   1. If necessary, configure the tnsnames.ora file under network\adminCreate or modify the TNS_ADMIN variable to point to the Instant Client, for example:
      
      
      1. TNS_ADMIN=C:\instantclient_11_2\network\admin
         
         
   2. Modify the PATH variable to add the Instant Client directory before (if necessary) any existing %ORACLE_HOME% directory entries, for example:
      
      
      1. PATH=C:\instant_client_11_2;C:\Windows\system32;C:\Windows;?

Environment

Release: ATSAGE99000-11.3-Workload Automation AE-Remote Agent
Component: