#! /bin/ksh
# An interactive oraenv command script.
#

if [ "_$1" = _-h ] ; then
  cat 1>&2 <<EOF

Usage: oraenv2 [-h]

  where   -h gives this help

This command is an interactive oraenv alternative.
It will show a list of all available databases on your machine to choose from.

EOF
  exit
fi

if [ -t 0 ]				# Command executed from a terminal
then
	ORACLE_SID=""
	while [ -z "${ORACLE_SID}" ]
	do
		tput clear; tput rev
		echo "Valid Oracle SIDs are :"
		tput rmso
		for SID in `cat /etc/oratab|grep -v "^#"|cut -f1 -d: -s`	
		do
			echo "			${SID}"
		done	
	        DEFAULT=`cat /etc/oratab|grep -v "^#"|cut -d: -f1 -s|head -1`
		echo "\nEnter the Oracle SID you require (def: $DEFAULT): \c"
		read ANSWER
		[ "${ANSWER}" = "" ] && ANSWER=$DEFAULT
		ORACLE_SID=`grep "^${ANSWER}:" /etc/oratab|cut -d: -f1 -s`
		ORACLE_HOME=`grep "^${ANSWER}:" /etc/oratab|cut -d: -f2 -s`
		if [ "${ORACLE_SID}" = "" ]
		then
			echo "\n\n		${ANS}: Invalid Oracle SID  \c"
			sleep 2
		fi
	done	
else					# Set to first entry in oratab
	ORACLE_SID=`cat /etc/oratab|grep -v "^#"|cut -d: -f1 -s|head -1`
	ORACLE_HOME=`cat /etc/oratab|grep -v "^#"|cut -d: -f2 -s|head -1`
fi

export ORACLE_SID
export ORACLE_HOME
PATH=${PATH}:${ORACLE_HOME}/bin
export PATH
ORAENV_ASK=NO
. ${ORACLE_HOME}/bin/oraenv
ORAENV_ASK=
echo
echo Oracle SID is now `tput rev`$ORACLE_SID`tput rmso`, Oracle Home is `tput rev`$ORACLE_HOME`tput rmso`
echo