Shell Programming and Scripting

host:$ what /usr/bin/ksh|grep Version                                                                                                                                                       
        Version 11/16/88
host:$

echo DB LIST
ps -ef | grep pmon | grep -v grep | awk -F_ '{print $3}' | sort > /tmp/k_out.txt 
ps -ef | grep pmon | grep -v grep | awk -F_ '{print $3}' | sort
echo

echo "Enter database name from the above list"
echo
read ORACLE_SID
while [[ $ORACLE_SID = "" ]]; do
echo reenter SID again
   read ORACLE_SID
done
echo
echo Database selected is: $ORACLE_SID
echo


#check to make sure SID pass is correct or not, if not exit
cat /tmp/k_out.txt|grep -w $ORACLE_SID
INPUT_STAT1=$?
if [ "$INPUT_STAT1" = "0" ]
then
# dO NOTHING
echo "Database name select was good"
else
echo "Database name was NOT selected from the List Provided"
fi

#!/usr/bin/ksh

echo "DB LIST:"
ps -ef | awk -F_ '/pmon/{print $3}' | sort | tee db_list$$
trap "rm db_list$$" EXIT

printf "Enter database name from the above list: "
read ORACLE_SID
while [ "$ORACLE_SID" = "" ]
do
        printf "reenter SID: "
        read ORACLE_SID
done
printf "\nDatabase entered is: %s\n\n" "$ORACLE_SID"

#check to make sure SID pass is correct, if not exit
if grep -q "^$ORACLE_SID$" db_list$$
then
        # dO NOTHING
        echo "Database name selected was good"
else
        echo "Database name was NOT selected from the List Provided" >&2
        exit 1
fi

trap "rm db_list$$" EXIT