Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbw0: terminating instance due to error 472

Re: dbw0: terminating instance due to error 472

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 20 Nov 2000 20:15:10 -0000
Message-ID: <974749454.11236.0.nnrp-09.9e984b29@news.demon.co.uk>

It is possible - on the other hand, 472 explicitly claims that pmon is the cause - you may find, however, that another background process crashed bringing pmon down.

--

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 <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?
>
>
Received on Mon Nov 20 2000 - 14:15:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US