| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Crontabs and Oracle
You need to set the profile. In the beginning of the script call your
.profile to set the path and variables. Then set your SID if necessary. . /opt/oracle/.profile . envora SID
Michael Koniszewski
D.B.A. FairPoint Communications
518-242-5922
> -----Original Message-----
> From: Thomas, Kevin [SMTP:Kevin.Thomas_at_calanais.com]
> Sent: Wednesday, November 28, 2001 6:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Crontabs and Oracle
>
> Guys,
>
> I have a Unix shell script that runs and does some things with sqlplus.
> The
> script runs fine when I start it up manually just using the command
>
> $ host_startup.sh
>
> However, If I try to start this host_startup.sh from the Crontab I get
> this
> error logged in my mail.
>
> From apt2 Wed Nov 28 08:15:01 2001
> Date: Wed, 28 Nov 2001 08:15:01 GMT
> Message-Id: <200111280815.IAA24337_at_phys-ki-sun4k2.scottishpower.plc.uk>
> To: apt2
> Content-Length: 143
>
> Your "cron" job on phys-ki-sun4k2
> /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh
>
> produced the following output:
>
> sqlplus: Command not found
>
>
> Any ideas? I've specifically said in the shell script where to find the
> sqlplus binaries, so I'm not sure?! Any help would be much appreciated.
>
> Cheers,
> Kev.
>
> "I put instant coffee in a microwave oven and almost went back in time. "
> __________________
>
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
>
>
>
>
> -----Original Message-----
> Sent: 21 November 2001 12:20
> To: Multiple recipients of list ORACLE-L
>
>
>
> Have a look at Categoric Xalerts.
>
> It is a general purpose Alerting system, not just for DBA and SYSADMs.
>
> Their new Java based system is just out.
>
> www.categoric.com
>
> Steve Parker
> Technical Consultant
> LIS
>
> ------------------------------
> Logistics & Internet Systems Ltd.
> E Mail: steve.parker_at_lis.co.uk
> ------------------------------
>
>
>
>
>
> Kumanan Balasundaram
>
> <kumanan.balasundara To: Multiple recipients
> of list ORACLE-L <ORACLE-L_at_fatcity.com>
> m_at_qxl.com> cc:
>
> Sent by: Subject: Reliable
> alerting system that is not so costly??
> root_at_fatcity.com
>
>
>
>
>
> 21/11/2001 11:50
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Hi there,
>
> Any of you using or have come across a reliable alert system that can also
> escalate
> to different persons based on criteria such as how important that system
> is?
>
> We are looking to invest in such a software.
>
> Kumanan Balasundaram
> Database Administrator, IT
> QXL ricardo plc
> www.qxl.com
> P: +44 (0)208 962 7409
>
> > QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge
> Road,
> > London W6 9EJ
> > Registered in England No 3430894 VAT number - GB 701 8915 43
> >
> > The information transmitted is intended only for the person or entity to
> > which it is addressed and may contain confidential and/or privileged
> > material. Any review, retransmission, dissemination or other use of, or
> > taking of any action in reliance upon, this information by persons or
> > entities other than the intended recipient is prohibited. If you
> > received this in error, please contact the sender and delete the
> material
> > from any computer
> >
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> postmaster_at_qxl.com
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer
> viruses.
>
> **********************************************************************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kumanan Balasundaram
> INET: kumanan.balasundaram_at_qxl.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author:
> INET: Steve.Parker_at_lis.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
> --
> Author: Thomas, Kevin
> INET: Kevin.Thomas_at_calanais.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com -- Author: Koniszewski, Mike INET: mkonisze_at_fairpoint.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Nov 28 2001 - 06:47:36 CST
 |
 |