Setting environment variables

Environment variables are specific preset values that establish the working environment of the gateway. From the environment variable specified, the gateway receives path information for the directories in which library files are present.

You must set the following environment variables for use with the Oracle database:
  • Set ORACLE_HOME using the following command:

    export ORACLE_HOME=/opt/oracle

    where /opt/oracle is the Oracle installation directory.

  • Set ORACLE_SID using the following command:

    export ORACLE_SID=ORCL

    In this example, ORCL is the System ID of your Oracle instance.

  • Set TNS_ADMIN using the following command:

    export TNS_ADMIN=$ORACLE_HOME/network/admin

    where $ORACLE_HOME/network/admin is the directory containing the tnsnames.ora file.

Library path settings

Before you run the gateway, you must set the library path environment variable to include the directory of the Oracle library used by the gateway.

Depending on the operating system you are using, set the following library path environment variables:
  • On AIX® operating systems:
    • Set $LIBPATH to include the directory where the Oracle client is installed.
    • Set $ORACLE_HOME to the directory where the Oracle client is installed.
    • In some systems, you might also need to set XPG_SUS_ENV to ON.
  • On HP Itanium operating systems:

    If 32-bit libraries are required, set $LD_LIBRARY_PATH to include instantclient/lib or instantclient/lib32.

  • On HP-UX operating systems:

    If 32-bit libraries are required, set $SHLIB_PATH to include instantclient/lib or instantclient/lib32.

  • On Linux® operating systems:

    If 32-bit libraries are required, set $LD_LIBRARY_PATH to include instantclient/lib or instantclient/lib32.

  • On Linux for zSeries operating systems:

    If 32-bit libraries are required, set $LD_LIBRARY_PATH to include instantclient/lib or instantclient/lib32.

  • On Solaris operating systems:

    If 32-bit libraries are required, set $LD_LIBRARY_PATH to include instantclient/lib or instantclient/lib32.

  • On Windows operating systems:

    Set $PATH to include the Oracle libraries.