Solaris

Hi all,
I have debugged this code and i am getting the syntax error at : `<<' unmatched.Please give solution trip


while($i<= 10)
do
sqlplus -s $DBUSER/$DBPWD@$DBHOST << EOF > oraerror.log
whenever sqlerror exit
exit
EOF
i=`expr ${i} + 1`

egrep 'ORA-121|ORA-01034' oraerror.log
if(($? == 0))
then
echo "database is down"
sleep 360
continue

thanks
megh

what scripting language are you using?

Run your script file through cat -vet and post the output here.

Code:

# cat -vet your_script

Remember to put [ C O D E ] tags around it too

if [-r /apps/vcr/appl/config/env ]$
then . /apps/vcr/appl/config/env;$
. /apps/vcr/appl/config/env_cust;$
else $
. /apps/vcred/appl/config/env ;$
. /apps/vcred/appl/config/env_cust ;$
$
fi$
$
day_mon=`date +%d`$
day_week=`date +%u`$
SQL_count="select count(*) from vcradmin.mv001ar_cust_mon_prior_yr" #dwspec.ar_customer_daily@ribp.world"$
SQL_sets="set pagesize 5000;$
set echo off;$
set heading off;$
set feedback off;$
set termout off;$
set trimspool on;"$
conn_oracle(){ $
row_cnt=`sqlplus -s $DBUSER/$DBPWD@$DBHOST<< EOF$
$SQL_sets$
$SQL_count$
exit$
EOF` $
echo "total row count is "$row_cnt$
}$
if(($day_mon >= 15 || $day_mon <= 25 && $day_week == 5 )) $
then$
for i in 1 2 3 4 $
do$
$
conn_oracle$
echo "no of row count is $row_count"$
if(($row_cnt >= 1))$
then$
$
echo "database is up and run the code here $row_cnt" $
$
exit$
$
$
else $
$
sleep 10$
continue #call the script here$
echo "data base is up script is going run "$
$
$
fi$
done$
$
else$
echo "It is not 3rd sunday the db is available script runs without DB check"$
fi$
$
$
$
$


I have done cat -vet script as above now i am not getting the result from count(*) from the db.