Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file.
#!/bin/sh
# A menu driven Shell script which has following options
# for acmtoron@>
#
#
# Exit
# As per option do the job
#----
while :
do
clear
echo " A C M LOG MONITORING (TOR)"
echo "1. Admin Server Log"
echo "2. Nohup.out"
echo "3. System Log"
echo "4. Alert Log"
echo "5. Disk Free (kb)"
echo "6. Disk Free (mounted files)"
echo "7. Disk Space" echo "8. Swap Info"
echo "9. Push Jobs"
echo "0. Exit"
echo -n "Please enter option [0 - 9]"
read opt
case $opt in
1) echo "*********Admin Server (TOR)*********";
tail -f /opt/bea/SPERogers/SPEDomain/servers/AdminServer/logs/AdminServer.log
;;
2) echo "*********Nohup.out (TOR)*********"
tail -f /opt/bea/SPERogers/SPEDomain/nohup.out
;;
3) echo "*********System Log (TOR)*********"
cat /var/adm/syslog/syslog.log
;;
4) echo "*********Alert Log (TOR)*********"
tail -f /data/oracle10/admin/torosped/bdump/alert_torosped.log
;;
5) echo "*********Disk Free in Kilobytes*********"
df - b
;;
6)echo "*********Disk Free (mounted files)*********"
df -g
;;
7) echo "*********Disk space*********"
bdf
;;
8) echo "*********Swap Info*********"
swapinfo
;;
9) echo "*********Push Jobs*********"
> su - oracle10
>sqlplus / as sysdba
> SELECT COUNT(DISTINCT DEFERRED_TRAN_ID) "Transactions Queued" FROM DEFTRANDEST;
0) echo "*********Logout*********"
exit 1;;
*) echo "$opt is an invalid option. Please select option between 0-8 only";
echo "Press [enter] key to continue. . .";
read enterKey;;
esac
done