oracle pmon 多长时间,Oracle-Pmon terminated instance LGWR ORA-470

Pmon terminated instance due to LGWR termination

ORA-470

431246.1

Type:

PROBLEM

Modified Date :

28-APR-2008

Status:

MODERATED

This document is being delivered to you via Oracle Support's

Rapid Visibility (RaV) process, and therefore has not been

subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to

10.2.0.3

This problem can occur on any platform.

Symptoms

On Solaris Operating System (SPARC 64-bit) the following error

occurs.appeares in the alertlog

ORA-07445: exception encountered: core dump

[<0xffffffffff600010>] [SIGSEGV]

[unknown code] [0x000000000] [] []

which followed LGWR termination with the following error

ORA-00470: LGWR process terminated with errorthen instance

terminated by Pmon as follows:

PMON: terminating instance due to error 470Instance terminated by

PMON, pid = 31449

STACK TRACE:

ksedmp ksddoa ksdpcg ksdpec ksfpec kgesev ksesec0 ksbend ksbiid

ksulhdcb

ksucln ksbrdp opirip opidrv sou2o main start

Cause

This is usually caused as LGWR process abnormally at OS

level

the LGWR traces are blank. Based on the truss , this is because the

process has been killed before the trace file has been

completed.

from the truss output many occurences of :

kaio(AIOWAIT, 0xFFFFFFFFFFFFFFFF) Err#22 EINVAL

this condition describes a configuration problem

The following bug discussed the problem

Bug 3954239 PMON: TERMINATING INSTANCE DUE TO ERROR 470

Solution

Increase the value kernel parameter of vol_maxio.

To increase the value of vol_maxio:

1. Add an entry to /etc/system after the "forceload: drv/vxio"

line.

example: increase increase vol_maxio to 2K

set vxio:vol_maxio=2048

2. Reboot system

NOTE: there's no recommended settings for vol_maxio but it's

depends on your system.

For more information about the proper settings for kernel

parameters check the following note:

Note 138137.1 - SOLARIS: How To Determine UNIX Kernel

Parameters

References

Bug 3954239 - PMON: TERMINATING INSTANCE DUE TO ERROR 470

Note 138137.1 - SOLARIS: How To Determine UNIX Kernel

Parameters