3 Replies Latest reply on Sep 28, 2011 7:42 AM by orawiss

    ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [

    890918
      Hello!

      After googling a lot, I really don't know what may have caused this problem when I'm shutting the DB, as It's a generic one.. Any suggestions?

      I'm running oracle on version 10.2.0.3.0 on Win Server 2003 Enterprise SP2.

      Part of the alert.log:

      Mon Sep 26 07:00:49 2011
      Starting background process EMN0
      EMN0 started with pid=27, OS id=5192
      Mon Sep 26 07:00:49 2011
      Shutting down instance: further logons disabled
      Mon Sep 26 07:00:50 2011
      Stopping background process QMNC
      Mon Sep 26 07:00:51 2011
      Stopping background process CJQ0
      Mon Sep 26 07:00:51 2011
      Stopping background process MMNL
      Mon Sep 26 07:00:52 2011
      Stopping background process MMON
      Mon Sep 26 07:00:53 2011
      Shutting down instance (immediate)
      License high water mark = 26
      Mon Sep 26 07:00:53 2011
      Stopping Job queue slave processes
      Mon Sep 26 07:00:53 2011
      Job queue slave processes stopped
      Waiting for shared server 'S000' to die
      Waiting for shared server 'S001' to die
      Waiting for shared server 'S002' to die
      Waiting for shared server 'S003' to die
      Mon Sep 26 07:01:04 2011
      Waiting for shared server 'S004' to die
      Mon Sep 26 07:01:23 2011
      All dispatchers and shared servers shutdown
      Mon Sep 26 07:01:23 2011
      alter database close normal
      Mon Sep 26 07:01:24 2011
      SMON: disabling tx recovery
      SMON: disabling cache recovery
      Mon Sep 26 07:01:24 2011
      Shutting down archive processes
      Archiving is disabled
      Archive process shutdown avoided: 0 active
      Thread 1 closed at log sequence 4300
      Successful close of redo thread 1
      Mon Sep 26 07:01:25 2011
      Completed: alter database close normal
      Mon Sep 26 07:01:25 2011
      alter database dismount
      Completed: alter database dismount
      ARCH: Archival disabled due to shutdown: 1089
      Shutting down archive processes
      Archiving is disabled
      Archive process shutdown avoided: 0 active
      ARCH: Archival disabled due to shutdown: 1089
      Shutting down archive processes
      Archiving is disabled
      Archive process shutdown avoided: 0 active
      System State dumped to trace file c:\oracle\product\admin\teste\udump\teste_ora_5000.trc
      Mon Sep 26 07:01:35 2011
      Errors in file c:\oracle\product\admin\teste\udump\teste_ora_5000.trc:
      *ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []*Dump file c:\oracle\product\admin\teste\bdump\alert_teste.log
      Mon Sep 26 07:09:49 2011
      ORACLE V10.2.0.3.0 - Production vsnsta=0
      vsnsql=14 vsnxtr=3
      Windows Server 2003 Version V5.2 Service Pack 2
      CPU : 2 - type 586, 2 Physical Cores
      Process Affinity : 0x00000000
      Memory (Avail/Total): Ph:1617M/2047M, Ph+PgF:3114M/3437M, VA:1938M/2047M
      Mon Sep 26 07:09:49 2011
      Starting ORACLE instance (normal)
      LICENSE_MAX_SESSION = 0




      Part of the file teste_ora_5000.trc:

      FREELIST CHUNK COUNT:3192 OBJECT SIZE:36
      LATCH:1 TOTAL SPACE: 114912
      FREELIST CHUNK COUNT:3190 OBJECT SIZE:36
      LATCH:2 TOTAL SPACE: 119016
      FREELIST CHUNK COUNT:3306 OBJECT SIZE:36
      BUCKET 10240:
      LIBRARY OBJECT HANDLE: handle=341a4de8 mtx=341A4E9C(0) cdp=0
      name=XDB.mime-mapping-type32_T
      hash=bfce5ac8b2228d568d457016dd2a2800 timestamp=11-19-2006 11:07:38
      namespace=TABL flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0132 hlc=0132
      lwt=341A4E44[341A4E44,341A4E44] ltm=341A4E4C[341A4E4C,341A4E4C]
      pwt=341A4E28[341A4E28,341A4E28] ptm=341A4E30[341A4E30,341A4E30]
      ref=341A4E64[341A4E64,341A4E64] lnd=341A4E70[341A4D18,32B481F8]
      LIBRARY OBJECT last freed from HPD addn data CBK
      BUCKET 10240 total object count=1
      BUCKET 40441:
      LIBRARY OBJECT HANDLE: handle=341a4c90 mtx=341A4D44(0) cdp=0
      name=XDB.mime-mapping34_COLL
      hash=4fd0f011144ed13e64cf519ed06c9df9 timestamp=11-19-2006 11:07:38
      namespace=TABL flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0004 hlc=0004
      lwt=341A4CEC[341A4CEC,341A4CEC] ltm=341A4CF4[341A4CF4,341A4CF4]
      pwt=341A4CD0[341A4CD0,341A4CD0] ptm=341A4CD8[341A4CD8,341A4CD8]
      ref=341A4D0C[341A4D0C,341A4D0C] lnd=341A4D18[32B481F8,341A4E70]
      LIBRARY OBJECT last freed from HPD addn data CBK
      BUCKET 40441 total object count=1
      ANONYMOUS LIST:
      LIST OF HANDLES WITH DEPENDENTS:
      LATCH=0 unpin_call_count=3072 hd_count=0 hd_unpinned_count=3284
      LATCH=1 unpin_call_count=3069 hd_count=2 hd_unpinned_count=3263
      341a4de8 -> 341a4c90
      LATCH=2 unpin_call_count=3085 hd_count=0 hd_unpinned_count=3503
      *** 2011-09-26 07:01:35.445
      ksedmp: internal or fatal error
      *ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []*Current SQL information unavailable - no session.
      ----- Call Stack Trace -----
      calling call entry argument values in hex
      location type point (? means dubious value)
      -------------------- -------- -------------------- ----------------------------
      ksedst+38           CALLrel  ksedst1+0 0 1
      ksedmp+898          CALLrel  ksedst+0 0
      ksfdmp+14           CALLrel  ksedmp+0 3
      _kgerinv+140         CALLreg  00000000             B158D30 3
      kgeasnmierr+19      CALLrel  kgerinv+0 B158D30 9CB1F64 607AAD14 0
      A19CDA4
      __VInfreq__kglshu+4 CALLrel _kgeasnmierr+0       B158D30 9CB1F64 607AAD14 0
      6 B158D30 4
      kqlnfy+641          CALLrel  kglshu+0 B158D30 0
      _kscnfy+1334         CALLreg  00000000             18 0
      ksmshu+273          CALLrel  kscnfy+0
      opistpreal+1038 CALLrel _ksmshu+0            0
      opistp+267          CALLrel  opistp_real+0 31 2 A19F68C
      _opiodr+1099         CALLreg  00000000             31 2 A19F68C
      _ttcpip+996          CALLreg  00000000             31 2 A19F68C 0
      _opitsk+1080         CALL???  00000000            
      opiino+1087         CALLrel  opitsk+0 0 0
      _opiodr+1099         CALLreg  00000000             3C 4 A19FC28
      opidrv+819          CALLrel  opiodr+0 3C 4 A19FC28 0
      sou2o+45            CALLrel  opidrv+0 3C 4 A19FC28
      opimaireal+112 CALLrel _sou2o+0             A19FC1C 3C 4 A19FC28
      opimai+92           CALLrel  opimai_real+0 2 A19FC54
      OracleThreadStart@  CALLrel  opimai+0
      4+726
      77E6482C CALLreg 00000000

      --------------------- Binary Stack Dump ---------------------

      ========== FRAME [1] (_ksedst+38 -> _ksedst1+0) ==========
      Dump of memory from 0x0A19CC78 to 0x0A19CC88
      A19CC70 0A19CC88 0040490B [.....I@.]
      A19CC80 00000000 00000001 [........]
      ========== FRAME [2] (_ksedmp+898 -> _ksedst+0) ==========
      Dump of memory from 0x0A19CC88 to 0x0A19CD48
      A19CC80 0A19CD48 00403303 [H....3@.]
      A19CC90 00000000 00000258 0A19CCA0 004238A0 [....X........8B.]
      A19CCA0 0A19CCA8 0043CB08 0B1591B8 60731B40 [......C.....@.s`]
      A19CCB0 0B1591BD 607AAD14 0000001B 00000000 [......z`........]


      Thanks in advance!!