Setting Environment Variables on the Linux Platform

Previous
Previous
Next
Next

On the Linux platform, before running SQL Command Line or other Oracle utilities from a terminal session, you must set some environment variables for that session. The procedure for setting environment variables depends on whether you are connecting locally, or connecting remotely from Oracle Database XE Client.

Setting Environment Variables for a Local Connection

To set environment variables when connecting locally, enter one of the following commands in a terminal session.

For Bourne, Korn, or Bash shell:

source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

For C shell:

source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.csh

See "Environment Variables Reference for Linux" for more information.


Note:

There is no need to set environment variables before running SQL Command Line from the K menu (KDE) or Applications menu (Gnome).

Setting Environment Variables for a Remote Connection

To set environment variables when connecting remotely from Oracle Database XE Client, enter one of the following commands in a terminal session at the remote computer:

For Bourne, Korn, or Bash shell:

source /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh

For C shell:

source /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.csh

See "Environment Variables Reference for Linux" for more information.