Re: Waited too long for library cache load lock

Thanks very much for your offer. You should see the file coming through soon.

Allan

On 6/13/07, Shamsudeen, Riyaj <RS2273_at_att.com> wrote:
>
> Allan
>
> Can you please send me the trace file ? Hopefully, it will
> come through. If not zip the file, rename it to .txt and send it please.
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Allan Nelson
> *Sent:* Wednesday, June 13, 2007 10:17 AM
> *To:* oracle-l
> *Subject:* Waited too long for library cache load lock
>
>
>
> I have been getting these errors for the last 2 days. In each case the
> "freeze" the database so that no new users can log on and existing
> connections cannot execute sql. The database version is 9.2.0.8 and the
> platform is HP-UX 11.11. Each dump file has text that looks like this:
>
> Dump file
> /d20/oracle/product/mbasdb/9.2.0/admin/mbas_mihp2/udump/mbas_ora_18508
> .trc
> Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.8.0 - Production
> ORACLE_HOME = /d20/oracle/product/mbasdb/9.2.0
> System name: HP-UX
> Node name: mihp2
> Release: B.11.11
> Version: U
> Machine: 9000/800
> Instance name: mbas
> Redo thread mounted by this instance: 1
> Oracle process number: 504
> Unix process pid: 18508, image: oracle_at_mihp2 (TNS V1-V3)
>
> *** 2007-06-12 16:11:27.634
> *** SESSION ID:(620.60298) 2007-06-12 16:11:27.633
> LIBRARY OBJECT HANDLE: handle=c00000009b43e750
> name=APPS.LA_ENHNCMTMGR_PKG
> hash=ad9ae384 timestamp=09-16-2006 20:10:16
> namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
> kkkk-dddd-llll=0000-0000-0000 lock=N pin=S latch#=1
> lwt=c00000009b43e780[c00000009b43e780,c00000009b43e780]
> ltm=c00000009b43e790[c00
> 000009b43e790,c00000009b43e790]
> pwt=c00000009b43e7b0[c00000009b43e7b0,c00000009b43e7b0]
> ptm=c00000009b43e840[c00
> 000009b43e840,c00000009b43e840]
> ref=c00000009b43e760[c00000009b43e760, c00000009b43e760]
> lnd=c00000009b43e858[c0
> 0000009b43e858,c00000009b43e858]
> LIBRARY OBJECT: object=c00000000da25860
> LOAD LOCK OWNERS:
> lock process mode mask
> -------- -------- ---- ------
> c0000000d4011878 c00000008255b2a0 X 0011
> LOAD LOCK WAITERS:
> lock process mode mask
> -------- -------- ---- ------
> c000000093506818 c0000000825a91a0 X 0011
> c000000093506350 c00000008254ebc0 X 0011
> c000000087e15d98 c00000008256f520 X 0011
> c0000000d400f950 c0000000825c4500 X 0011
> c000000093506c08 c0000000825495c0 X 0011
> c0000000d4011bd8 c000000082573b00 X 0011
> c0000000d4011a70 c000000082545aa0 X 0011
> c000000087e16608 c000000082578640 X 0011
> c000000087e162a8 c0000000825b5320 X 0011
> mbas_ora_18508.trc (0%)
>
> Anyway to interpret this stuff without filing an SR?
>
> Allan
>

--
http://www.freelists.org/webpage/oracle-l