menu_common.ksh



next_menu()
############################################################################
# Press any key to continue
############################################################################
{
echo
echo "# ----------------------------------------------------------------------- #"
echo "[ ...  Press any key to continue ... ]"
read next
}

menu_sel_text()
{
echo
echo "#   Enter Menu Selection: "
}


main_menu()

{
MNUTXT=" Main Menu "
dashboard

# echo "#     Add ASM disks in bulk                                     Future    #"
# echo "#     Add HealthCheck Info for this database                    Future    #"
# echo "#     Add DBA to APEX                                           Future    #"
# echo "#     Add cron job for APEX disk size update for this database  Future    #"
# echo "#     Add databases to APEX                                               #"
# echo "#     Run and email report for Disk Sizes                       Future    #"
# echo "#     Run and email report for DBA to Projects (future)                   #"
# echo "#     Run and email report for unassigned projects to DBAs                #"
# echo "#     Server Details                                                      #"
# echo "#     Update DB Details in APEX                                           #"
# echo "#     Update disk usage for database in APEX                              #"
# echo "#     Show Instance Details                                               #"
# echo "#     Show Database Details                                               #"
# echo "#                                                                         #"
# echo "#     EPG Status                                                          #"
# echo "#     Perform APEX HealthCheck                                  Future    #"
# echo "#     Add / Update scripts for all menu items                   Future    #"

echo "# ------------------------------------------------------------------------- #"
echo "#   0.  Add "$DB_NAME" database to DBAdmin ""            14. "$DB_NAME" Info"
echo "#   1.                                                                      #"
echo "#   2.  Display Instances (as /etc/oratab)                                  #"
echo "#   3.  Check this DB against oratab                                        #"
echo "#   4.  Change Instance Environment                                         #"
echo "#   5.                                                                      #"
echo "#   6.  Check all active DBs against oratab   (future)                      #"
echo "#   7.                                                                      #"
echo "#   8.                                                                      #"
echo "#   9.                                                                      #"
echo "#  10.                                                                      #"
echo "#  11.                                                                      #"
echo "#  12.                                                                      #"
echo "#  13.  Performance Tuning Menu                                             #"
echo "# ------------------------------------------------------------------------- #"
echo "#   x.  Exit APEX Menu    21. Build & QA Menu    23. Display Menu           #"
echo "# ------------------------------------------------------------------------- #"
menu_sel_text

read x
ans=`echo $x | tr '[a-z]' '[A-Z]'`
#
case "$ans"
in
       0 )
       ###################################
       # Add database to APEX if not there
       ###################################

       # chk_existing
       # inst_InCentralRepository
       # chk_db_running
       # mch_InCentralRepository
       # db_InCentralRepository
       # get_db_details
       # insertDB_InCentralRepository

       clear
       echo
       echo
       if [ $database_id = "" ]; then
          insertDB_APEX
       else
          echo "Database found in DBAdmin  (record # "$database_id")"
       fi
       next_menu;
       ;;


       1 )
       next_menu;
       ;;

       2 )
       disp_inst
       rest_save
       next_menu;
       ;;

       3 )
       chk_db_nm2dblst
       next_menu;
       ;;

       4 )
       clear
       disp_inst
       echo
       echo " Enter Instance Name: "
       echo
       typeset -u instnm
       read instnm
       echo $instnm
       chg_inst
       next_menu;
       ;;

       5 )
       next_menu;
       ;;

       6 )
       next_menu;
       ;;

       7 )
       next_menu;
       ;;

       8 )
       next_menu;
       ;;

       9 )
       next_menu;
       ;;

       10 )
       next_menu;
       ;;

       11 )
       # find_db
       next_menu;
       ;;

       12 )
       next_menu;
       ;;

       13 )
       MNU04=000
       echo $MNU04
       echo "Test Begin"
       while true
       do
         if [ "$MNU04" -eq 999 ]; then
            break;
            echo "This breaks"
         else
            echo "This continues"
         fi
         menu_perftune
       done
       echo "Test end"
       next_menu;
       ;;

       14 )
       get_db_details
       next_menu;
       ;;

       15 )
       # db_qa_rev
       next_menu;
       ;;

       16 )
       # db_qa
       next_menu;
       ;;

       17 )
       # update_db_details
       # find_db
       next_menu;
       ;;

       18 )
       # db_ind_size
       next_menu;
       ;;

       19 )
       # get_inst_details
       next_menu;
       ;;

       20 )
       # sho_db_details
       # get_db_details
       next_menu;
       ;;

       21 )
       MNU02=000
       echo $MNU02
       echo "Test Begin"
       while true
       do
         if [ "$MNU02" -eq 999 ]; then
            break;
            echo "This breaks"
         else
            echo "This continues"
         fi
         menu_02
       done
       echo "Test end"
       next_menu;
       ;;

       22)
       ./epg_stat.ksh
       next_menu;
       ;;

       23)
       MNU03=000
       echo $MNU03
       echo "Test Begin"
       while true
       do
         if [ "$MNU03" -eq 999 ]; then
            break;
            echo "This breaks"
         else
            echo "This continues"
         fi
         menu_03
       done
       echo "Test end"
       next_menu;
       ;;

       24)
       next_menu;
       ;;

       q|X|x )
        exit;
       ;;
       * )
        main_menu;
       ;;
   esac
}