Home

 

Checking the Oracle environment variable settings

 

Ensure that your Oracle environment variables are set for queue manager processes as well as in your application processes. In particular, always set the following environment variables before starting the queue manager:

ORACLE_HOME

The Oracle home directory. For example, on UNIX systems, use:

export ORACLE_HOME=/opt/oracle/product/8.1.6

On Windows systems, use:

set ORACLE_HOME=c:\oracle\ora81

ORACLE_SID

The Oracle SID being used. If you are using Net8 for client/server connectivity, you might not need to set this environment variable. Consult your Oracle documentation.

An example of setting this, on UNIX systems, is:

export ORACLE_SID=sid1

The equivalent on Windows systems is:

set ORACLE_SID=sid1

 

Parent topic:

Oracle configuration

fa13630_

 

Home