ORA-00471: DBWR process terminated with error
Sunsh...@gmail.com
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.
Is there any routines to figure out this error "ORA-000471"? Is this
oracle bug, or system configuration fault?
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 .
I had try my best to resolve it and unfortunately did not achieve
nothing.
You can refer the fllowing information. Your strong help and support is
a great treasure to me for certain.
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@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
fitzj...@cox.net
Sunsh...@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.
David Fitzjarrell