dbaseek
asked on
ora-00471
SQL> shutdown immediate;
ORA-00471: DBWR process terminated with error
ORA-00471: DBWR process terminated with error
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.
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 :)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
i would appreciate that?