Re: Need Help...

Hi Mamun,

when executing its jobs, cron only sets some very basic environment variables, among which are neither ORACLE_HOME or TERM. You need to set them in your script or (better) put them into a separate script and call the script from within your script below like :

". my_script_containing_env_variables.sh"

• Kenneth Koenraadt

On 27 Nov 2003 09:07:57 -0800, ovimani_at_hotmail.com (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
>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 - 14:44:15 CST