Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Crontabs and Oracle

RE: Crontabs and Oracle

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Wed, 28 Nov 2001 05:26:58 -0800
Message-ID: <F001.003CEC6F.20011128045021@fatcity.com>

Also, in the crontab entry, make sure u have an entry somewhat like this :

20 8 * * * su - oracle -c '/<path of the script>/<name of the script>' > /dev/null 2>&1

which means that the script will run at 8:30 every morning on all days of the week.

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : samir.sarkar_at_nottingham.sema.slb.com

            samir.sarkar_at_sema.co.uk
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018

-----Original Message-----
Sent: 28 November 2001 11:35
To: Multiple recipients of list ORACLE-L

Does this run from Oracles crontab ??

I would suggest that you need to set up some environment variables in the script.

Export your ORACLE_HOME in the script
and add the following to your path variable

export PATH=$PATH:$ORACLE_HOME/bin

HTH Lee

-----Original Message-----
Sent: 28 November 2001 11:00
To: Multiple recipients of list ORACLE-L

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


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: lerobe_at_acxiom.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).


___________________________________________________________________________
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  INET: Samir.SARKAR_at_nottingham.sema.slb.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 - 07:26:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US