• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1035
  • Last Modified:

ora-00471

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

0
dbaseek
Asked:
dbaseek
1 Solution
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
ravindran_eeeCommented:
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:
thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now