Re: ORA-00471: DBWR process terminated with error

Jason Lisenchuk (hris_at_nt.com) wrote:
> Any insight into what might be causing this? This obviously affects the
> integrity of REDO logs, and not surprisingly, results in a corrupted
> database. This error occurred on a high end HP 9000 running Oracle
> 7.0.16, 512 MB RAM, 12 GB disk array (half of which is free). I am
> assuming that either a hardware fault occurred or something went awry in
> the system software.
 

> Thank you for your time: any ideas, no matter how speculative, would be
> welcome.

I had a problem a while back on a 6.0.33 data base with the DBWR proccess terminating with error. It was caused by the swap space being filled up by a runaway process. It was a C program I had written and it had a bug in it which caused it to malloc inside an infinite loop. When it started getting malloc errors, the DBWR process fell over. :-)

(Fortunately, it was on the development machine so the data in the database was not critical.)

--
 
John Blackburn                                          Phone: +61 7 2534634
jb2_at_qdot.qld.gov.au                                     Fax:   +61 7 8541194