Hello,
I have written a script to bring up/down oracle databases. I am getting the following error : syntax error "<<" unmatched
Here is the script
#!/bin/ksh
# THIS SCRIPT WILL BE USED TO STARTUP AND SHUTDOWN THE DATABASES
# NOTE: You must supply a start/stop on command line (ie db start)
# - Nitro Microsystems -
ACTION=$1
DATABASE=`/usr/bin/grep oracle /etc/oratab|grep -v "*"|awk '{FS=":"}{print $1}'`
ORA_PATH=`/usr/bin/grep oracle /etc/oratab|grep -v "*"|awk '{FS=":"}{print $2}'|
/usr/bin/head -1`
SVR=/usr/oracle/product/8.0.5/bin/svrmgrl
# ENSURE THAT AN ACTION HAS BEEN GIVEN - IE START OR STOP
if [ -z "${ACTION}" ]
then
echo
echo "You must supply a start or stop command"
echo
echo "USAGE : db.ksh start or db.ksh stop"
echo
exit 1
case $ACTION in
'stop')
for DB in $DATABASE
do
export ORACLE_SID=$DATABASE
export PATH=.:$ORA_PATH/bin:$PATH
$SVR << EOF
connect internal
shutdown immediate
EOF
done
;;
'start')
for DB in $DATABASE
do
export ORACLE_SID=$DATABASE
export PATH=.:$ORA_PATH/bin:$PATH
$SVR << EOF
connect internal
startup
startup
done
;;
*)
echo
echo YOUR START/STOP COMMAND WAS INCORRECT...ensure that it is
echo in lowercase IE: db.ksh start or db.ksh stop
echo
;;
esac
Not sure why this will not work. Thanks for the help,
Sally
