My Oracle Support Banner

ORA-600: [kponPurgeUnreachLoc-3] And ORA-600: [kghstack_alloc], [define handles] Errors From QMON Process (Doc ID 1447675.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

You are running an 11.2.0.2 RAC database and you see the repeated errors in the alertlog from the QMON slave processes (q00*).

ORA-00600: internal error code, arguments: [kghstack_alloc], [define handles], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kponPurgeUnreachLockponPurgeUnreachLoc-3], [600], [ORA-00600: internal error code, arguments: [kghstack_alloc], [define handles], [], [], [], [], [], [], [], [], [], []


From the trace file, it is seen that the SQL being executed is:

select location_name, max(r.reg_id) from reg$ r left outer join gv$subscr_registration_stats v on r.reg_id = v.reg_id where location_name like 'net8://(%' group by location_name having min(current_timestamp-nvl(last_ntfn_sent_time, reg_time)) > :1


The stack trace from the trace file will be similar to the following:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv <- kgeasnmierr <- kghstack_alloc <- kpoopq <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- upirtr <- kpurcs <- kpurserverparse <- kpureq <- kpuStmtPrep2New <- kpuStmtCachePrepare2 <- kpureq2 <- OCIStmtPrepare2 <- kponPurgeUnreachLoc <- kwqmnslv <- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- libc_start_main <- start



Alternatively, you may see error like below raised by an AQ process:

ORA-00600: internal error code, arguments: [733], [1988626064], [top uga heap], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kponPurgeUnreachLoc-3], [600], [ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []], [], [], [], [], [], [], [], [], []


The stack for the ORA-600 [733] is like:

ksmarfg <- kghgex <- kghfnd <- kghalo <- kghgex <- kghfnd <- kghalo <- kghgex <- kghfnd <- kghalo <- kghgex <- kghfnd <- kghalo <- kpuhhaloc <- kpughndlarr <- OCIKHandleAllocArra <- kpoopq <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- upirtr <- kpurcs <- kpurserverparse <- kpureq <- kpuStmtPrep2New <- kpuStmtCachePrepare <- kpureq2 <- OCIStmtPrepare2 <- kponPurgeUnreachLoc <- kwqmnslv <- ksvrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main <- libc_start_main <- start

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.