################################################################################

#-------------------------
# Set up the shell variables
#-------------------------
EDITOR=vi
export EDITOR

ENV=$HOME/.kshrc
export ENV

MAIL=/var/mail/${LOGNAME}
export MAIL

PATH_LOGIN=${PATH_LOGIN:=/usr/ccs/bin:$PATH}
export PATH_LOGIN

PATH=${PATH_LOGIN:=$PATH}:/bin:/usr/X/bin:/sbin:/usr/sbin:/usr/local/bin:$HOME/bin
export PATH


#-------------------------
# OS specific settings
#-------------------------
os=`uname -s`
case $os in
   SunOS) ORATAB='/var/opt/oracle/oratab'
          ;;
       *) ORATAB='/etc/oratab'
          ;;
esac

export ORATAB


#-------------------------
# check parameter for given SID
#-------------------------
if [ $# -eq 1 ]
then
        ORACLE_SID=$1
else
        ORACLE_SID=orcl
fi


#-------------------------
# check SID against $ORATAB
#-------------------------
line=`grep -i "^${ORACLE_SID}" $ORATAB`
sid=`echo $line | cut -d: -f1 `
oho=`echo $line | cut -d: -f2 `


if [ `echo $sid | tr '[a-z]' '[A-Z]'` = `echo ${ORACLE_SID} | tr '[a-z]' '[A-Z]'` ]
then
        ORACLE_SID=$sid
        export ORACLE_SID

        ORACLE_HOME=$oho
        export ORACLE_HOME
else
        echo "Oracle-SID ${ORACLE_SID} not found !"
        ORACLE_SID=""
fi


#-------------------------
# SID dependent settings
#-------------------------
if [ ! ".$ORACLE_SID" = "." ]
then
   ORACLE_BASE=`echo $ORACLE_HOME | sed -e's/product/ /' | awk '{print $1}' | sed -e's/\/$//'`
   export ORACLE_BASE

   ORA_NLS33=${ORACLE_HOME}/ocommon/nls/admin/data
   export ORA_NLS33

   NLS_LANG=german_germany.al32utf8
   export NLS_LANG

   LD_LIBRARY_PATH=${ORACLE_HOME}/lib
   export LD_LIBRARY_PATH

   SHLIB_PATH=${ORACLE_HOME}/lib
   export SHLIB_PATH

   PATH=${PATH}:${ORACLE_HOME}/bin
   export PATH

   alias opatch='$ORACLE_HOME/OPatch/opatch'
   unset ORA_NLS10
else
   echo
   echo "ORACLE_SID '$ORACLE_SID' not in oratab."
   echo "ORACLE_BASE, ORACLE_HOME, ORA_NLS33,LD_LIBRARY_PATH, and SHLIB_PATH unset."
   echo "\nPATH does NOT contain any Oracle binary"
   echo
fi

oracle_sid=$(echo ${ORACLE_SID} | tr '[:upper:]' '[:lower:]')
export oracle_sid

ORACLE_TERM=vt220
export ORACLE_TERM

PS1=`hostname`':${ORACLE_SID}:${PWD}$ '

set -o vi


#-------------------------
# ensure /usr/lib is in library path
#-------------------------
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/lib
export LD_LIBRARY_PATH


#-------------------------
# define environment dependant aliasses
#-------------------------
alias    ..='cd ..'
alias    ...='cd ../..'
alias    ....='cd ../../..'

alias -x cdal='cd $ORACLE_BASE/diag/rdbms/$oracle_sid/$ORACLE_SID/trace'
alias -x cddiag='cd $ORACLE_BASE/diag/rdbms/$oracle_sid/$ORACLE_SID'
alias -x cdna='cd $ORACLE_HOME/network/admin'
alias -x cdoh='cd $ORACLE_HOME'
alias -x dbinfo='$HOME/bin/dbinfo.ksh'
alias -x dir='ls -al | more'
alias -x echopath='echo $PATH'
alias -x env='env | sort'
alias -x history='fc -l'
alias -x ll='/bin/ls -alv'
alias -x mktsdir='$HOME/bin/mktsdir.ksh'
alias -x psora='ps -ef | grep -i ora'
alias -x setsid='. $HOME/.Application'
alias -x sqldba='sqlplus / as sysdba'


#-------------------------
# ...and last but not least...
#-------------------------
umask 022

TMPDIR=/tmp
export  TMPDIR

PAGER=/bin/more
export PAGER

MBOX=${HOME}/mbox
export MBOX

ulimit=unlimited