#! /bin/ksh

#
# Set initial environment
#
# Add Oracle bin directory to the search path
#
export PATH=$PATH:.:/usr/local/bin:/usr/ccs/bin
#
# Oratab default position for SUN systems.
#
export ORATAB=/var/opt/oracle/oratab

#
export ORACLE_BASE=/app/oracle

#
# Set instance specifics
# Choose, normally the first available in ORATAB.
# If a value is preset on .profile this SID will be used.
#
ORACLE_SID=${ORACLE_SID:=`cut  -f1 -d':' $ORATAB | grep -v \* | grep -v '#'| grep -v '^$'| head -1`}; export ORACLE_SID
if [ "a" = a$ORACLE_SID ] ; then
  export ORACLE_HOME=$HOME/product/8.1.7
  export ORACLE_SID=NOTSET
fi


#
# Set ORACLE_SID, ORACLE_HOME, ORACLE_BASE and PATH without prompt
#
ORAENV_ASK=NO; ORAENV_ASK=

#
# Set other important environment variables
#
export ORACLE_PAGER=/usr/local/bin/less
export ORACLE_LPPROG=/usr/bin/lp
export ORACLE_LPSTAT=/usr/bin/lpstat
#export NLS_LANG=AMERICAN_AMERICA.US7ASCII
#export NLS_LANG=AMERICAN_AMERICA.WE8DEC
export NLS_LANG=AMERICAN_AMERICA.US7ASCII
export ORACLE_OWNER=oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export SHLIB_PATH=$ORACLE_HOME/lib
#
# Search path for SQL scripts
#
export SQLPATH=$ORACLE_HOME/sql
export ORACLE_PATH=~/sql

#
echo ''
echo This system is `tput bold; hostname; tput sgr0`
echo '--------------------------------------------------'
echo Logged with user:  `tput bold; logname; tput sgr0`
echo Default dababase:  `tput bold`$ORACLE_SID`tput sgr0`
echo ''
echo To select a new database instance, type \"dbset\"
echo '--------------------------------------------------'
echo ''
echo ''
#
#