Find the answer to your Linux question:
Results 1 to 1 of 1
Hello, 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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Sep 2007
    Posts
    1

    Oracle Process freezes at 4 A.M. on GNU/Linux


    Hello,

    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

    thanks
    neelabh
    Last edited by neelabh_SE; 09-27-2007 at 08:40 AM. Reason: edited for suitable title

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •