RE: SQLPLUS with cronjob is giving problem

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Wed, 17 Sep 2003 03:09:43 -0800
Message-ID: <F001.005D037E.20030917030943@fatcity.com>

 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_at_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_at_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_at_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_at_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=> 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_at_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_at_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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Paula_Stankus_at_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_at_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).

Received on Wed Sep 17 2003 - 06:09:43 CDT