ora-00471

SQL> shutdown immediate;
ORA-00471: DBWR process terminated with error      

dbaseekAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ravindran_eeeConnect With a Mentor Commented:
As rbrooker suggested, just try re-starting again..
It could be very well due to some server issues.. If the error is persistent then its a serious issue.. If it is not replicated then it can very well be ignored!
0
 
dbaseekAuthor Commented:
how can i fix that?

i would appreciate that?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you will find the underlying error by looking at the alert<SID>.log file, which is in the folder indicated by the bdump setting in the pfile/spfile.

0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Mark GeerlingsDatabase AdministratorCommented:
It is never good when one of Oracle's background processes (PMON, SMON, DBWR, ARCH, etc.) terminate with an error.  This apparently happened right after you tried to do: "shutdown immediate;".  Is that correct?

You may have to look in the alert_[SID].log file or in the [SID]_dbw*.log file for more information, if you want to figure out what caused the ORA-00471 error.

I would try a "startup;" to see if that succeeds.  If it does, you may be OK.  But,it would be good to take a backup now just to be safe.
0
 
rbrookerCommented:
Hi,

this is what oracle recommends :

[oracle@ed-olraclin68a oracle]$ oerr ora 471
00471, 00000, "DBWR process terminated with error"
// *Cause:  The database writer process died
// *Action: Warm start instance
[oracle@ed-olraclin68a oracle]$

just restart the database.

good luck :)
0
 
dbaseekAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.