Re: PMON unable to acquire latch

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Jan 2001 20:53:12 -0000
Message-ID: <980802025.4244.2.nnrp-14.9e984b29@news.demon.co.uk>

I don't have 8.0.4 any more, but I think if you

select name from v$latch
you may find that there is a latch called

'modify parameter values'.

I would guess that you don't have a real problem unless

>possible holder pid = 28 ospid=24678 is always the same.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



kiteman wrote in message ...


>I'm getting the error below every 5-6 hours.  It mentions something about

>modifying parameter values.  Any idea paramters are being referred to? Any

>help would be greatly appreciated.

>

>Dump file/opt/oracle/admin/win4prod/bdump/win4prod_pmon_26092.trc

>Oracle8 EnterpriseEdition Release 8.0.4.3.0 - Production

>With the Partitioning option

>PL/SQLRelease 8.0.4.3.0 - Production

>ORACLE_HOME =/opt/oracle/app/oracle/product/8.0.4

>System name: SunOS

>Node name:epfwpf03

>Release: 5.6

>Version: Generic_105181-16

>Machine:sun4u

>Instance name: win4prod

>Redo thread mounted by this instance: 1

>Oracleprocess number: 2

>Unix process pid: 26092, image: ora_pmon_win4prod

>Fri Jan 2613:48:01 2001

>*** SESSION ID:(1.1) 2001.01.26.13.48.01.000

>PMON unable to acquire latch 80001fec modify parameter values

>possible holder pid = 28ospid=24678

>Fri Jan 26 13:48:01 2001

>

>

>

Received on Mon Jan 29 2001 - 14:53:12 CST