Using Oracle 11g Instant Client with AutoSys


Article ID: 49578


Updated On:


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



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


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, for example: ln -s

  1. 1. Modify the $AUTOUSER/$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;?


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