Jump to Navigation

031 - Using SQL*Plus on Linux

To run SQL*Plus, or any Oracle-supplied command, you must have several environment variables set.
You can set these environment variables automatically at login by editing your login script, or
you can use an environment variable script built, When you installed Oracle Database XE, the installer
creates two scripts that define the environment variables for you.

Environment Variable Script(Bourne, Korn, Bash):
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
NLS_LANG='$ORACLE_HOME/bin/nls_lang.sh'
export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH
export PATH
if [ $LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH
Linux:
Oracle:


Main menu 2

Story | by Dr. Radut