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
}