Need Help...

From: Mamun Shaheed <ovimani_at_hotmail.com>
Date: 27 Nov 2003 09:07:57 -0800
Message-ID: <5991bf08.0311270907.49623c87@posting.google.com>

Hi, I am running oracle9i on Linux 7.3.
I have a script file running as cron job. the file is as follows

---

#!/bin/sh
clear
LOGFILE="log_`date +%Y%m%d`"

if [ ! -e /u08/Scripts/anomalies/$LOGFILE ] ; then

    touch /u08/Scripts/anomalies/$LOGFILE fi
echo "*Anomalies in Database on `date +%D`*" >> /u08/Scripts/anomalies/$LOGFILE

/u01/app/oracle/product/9.2.0/bin/sqlplus -s sa/ora123 << EOF_XTBL

spool /u08/Scripts/anomalies/output.log

select ani, custservice.modifieduserid
from custservice
where not exists (select 'x' from cust where cust.custid=custservice.custid) and serviceid=1
and (ani like '0%' and length(ani)=9);

spool off;

!echo "<<--Custservice without Customer-->>" >> /u08/Scripts/anomalies/$LOGFILE
!cat /u08/Scripts/anomalies/output.log >> /u08/Scripts/anomalies/$LOGFILE
EOF_XTBL

---

But I am getting following error mail from cron.

---

Subject: Cron <oracle_at_localhost> /u08/Scripts/anomalies/monitor >

    /u08/Scripts/anomalies/monitor.err

TERM environment variable not set.
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

---

How can I fixed this problem.

~MS Received on Thu Nov 27 2003 - 11:07:57 CST