Re: Need Help...

Mamun Shaheed wrote:
> 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

Where are you setting up your environment (.profile and oraenv)?

> 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

-- 
Ron Reidy
Oracle DBA