Results 1 to 1 of 1
Thread: Oracle Process freezes at 4 A.M.
Enjoy an ad free experience by logging in. Not a member yet? Register.
- Join Date
- Sep 2007
Oracle Process freezes at 4 A.M. on GNU/Linux
i have GNU/Linux on which Oracle 10g Release 10.2.0.1.0 Database server is running.
I have a process scheduled for Saturday 0010 hours.(this whole process takes at least 10 hours to complete successfully).
the problem is that Oracle process just freezes at around 4'o clock and never completes till manual intervention.
Also i tested to run the same Oracle process at different time( Sunday 1800 hours) and it finished successfully.
i did some research to check if any other job is running at that time by checking log. I found out that there are few jobs in cron.daily file ("00-logwatch", "00-makewhatis.cron", "00webalizer", "0anacron", "certwatch", "logrotate", "prelink", "rpm", "slocate.cron"," tmpwatch") which are scheduled at 0402 hours clock.
I found these timing awfully coincidental so tried to dig around this but I'm not able to figure out exact usage of these jobs and most importantly it's effect on ORACLE PROCESS.
I would appreciate if someone could help me to find out exact reason of process freezing and whether this could be attributed to Linux scheduled cron jobs.
below is the crontab file ( if it helps)
01 * * * * root run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly
Last edited by neelabh_SE; 09-27-2007 at 08:40 AM. Reason: edited for suitable title