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: Thomas, Kevin <Kevin.Thomas_at_calanais.com>
Date: Wed, 28 Nov 2001 04:24:36 -0800
Message-ID: <F001.003CEBB3.20011128040533@fatcity.com> 






Thanks John. Unfortunately I can't do an SU either :o(
 


Cheers,


Kev.
 


"hit any user to continue" 





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 <http://www.calanais.com/>  




-----Original Message-----


Sent: 28 November 2001 11:42


To: Multiple recipients of list ORACLE-L





I don't know if it is relevant but on Compaq Tru64 we have to su - oracle
even within the oracle cron 


so a sample entry looks looks as follows. 



10 19 * * * su - oracle -c '/usr/local/bin/tidy_listener_log.sh'  > etc etc 



Your message_is mentions Sun in which case I am sure this does not need to
be done (nor HP). Hope it is useful, probably not




John 



-----Original Message----- 


<mailto:Kevin.Thomas_at_calanais.com> ] 


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



>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 


(to the numbers or address above) immediately.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


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


Received on Wed Nov 28 2001 - 06:24:36 CST












Original text of this message













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