Dear Sami,
As a matter of fact whatever environ. values are set in your .profile are not in operation through a crontab process.
To deal with this issue we do something that I have seen others do as well. We basically create a .profilecron which we call as the first parameter in our scripts that we want to run in the profile. We also ensure that this .profileron will work when we run the scripts interactively. So let's say you have a script runsql.ksh You would put immediately after:
!#/bin/ksh
**************************************
* comments
************************************
. /export/home/oracle/.profilecron
Please double-check my syntax for running the korn shell. This assumes that you do. In fact, if you do and do not set that in your scripts you will have problems with some commands not running correctly.
Good luck.
Paula
-----Original Message-----
From: H elp_me
To: Multiple recipients of list ORACLE-L
Sent: 9/17/03 3:59 AM
Subject: Re: SQLPLUS with cronjob is giving problem
Hello Sami,
Check the environment variables.. such as ORACLE_HOME, LD_LIBRARY_PATH,
and just PATH.. Are they set .. when you execute from CRON ? You will
have them when you execute from unix login.
Hope this helps.
Nikunj
>From: Oracle DBA
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
>Subject: SQLPLUS with cronjob is giving problem
>Date: Tue, 16 Sep 2003 06:04:25 -0800
>
>Hi List
>
>
>I am trying to automate "Number of Oracle Connections"
>using cronjob.
>
>$ crontab -l
>0 8 * * *
>/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh
> > /tmp/xyz_conn_monitor.lst 2>&1
>
>$ cat xyz_conn_monitor.sh
>/u02/app/oracle/product/8.1.7/bin/sqlplus
>user1/[EMAIL PROTECTED]
>@/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sql
>
>$ cat xyz_conn_monitor.lst
>Message file sp1.msb not found
>Error 6 initializing SQL*Plus
>
>But if run
>/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh
>in unix $ prompt, it is running fine.
>
>Could someone help me to resolve the same?
>
>
>Thanks in advance
>Sami
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! SiteBuilder - Free, easy-to-use web site design software
>http://sitebuilder.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Oracle DBA
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_____
<http://g.msn.com/8HMBENUS/2740??PS=> Fast, faster, fastest: Upgrade to
Cable or DSL today!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Author: H elp_me INET: [EMAIL PROTECTED] Fat City Network Services --
858-538-5051 http://www.fatcity.com San Diego, California -- Mailing
list and web hosting services
--------------------------------------------------------------------- To
REMOVE yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
