Link to home
Start Free TrialLog in
Avatar of dbaseek
dbaseek

asked on

ora-00471

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

Avatar of dbaseek
dbaseek

ASKER

how can i fix that?

i would appreciate that?
Avatar of Guy Hengel [angelIII / a3]
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.

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.
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 :)
ASKER CERTIFIED SOLUTION
Avatar of Ravindran Gopinathan
Ravindran Gopinathan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dbaseek

ASKER

thanks