2 Day DBA > Connecting to the Database > Setting Environment Variables > Setting Environment Variabl...
Setting Environment Variables on the Linux Platform |
Previous |
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.