Re: dbw0: terminating instance due to error 472

Hi,
If you are working on linux probably U have hit a bug.. The possible solutions could be
a) disable mts i.e comment out mts_servers and mts_max_servers b) disable large_pool_size

HTH,
justvrk

<prionnsias_at_my-deja.com> wrote in message news:8vbbfk$a33$1_at_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 - 09:03:33 CST