Re: Need Help...

Hi Kenneth,
I am new commer in Linux+Oracle environment. As you suggested, if I put all oracle releated veriable like
ORACLE_HOME, ORACLE_BASE, ORACLE_SID
in my script, will it work??

Can you please provide me any example.

~M$

Kenneth Koenraadt wrote in message news:<3fc66155.2641498_at_news.inet.tele.dk>...
> 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 Fri Nov 28 2003 - 04:04:06 CST