ORA-600 [Kglhfr-bad-free] When Running UTLRP.SQL (Doc ID 1605326.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Each time utlrp.sql is executed, it raises an ORA-600 [kglhfr-bad-free] which is reported in the alert log like:

...
2013-10-13 04:18:00.778000 -07:00
SERVER COMPONENT id=UTLRP_BGN: timestamp=2013-10-13 04:18:00
2013-10-13 04:18:05.551000 -07:00
Errors in file /apps/oracle/diag/rdbms/live/LIVE/trace/LIVE_ora_22444.trc  (incident=8153):
ORA-00600: internal error code, arguments: [kglhfr-bad-free], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /apps/oracle/diag/rdbms/live/LIVE/incident/incdir_8153/LIVE_ora_22444_i8153.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2013-10-13 04:18:18.012000 -07:00
Dumping diagnostic data in directory=[cdmp_20131013041818], requested by (instance=1, osid=22444), summary=[incident=8153].
2013-10-13 04:18:23.530000 -07:00
SERVER COMPONENT id=UTLRP_END: timestamp=2013-10-13 04:18:23
2013-10-13 04:18:33.593000 -07:00
Sweep [inc][8153]: completed
Sweep [inc2][8153]: completed
...

 
The trace file shows next characteristics:

Dump continued from file: /apps/oracle/diag/rdbms/live/LIVE/trace/LIVE_ora_22444.trc
ORA-00600: internal error code, arguments: [kglhfr-bad-free], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 8153 (ORA 600 [kglhfr-bad-free]) ========
----- Beginning of Customized Incident Dump(s) -----

LibraryHandle:  Address=0x307a52328 Hash=82696b7c LockMode=S PinMode=S LoadLockMode=X Status=VALD
 ObjectName:  Name=PUBLIC.XXAR_PHONES_T@INTFTOLLIM.WORLD     <<< DBlink is being used
   FullHashValue=fb78ce5a28aa5d5cad1cac0282696b7c Namespace=TABLE/PROCEDURE(01) Type=SYNONYM(05) Identifier=0 OwnerIdn=2147483644
 Statistics:  InvalidationCount=0 ExecutionCount=0 LoadCount=3 ActiveLocks=1 TotalLockCount=3 TotalPinCount=3
 Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=0 BucketInUse=5 HandleInUse=5 HandleReferenceCount=0
 Concurrency:  DependencyMutex=0x307a523d8(0, 8, 0, 0) Mutex=0x307a52458(1597, 115, 0, 6)
 Flags=REM/PIN/TIM/[00022801]    <<<  Remote access
 WaitersLists:  
   Lock=0x307a523b8[0x307a523b8,0x307a523b8]
   Pin=0x307a52398[0x307a52398,0x307a52398]
   LoadLock=0x307a52410[0x307a52410,0x307a52410]
 Timestamp:  Current=09-15-2004 18:27:08
 HandleReference:  Address=0x307a524e8 Handle=(nil) Flags=[00]
 LibraryObject:  Address=0x311ed50b0 HeapMask=0000-0000-0000-0000 Flags=EXS/LOC[0004] Flags2=LOD[0001] PublicFlags=[0000]
   DataBlocks:  
     Block:  #='0' name=KGLH0^82696b7c pins=0 Change=NONE  
       Heap=0x1f58b4c40 Pointer=0x311ed5150 Extent=0x311ed5030 Flags=I/-/P/A/-/-
       FreedLocation=0 Alloc=1.179688 Size=3.976562 LoadTime=4882247990
     Block:  #='2' name=PLDIA^82696b7c pins=1 Change=NONE  
       Heap=0x311ed54a8 Pointer=0x30f0affa0 Extent=0x30f0aff20 Flags=I/-/P/A/-/-
       FreedLocation=0 Alloc=11.671875 Size=11.929688 LoadTime=0 ----- End of Customized Incident Dump(s) -----

*** 2013-10-13 04:18:05.749
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)


----- SQL Statement (None) -----
Current SQL information unavailable - no SQL text.
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x347e38500      1347  package body SYS.DBMS_UTILITY
0x341d35a08         1  anonymous block
0x341dd2d10       380  package body SYS.UTL_RECOMP
0x341dd2d10       524  package body SYS.UTL_RECOMP
0x341dd2d10       772  package body SYS.UTL_RECOMP
0x347d798f8         4  anonymous block

----- Call Stack Trace -----

    skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
       <- ksfdmp <- dbgexPhaseII <- dbgexExplicitEndInc <- dbgeEndDDEInvocationImpl <- dbgeEndDDEInvocation
        <- kglhfr <- kqlrld <- kqlrldcu <- kqlrldop <- kqllod
         <- kglobld <- kglobpn <- kglpim <- kglpin <- kglgob
          <- qcdlgbo <- qcdlgob <- qcsfgob <- qcsprfro <- qcsprfro_tree
           <- qcsprfro_tree <- qcspafq <- qcspqbDescendents <- qcspqb <- qcsdrv
            <- qcitrans <- qcisem <- ph2csql_analyze <- ph2stm <- ph2sms
             <- ph2blo <- ph2obl <- ph2sbo <- ph2qcb <- ph2dcl
              <- ph2itm <- ph2its <- ph2blo <- ph2obl <- ph2sbo
               <- ph2itm <- ph2its <- ph2blo <- ph2obl <- ph2uni
                <- ph2dr2 <- ph2drv <- phpsem <- phpcmp <- pcicmp0
                 <- kkxcmp0 <- rpiswu2 <- kkxcmp <- kkpalt <- opiexe
                  <- opiosq0 <- opiosq <- opiodr <- rpidrus <- skgmstack
                   <- rpiswu2 <- rpidrv <- rpisplu <- kqlvld <- kglgob
                    <- psd_validate <- pevm_icd_call_common <- pfrinstr_ICAL <- pfrrun_no_tool <- pfrrun
                     <- plsql_run <- peicnt <- kkxexe <- opiexe <- opipls
                      <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- rpidrv
                       <- psddr0 <- psdnal <- pevm_EXIM <- pfrinstr_EXIM <- pfrrun_no_tool
                        <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe
                         <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
                          <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain
                           <- main

 
The dbupgdiag.sql script as provided via
<Note 556610.1> - Script to collect DB Upgrade/Migrate Diagnostic Information

shows

======================================================
Count of Invalids by Schema
======================================================

OWNER        OBJECT_TYPE                                COUNT(*)
------------ ---------------------------------------- ----------
...
INTF_MGR     MATERIALIZED VIEW                                 1
...

Changes

The database was initially created as 8.1.7 and then via version 10.2.0.5 finally upgraded to 11.2.0.3.
Above history was shown in the results of the dbupgdiag.sql script as provided via <Note 556610.1>

The remote database, accessed at the time of the error, was confirmed to be still Oracle8i Enterprise Edition Release 8.1.7.4.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms