Managing Unix environment variables

Managing Unix environment variables

in UNIX system we are not able to use the (AT the Rate) @ character. in any command..

so to connect to to slqplus the connection string cannot be passed
EX:

sqlplus system/oracle@ConnectioString

to over come this issue we need to set the environment varible TWO_TASK or ORACLE_SID

TWO_TASK=ConnectioString

or

ORACLE_SID=DatabaseName (first 8 character) (SID)

then we can use as

sqlplus system/oracle

find below more information from

http://www.orafaq.com/faq/managing_unix_environment_variables


Submitted by admin on Sat, 2004-08-07 07:18 To check what environment variables are set for your user, enter:

env | grep -e ORA -e TNS -e SQL

NOTE: Use /usr/xpg4/bin/grep instead of grep on Solaris.

Here are a few basic ORACLE environment variables. More environment variables,
can be found in the Oracle for Unix Installations Guides.

LD_LIBRARY_PATH - Path to library files. Eg: /usr/lib:/usr/openwin/lib:$ORACLE_HOME/lib:/usr/games/lib

ORACLE_BASE - Full path name to the base directory for all versions of Oracle products.


ORACLE_HOME - Full path name to the version of ORACLE you are currently using. ORACLE_HOME is normally found beneath ORACLE_BASE in the directory tree. This variable is used to find executable programs and message files.


ORACLE_SID - ORACLE Server system identifier (SID) or instance name. The database name is used as ORACLE_SID. This is required for all ORACLE products and is set by the coraenv script.


ORACLE_PATH - Defines the path names to locate files. If ORACLE_PATH is set, the application searches the directories specified by $ORACLE_PATH first, then the current directory. If ORACLE_PATH is not set, then the application uses the current directory. This variable is used by SQL*Plus, Forms and Menu.


ORACLE_TERM - Defines a terminal definition. If not set, it defaults to the value of your TERM environment variable. Used by all character mode products.


ORAENV_ASK This will not ask for ORACLE_SID, it will take it as it is specified. This variable is normally set to "NO" before oraenv is invoked from a script.


TNS_ADMIN - Defines the path name to the TNS (Transparent Network Substrate) files like TNSNAMES.ORA, SQLNET.ORA etc.


ORACLE_TRACE - Trace Oracle's Unix shell scripts as they execute (using set -x).


TWO_TASK - The TWO_TASK environment variable specifies a SQL*Net connect string for connecting to a remote machine in a client/server configuration. SQL*Net will check the value of TWO_TASK and automatically add it to your connect string.