Re: OT: Cron not working

2003-02-04 Thread Robert Eskridge
$ps xea | grep crond

Will show you if the cron process is running or not

-rje


VB Hello to everyone...

VB Red Hat 6.2

VB How do I find out what is wrong with cron? From January 15th until today
VB cron is not working... My (oracle's) crontab file HAS not changed...

VB So I went to the /var/log/cron file. Last activity was on January 15th.
VB Since then no activity has been recorderd.

VB If I issue crontab my crontab file and afterwards crontab -l, there
VB are lines

VB oracle (02/04-11:37:14-7686) REPLACE (oracle)
VB oracle (02/04-11:37:17-7690) LIST (oracle)

VB My job was scheduled on 11:40, however job wasn't executed.

VB How do I see whether cron is running or not?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Eskridge
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




Re: OT: Cron not working

2003-02-04 Thread Vladimir Barac
Oh, really? I'm not beginner...

Anyway, thanks... Solution was weird...

When I deleted /var/log/cron file, then touched /var/log/cron and then
started cron - everything went
back to normal.

Why the f(#$^%* it wasn't working, I don't understabd... /var/log/cron was
small (~30k), df -k /var/log gave me about 1 Gig of free space... Yet,
cron was not working...


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 13:23


 $ps xea | grep crond

 Will show you if the cron process is running or not

 -rje


 VB Hello to everyone...

 VB Red Hat 6.2

 VB How do I find out what is wrong with cron? From January 15th until
today
 VB cron is not working... My (oracle's) crontab file HAS not changed...

 VB So I went to the /var/log/cron file. Last activity was on January
15th.
 VB Since then no activity has been recorderd.

 VB If I issue crontab my crontab file and afterwards crontab -l,
there
 VB are lines

 VB oracle (02/04-11:37:14-7686) REPLACE (oracle)
 VB oracle (02/04-11:37:17-7690) LIST (oracle)

 VB My job was scheduled on 11:40, however job wasn't executed.

 VB How do I see whether cron is running or not?

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Robert Eskridge
   INET: [EMAIL PROTECTED]

 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: [EMAIL PROTECTED] (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: Vladimir Barac
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




RE: OT: Cron not working

2003-02-04 Thread John.Hallas
Vladimir,
I have seen 2 replies to questions today that were less than tactful, yours
and one regarding awk  ksh
If you post a message asking for help and someone tries to help then it is
bad manners to be critical of that help.

I am replying to this because I also replied to your post with some basic
info on the use of cron, the same as Robert did.
If we both read your mail and thought you had minimal knowledge of cron then
perhaps your post was at fault , not those who offer help.

Glad to hear you have sorted the problem anyway

John


-Original Message-
Sent: 04 February 2003 13:19
To: Multiple recipients of list ORACLE-L


Oh, really? I'm not beginner...

Anyway, thanks... Solution was weird...

When I deleted /var/log/cron file, then touched /var/log/cron and then
started cron - everything went
back to normal.

Why the f(#$^%* it wasn't working, I don't understabd... /var/log/cron was
small (~30k), df -k /var/log gave me about 1 Gig of free space... Yet,
cron was not working...


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 13:23


 $ps xea | grep crond

 Will show you if the cron process is running or not

 -rje


 VB Hello to everyone...

 VB Red Hat 6.2

 VB How do I find out what is wrong with cron? From January 15th until
today
 VB cron is not working... My (oracle's) crontab file HAS not changed...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




RE: OT: Cron not working

2003-02-04 Thread Stephen Lee

 -Original Message- 
 Why the f(#$^%* it wasn't working,


You obviously ARE a beginner as it is clear you have not become familiar
with capriciousness of sunspots!
SUNSPOTS!  It's SUNSPOTS!
Now you know; so don't ask why anymore.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




Antwort: RE: OT: Cron not working

2003-02-04 Thread Alex . Apostolopoulos




Vladimir:

fuser /var/log/cron and lsof might be a starting point to find out what
went wrong.

It will give you a list of programs that currently have this inode open.
If one of these programs has opened the logfile in blocking mode
then other programs will simply sit there and wait or time out depending
on the implementation ( ioctl,termio ) when they try to open the logfile.
Under some circumstances it is possible that the kernel (who keeps the
list of open inodes and their condition) does not get notified when the
program
owning this inode died, rarly happens as kernels are quite robust. Therefor
I am sure a reboot would have solved the problem as well allthought not
recomended.

So you would have to inspect the relevant kernel tables (adb on hp-ux,
maybe
the /proc directory under red hat offers help here).
The reason why it worked when you deleted and touched the file was because
it then has received a new inode as ls -i would show and therefore the
related
lock is pointing to another destination. After the fopen only the inode is
relevant
not the name any more.

of course  if cron is not working the first thing you should check is if
the daemon
is running :-)))

HTH

cheers alex



   
   
  John.Hallas@voda
   
  fone.co.uk   An:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]  
  Gesendet von: Kopie: 
   
  [EMAIL PROTECTED]  Thema:   RE: OT: Cron not working  
   
   
   
   
   
  04.02.2003 15:39 
   
  Bitte antworten  
   
  an ORACLE-L  
   
   
   
   
   



Vladimir,
I have seen 2 replies to questions today that were less than tactful, yours
and one regarding awk  ksh
If you post a message asking for help and someone tries to help then it is
bad manners to be critical of that help.

I am replying to this because I also replied to your post with some basic
info on the use of cron, the same as Robert did.
If we both read your mail and thought you had minimal knowledge of cron
then
perhaps your post was at fault , not those who offer help.

Glad to hear you have sorted the problem anyway

John


-Original Message-
Sent: 04 February 2003 13:19
To: Multiple recipients of list ORACLE-L


Oh, really? I'm not beginner...

Anyway, thanks... Solution was weird...

When I deleted /var/log/cron file, then touched /var/log/cron and then
started cron - everything went
back to normal.

Why the f(#$^%* it wasn't working, I don't understabd... /var/log/cron was
small (~30k), df -k /var/log gave me about 1 Gig of free space... Yet,
cron was not working...


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 13:23


 $ps xea | grep crond

 Will show you if the cron process is running or not

 -rje


 VB Hello to everyone...

 VB Red Hat 6.2

 VB How do I find out what is wrong with cron? From January 15th until
today
 VB cron is not working... My (oracle's) crontab file HAS not changed...

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

Fat City Network

RE: OT: Cron not working

2003-02-04 Thread Gogala, Mladen
Wow! another BDBAFH! And Jared says that this isn't a DBA list?

 -Original Message-
 From: Stephen Lee [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, February 04, 2003 9:54 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OT: Cron not working
 
 
 
  -Original Message- 
  Why the f(#$^%* it wasn't working,
 
 
 You obviously ARE a beginner as it is clear you have not 
 become familiar
 with capriciousness of sunspots!
 SUNSPOTS!  It's SUNSPOTS!
 Now you know; so don't ask why anymore.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




RE: OT: Cron not working

2003-02-04 Thread Stephen Lee


 -Original Message-
 
 Wow! another BDBAFH! And Jared says that this isn't a DBA list?
 
-

No. No. I'm really (B)eneficial from (H)eaven!  (See my halo?)
The question about what to do about the situation had been answered.  But
the question about WHY it happened 
Why!?  You want to know WHY!?
There is only one answer to that.  And it is ALWAYS that one answer.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




Re: Antwort: RE: OT: Cron not working

2003-02-04 Thread vladob

Great answer! And thanks a lot! I'll keep this one burned on some cd with other 
great mails fropm this list...

Quoting [EMAIL PROTECTED]:

 
 
 
 
 Vladimir:
 
 fuser /var/log/cron and lsof might be a starting point to find out
 what
 went wrong.
 
 It will give you a list of programs that currently have this inode open.
 If one of these programs has opened the logfile in blocking mode
 then other programs will simply sit there and wait or time out depending
 on the implementation ( ioctl,termio ) when they try to open the
 logfile.
 Under some circumstances it is possible that the kernel (who keeps the
 list of open inodes and their condition) does not get notified when the
 program
 owning this inode died, rarly happens as kernels are quite robust.
 Therefor
 I am sure a reboot would have solved the problem as well allthought not
 recomended.
 
 So you would have to inspect the relevant kernel tables (adb on hp-ux,
 maybe
 the /proc directory under red hat offers help here).
 The reason why it worked when you deleted and touched the file was
 because
 it then has received a new inode as ls -i would show and therefore the
 related
 lock is pointing to another destination. After the fopen only the inode
 is
 relevant
 not the name any more.
 
 of course  if cron is not working the first thing you should check is if
 the daemon
 is running :-)))
 
 HTH
 
 cheers alex
 
 
 
 
  
   John.Hallas@voda 
  
   fone.co.uk   An:  Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]  
   Gesendet von: Kopie:  
  
   [EMAIL PROTECTED]  Thema:   RE: OT: Cron
 not working 
 
  
 
  
   04.02.2003 15:39  
  
   Bitte antworten   
  
   an ORACLE-L   
  
 
  
 
  
 
 
 
 Vladimir,
 I have seen 2 replies to questions today that were less than tactful,
 yours
 and one regarding awk  ksh
 If you post a message asking for help and someone tries to help then it
 is
 bad manners to be critical of that help.
 
 I am replying to this because I also replied to your post with some
 basic
 info on the use of cron, the same as Robert did.
 If we both read your mail and thought you had minimal knowledge of cron
 then
 perhaps your post was at fault , not those who offer help.
 
 Glad to hear you have sorted the problem anyway
 
 John
 
 
 -Original Message-
 Sent: 04 February 2003 13:19
 To: Multiple recipients of list ORACLE-L
 
 
 Oh, really? I'm not beginner...
 
 Anyway, thanks... Solution was weird...
 
 When I deleted /var/log/cron file, then touched /var/log/cron and then
 started cron - everything went
 back to normal.
 
 Why the f(#$^%* it wasn't working, I don't understabd... /var/log/cron
 was
 small (~30k), df -k /var/log gave me about 1 Gig of free space... Yet,
 cron was not working...
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, February 04, 2003 13:23
 
 
  $ps xea | grep crond
 
  Will show you if the cron process is running or not
 
  -rje
 
 
  VB Hello to everyone...
 
  VB Red Hat 6.2
 
  VB How do I find out what is wrong with cron? From January 15th until
 today
  VB cron is not working... My (oracle's) crontab file HAS not
 changed...
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: [EMAIL PROTECTED]
   INET: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB

RE: OT: Cron not working

2003-02-04 Thread vladob

Thanks!

I knew that it is something else! My first assumption was related to Gremlins...


Quoting Stephen Lee [EMAIL PROTECTED]:

 
  -Original Message- 
  Why the f(#$^%* it wasn't working,
 
 
 You obviously ARE a beginner as it is clear you have not become familiar
 with capriciousness of sunspots!
 SUNSPOTS!  It's SUNSPOTS!
 Now you know; so don't ask why anymore.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).