Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8HDHn813441 for ; Wed, 17 Sep 2003 08:17:50 -0500 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8HDHn513434 for ; Wed, 17 Sep 2003 08:17:49 -0500 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id h8HAATi27187 for oracle-l@orafaq.net; Wed, 17 Sep 2003 03:10:29 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D037E; Wed, 17 Sep 2003 03:09:43 -0800 Message-ID: Date: Wed, 17 Sep 2003 03:09:43 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Paula_Stankus@doh.state.fl.us Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Paula_Stankus@doh.state.fl.us Subject: RE: SQLPLUS with cronjob is giving problem Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C37D03.8FEA4618" ------_=_NextPart_001_01C37D03.8FEA4618 Content-Type: text/plain 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----- To: Multiple recipients of list ORACLE-L Sent: 9/17/03 3:59 AM 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: ORACLE-L@fatcity.com >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/welcome1@xyz >@/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: sami_resume@yahoo.com > >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: ListGuru@fatcity.com (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). _____ 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: good_dba@hotmail.com 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: ListGuru@fatcity.com (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). ------_=_NextPart_001_01C37D03.8FEA4618 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: SQLPLUS with cronjob is giving problem

 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: ORACLE-L@fatcity.com
>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_moni= tor.sh
> > /tmp/xyz_conn_monitor.lst 2>&1 =
>
>$ cat xyz_conn_monitor.sh
>/u02/app/oracle/product/8.1.7/bin/sqlplus =
>user1/welcome1@xyz
>@/export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_mon= itor.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_moni= tor.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: sami_resume@yahoo.com
>
>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: ListGuru@fatcity.com (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=3D> 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: good_dba@hotmail.com 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:
ListGuru@fatcity.com (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).

------_=_NextPart_001_01C37D03.8FEA4618-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Paula_Stankus@doh.state.fl.us 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: ListGuru@fatcity.com (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).