Re: ORA-00471: DBWR process terminated with error

Comments embedded.
Sunshine.Du_at_gmail.com wrote:
> Hello,
> I had met a question. The oracle database will crash after about every
> five days. The "pmon" had detected the DBWR was terminated suddenly. I
> am very dismayed, because according to the other threads said, most of
> this issue was due to the Oracle Bug.
>

Any particular bug?

> Is there any routines to figure out this error "ORA-000471"? Is this
> oracle bug, or system configuration fault?
>

One normally consults tahiti.oracle.com to look up such errors. Also you could use:

$ oerr ora 471

to return the cause of the error and the possible corrective action required.

> The version of oralce is Release 10.1.0.2.0.
>
> The version of platform is Linux 2.4.20, MontaVista(R) Linux(R)
> Carrier Grade Edition 3.1 .
>

This does not appear to be a supported release of Linux with respect to Oracle.

> I had try my best to resolve it and unfortunately did not achieve
> nothing.
>

With an unsupported Oracle/Linux combination I expect not.

>
>
> You can refer the fllowing information. Your strong help and support is
> a great treasure to me for certain.
>

My suggestion is to install a supported release of Linux and re-install Oracle.

>
>
>
>
>
>
> Dump file /db/ORAdbs/admin/DB01/bdump/db01_pmon_637.trc
>
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
>
> With the Partitioning, OLAP and Data Mining options
>
> ORACLE_HOME = /opt/ORAdbs/oracle10g
>
> System name: Linux
>
> Node name: oamce-2
>
> Release: 2.4.20_mvlcge31-cpci735
>
> Version: #1 Wed Nov 1 08:06:15 CST 2006
>
> Machine: i686
>
> Instance name: DB01
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 2
>
> Unix process pid: 637, image: oracle_at_oamce-2 (PMON)
>
>
>
> *** SERVICE NAME:() 2006-12-20 02:05:28.845
>
> *** SESSION ID:(170.1) 2006-12-20 02:05:28.845
>
> *** 2006-12-20 02:05:28.845
>
> Old character set id was US7ASCII
>
> *** 2006-12-20 02:05:28.883
>
> New character set id is US7ASCII
>
> *** 2006-12-29 03:41:12.479
>
> error 471 detected in background process
>
> ORA-00471: DBWR process terminated with error
>
>
>
> Fri Dec 29 03:41:12 2006
>
> Errors in file /db/ORAdbs/admin/DB01/bdump/db01_pmon_637.trc:
>
> ORA-00471: DBWR process terminated with error
>
> Fri Dec 29 03:41:12 2006
>
> PMON: terminating instance due to error 471
>
> Instance terminated by PMON, pid = 637
>
> Fri Dec 29 03:47:15 2006
>
> Starting ORACLE instance (normal)
>
> LICENSE_MAX_SESSION = 0
>
> LICENSE_SESSIONS_WARNING = 0
>
> Picked latch-free SCN scheme 2
>
> KCCDEBUG_LEVEL = 0
>
> Autotune of undo retention is turned off.
>
> Dynamic strands is set to TRUE
>
> Running with 1 shared and 0 private strand(s). Zero-copy redo is FALSE
>
> LICENSE_MAX_USERS = 0
>
> SYS auditing is disabled
>
> Starting up ORACLE RDBMS Version: 10.1.0.2.0.
>
>
>
>
>
> Best Regards
>
> Du shaoqiang
>
> FSD TAC
David Fitzjarrell Received on Sun Dec 31 2006 - 17:15:42 CST