Re: dbw0: terminating instance due to error 472

From: <prionnsias_at_my-deja.com>
Date: Mon, 20 Nov 2000 14:12:11 GMT
Message-ID: <8vbbfk$a33$1@nnrp1.deja.com>

The pmon trace contains:

/opt/app/oracle/admin/uky1/bdump/pmon_1977.trc Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /opt/app/oracle/816
System name: Linux

Node name:      lab1pp.yac.com
Release:        2.2.14-12
Version:        #1 Tue Apr 25 13:04:07 EDT 2000
Machine:        i686

Instance name: uky1
Redo thread mounted by this instance: 0 <none> Oracle process number: 2
Unix process pid: 1977, image: oracle_at_lab1pp.yac.com (PMON)

SESSION ID:(1.1) 2000-11-16 17:36:47.247 Load Indicator not supported by OS !
2000-11-17 13:55:37.668 Background_Core_Dump = partial

I have read somewhere that a corrupt block can cause the dbw0 to fall over and cause an instance crash, which indirectly would affect the PMON?

In article <974670099.8681.0.nnrp-10.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 472 means that pmon terminated.
>
> Is there a trace file for pmon that will
> tell you more ?
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
>
> Publishers: Addison Wesley Longman
> Book bound date: 8th Dec 2000
> See a first review at:
> http://www.ixora.com.au/resources/index.htm#practical_8i
>
> prionnsias_at_my-deja.com wrote in message <8v9dfq$s90
$1_at_nnrp1.deja.com>...
> >Hi,
> >
> >Whilst performing a soak test, 20+ hrs with 120
> >simultanous calls the database crashed with:
> > dbw0: terminating instance due to error 472
> >
> >Any ideas into a reason for this ?
> >or a workaround ?
> >
> >I have already got a suggestion about increasing dml_locks
> >and enqueue_resources which I am currently looking into.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 20 2000 - 08:12:11 CST