Oracle8.0.4 on NT / jobs problem

From: Bas Haenraets <bhaenraets_at_ortec.nl>
Date: 2 Aug 1999 10:03:43 GMT
Message-ID: <2465A05A033BD111969500805F4BEF5B3AB0FF@SULACO>

Hello,

A colleague of mine is using Oracle jobs to perform tasks at scheduled intervals. The scheduled tasks use the UTL_FILE package to write statistics to a file. Each task writes to a new, non-existent file.

Problem is: every second job fails, resulting in a crash of the SNP-background process! After some time PMON notices the SNP-process is not running anymore, and restarts the SNP-process. The SNP-process notices it's behind schedule, and starts a job. This job completes succesfully. Next time the job is run, it crashes the SNP-process and the whole circus starts all over again.

Questions:
1) In my humble opinion, a job should not be able to crash a background process. Am I right?
2) Does anyone have / has anyone ever had similar problems, and is there a solution?

Any help would be HUGELY appreciated!

Thanks,
Bas Received on Mon Aug 02 1999 - 05:03:43 CDT