Oracle DBA, How To, Error, Cause and Action

Unix .profile for oracle id

This is my common .profile for oracle unix ID

umask 022
ORACLE_BASE=/u01/app
export ORACLE_BASE

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME

LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH

ORACLE_SID=orcl1
#ORACLE_SID=orcl
export ORACLE_SID


# Golden Gate
GG_HOME=$ORACLE_BASE/GG_HOME_$ORACLE_SID
export GG_HOME

PATH=$PATH:/usr/sbin:/usr/bin:$ORACLE_HOME/bin:.
export PATH

PS1='[\u-$ORACLE_SID]:\W $ '