Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8.0.4 on NT / jobs problem
Oracle will be issueing a point release (8.0.5.2) which will address this issue. It is scheduled for the end of August, but more than likely will be available the beginning of Sept. Bug # 882445
Sorry if you get this twice.
In article <2465A05A033BD111969500805F4BEF5B3AB0FF_at_SULACO>,
Bas Haenraets <bhaenraets_at_ortec.nl> wrote:
> 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
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Aug 05 1999 - 11:29:36 CDT