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.

stuck with grub prompt at boot time ?

If you were trying to install Linux as dual partition on you windows OS, and during installation something goes wrong!!
Or while you are booting your system if you are stuck with a grup prompt don’t panic you can get back to you safe haven (windows OS) by just fallowing these 4 steps.


grub > root (hd0,0)
that is assuming your windows partition is on hda (primary master, first partiton - adjust the numbers accordingly)
grub > makeactive
grub > chainloader +1
grub > boot