Home » RDBMS Server » Server Administration » ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], [] (Oracle 10.2.0.3.0, Win Server 2003 Enterprise SP2)
icon9.gif  ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], [] [message #524952] Tue, 27 September 2011 16:06 Go to next message
wiler
Messages: 2
Registered: September 2011
Junior Member
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
_opistp_real+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
_opimai_real+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!!
Re: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [] [message #524953 is a reply to message #524952] Tue, 27 September 2011 17:03 Go to previous messageGo to next message
BlackSwan
Messages: 22521
Registered: January 2009
Senior Member
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Re: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [] [message #524962 is a reply to message #524952] Wed, 28 September 2011 01:42 Go to previous messageGo to next message
John Watson
Messages: 4401
Registered: January 2010
Location: Global Village
Senior Member
When you raise a TAR, I think you'll be told to apply the latest patchset. I don't think Oracle will assist you with 10.2.0.3.
Re: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [] [message #524967 is a reply to message #524962] Wed, 28 September 2011 02:10 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes ! it was fixed in V 10.2.0.5 or greater.

Sriram
Re: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [] [message #525163 is a reply to message #524952] Thu, 29 September 2011 15:13 Go to previous message
wiler
Messages: 2
Registered: September 2011
Junior Member
Thanks for all replies!!! I'll call Oracle support.

Best Regards!
Previous Topic: recompile package lead to hang
Next Topic: Oracle Hints
Goto Forum:
  


Current Time: Tue Jul 29 12:02:26 CDT 2014

Total time taken to generate the page: 0.14933 seconds