11g Environment Setting:
=======================
—————————————————————–
==>cat .profile
. /oracle/app/oracle/set_env_var_dba
PS1=”
`hostname`*${ORACLE_SID}-${PWD}
==>”
EDITOR=vi; export EDITOR
set -o vi
stty erase
PATH=$PATH:.
dba()
{
cd /oracle/app/oracle/scripts/MAINT/DBA/bin
}
————————————————————————————
==>cat /oracle/app/oracle/set_env_var_dba
# This File Sets all the Oracle Environment Variables and is called from
# Each Users’s . profile file.
#
# Please Don’t change these settings
#
tput clear
ORATAB=/var/opt/oracle/oratab;export ORATAB
TNS_ADMIN=/oracle/app/oracle/product/8.1.7/network/admin;export TNS_ADMIN
. ${HOME}/DBA/DBA.env
B=`tput smso`
N=`tput rmso`
echo “”
echo “Enter $B 1 $N to access the 9.2.0.8 800P2 ”
echo “”
echo “Enter $B 2 $N to access the 9.2.0.8 800D ”
echo “”
echo “Enter $B 3 $N to access the 10.2.0.3 800H ”
echo “”
echo “Enter $B 4 $N to access the 11.1 TREND ”
echo “”
echo “Enter $B 5 $N to access the 10.2.0 Agent ”
echo “”
echo “Enter $B 6 $N to access the 9.2.0.8 800T ”
echo “”
echo “Enter $B 7 $N to access the 9.2.0.8 800D_new ”
echo “”
echo “Enter $B 8 $N to access the 9.2.0.8 800P2_new ”
echo “”
echo “Enter Your Choice [1] : c”
read CHOICE
case ${CHOICE:-1} in
1) . /oracle/app/oracle/ora800P2.env;;
2) . /oracle/app/oracle/800D.env;;
# 6) . /oracle/app/oracle/ora800H.env;;
# 5) . /oracle/app/oracle/oraTREND.env;;
4) . /oracle/app/oracle/11G.env;;
3) . /oracle/app/oracle/800H-10G.env;;
5) . /oracle/app/oracle/oracle_env_agent;;
6) . /oracle/app/oracle/ora800T.env;;
7) . /oracle/app/oracle/ora800D_new.env;;
8) . /oracle/app/oracle/ora800P2_new.env;;
esac
echo “”
unset N
unset B
panther1*TREND-/oracle/app/oracle
==>
—————————————————————————
panther1*TREND-/oracle/app/oracle
==>more /oracle/app/oracle/11G.env
umask 022
export ORACLE_OWNER=oracle
export ORACLE_SID=TREND
export ORACLE_BASE=/sandb20/app/oracle
export ORACLE_HOME=/sandb20/app/oracle/product/11.1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/lib:/usr/ucblib:${ORACLE_HOME}/network/lib:/oracle/app/oracle/admin/odbc/lib
export ORACLE_TERM=xsun5
export ORACLE_PATH=$PATH:.:$ORAWEB_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/obackup/bin:/opt/bin:/usr/bin:/GNU/bin/make:/usr/cc
s/bin
export PATH=${ORACLE_HOME}/bin:/opt/bin:/usr/ccs/bin:/GNU/bin/make:$HOME/dba/bin:.:/usr/bin:/bin:/usr/sbin:/usr/local/bin:$PA
TH
export DISPLAY=`hostname`:0.0
export CLASSPATH=/sandb20/app/oracle/jre/1.1.8:/sandb20/app/oracle/product/11.1/jlib:/sandb20/app/oracle/product/11.1/product
/jlib
export ORA_NLS32=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_DOC=$ORACLE_HOME/doc
export TMPDIR=/var/tmp
export ORATAB=/var/opt/oracle/oratab
export EPC_DISABLED=TRUE
# 11G ALert Locations
export ORA_BDUMP=/sandb20/app/oracle/diag/rdbms/trend/TREND/trace
#export ORA_CDUMP=$ORACLE_BASE/product/admin/$ORACLE_SID/cdump
#export ORA_UDUMP=$ORACLE_BASE/product/admin/$ORACLE_SID/udump
#export ORA_PFILE=$ORACLE_BASE/product/admin/$ORACLE_SID/pfile
# environment variables for hot backup
DEVICE=/dev/rmt/2cn
NO_REW_DVCE=/dev/rmt/2cn
PS1=”$ORACLE_SID on `tput bold;hostname“tput rmso`> ”
panther1*TREND-/oracle/app/oracle
==>
—————————————————————————