Shell Programming and Scripting

#!/bin/bash

SCRIPT_PATH=${HOME}/scripts/db/script
LOG_FILE=${HOME}/scripts/db/log/database_instances_alias.log
CONN_DATABASE='sqlplus -s / as sysdba'
DB_INSTANCES=$(cat /etc/oratab | egrep -v '^#|^$' | grep -v '^+'|cut -d":" -f1,2)
sed -n '1,8p' ${HOME}/.bashrc > ${HOME}/.bashrc_bkp
echo " " >>${HOME}/.bashrc_bkp
printf "%s%20s%20s%20s%20s\n" "S.No" "DATABASENAME"  "ORACLE_HOME"  "DB_STATUS" "DB_MODE" > ${LOG_FILE}
SERIAL=0
for SINGLE_INSTANCE in ${DB_INSTANCES[@]}
do
##DATABASE NAMES
DATABASE_NAME=$(echo $SINGLE_INSTANCE | awk -F ":" '{print $1}')
##ORACLE HOME
DATABASE_HOME=$(echo $SINGLE_INSTANCE | awk -F ":" '{print $2}')
ps -ef | grep pmon | grep -q $DATABASE_NAME
  if [ $? -eq 0 ]; then
    DB_STATUS="UP"
    export ORACLE_SID=$DATABASE_NAME
    export ORACLE_HOME=$DATABASE_HOME
    DATABASE_MODE=$(echo "select open_mode from v\$database;" | $CONN_DATABASE | sed -n '4p')
       case $DATABASE_MODE in
             'MOUNT')
                                DATABASE_MODE_S=${DATABASE_MODE}
             ;;
             'READ WRITE')
                                DATABASE_MODE_S=${DATABASE_MODE}
             ;;
             'READ ONLY')
                                DATABASE_MODE_S=${DATABASE_MODE}
             ;;
             'NOMOUNT')
                                DATABASE_MODE_S='Instance Running Not Mounted'
             ;;
             *)
                                DATABASE_MODE_S='N/A'
             ;;
       esac

  else
    DB_STATUS="DOWN"
    DATABASE_MODE_S="N/A"
  fi
SERIAL=$(expr $SERIAL + 1)
printf "%s%20s%25s%15s%20s\n" "$SERIAL" "$DATABASE_NAME"  "$DATABASE_HOME"  "$DB_STATUS" "$DATABASE_MODE_S" >> ${LOG_FILE}
echo "alias $SERIAL='export ORACLE_SID="$DATABASE_NAME";export ORACLE_HOME="$DATABASE_HOME";PS1=\"[\\u\\h ] $DATABASE_NAME \$\"'" >> ${HOME}/.bashrc_bkp
echo "alias showdb='$SCRIPT_PATH/database_instances_alias_bkp.sh;cat $LOG_FILE;. $HOME/.bashrc'" >>${HOME}/.bashrc_bkp
done
mv -f $HOME/.bashrc_bkp $HOME/.bashrc
. $HOME/.bashrc

for i in {1..8}; do unalias $i; done

diff $HOME/.bashrc $HOME/temp_alias_compare_file >/dev/null 2>&1
  if [ $? -eq 1 ];then
    diff $HOME/.bashrc $HOME/temp_alias_compare_file | grep 'alias' | grep -v 'showdb' | while read line
         do
            unalias $(echo $line | awk -F"=" '{print $1}' | awk -F"alias" '{print $2}' | sed 's/^ //g')
         done
  fi
. $HOME/.bashrc