After Installation of Patch 10625485, ORA-600 [kglpin-invalid-mode] raised while using DBMS_PIPE (Doc ID 1370321.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

- Alert log reports below internal error message

ORA-00600: internal error code, arguments : [kglpin-invalid-mode], [1], [0x3245EEA70], [0x32BB75378], [], [], [], [], [], [], [], []

- The related incident trace file shows that the error was raised while calling the DBMS_PIPE SYS package:

LibraryHandle:  Address=2bb75378 Hash=17499bc1 LockMode=S PinMode=0 LoadLockMode=0 Status=VALD
  ObjectName:  Name=<your_package_PIPE>
    FullHashValue=175493f95565c37f185d372c17499bc1 Namespace=PIPE(07)
Type=PIPE(18) Identifier=0 OwnerIdn=2147483644
  Statistics:  InvalidationCount=1 ExecutionCount=0 LoadCount=2
ActiveLocks=73 TotalLockCount=31077068 TotalPinCount=31083992
  Counters:  BrokenCount=2 RevocablePointer=2 KeepDependency=0 KeepHandle=0
BucketInUse=13601 HandleInUse=13601
  Concurrency:  DependencyMutex=2bb75428(0, 0, 0, 0) Mutex=2bb754a0(1347,
163642520, 74754, 6)
  Flags=RON/PIN/PN0/[10012001]
  WaitersLists: 
    Lock=2bb75408[2bb75408,2bb75408]
    Pin=2bb75418[2bb753e8,2bb753e8]
  Timestamp: 
  LibraryObject:  Address=2bb74358 HeapMask=0000-0001-0001
Flags=EXS/NRC[0400] Flags2=[0000] PublicFlags=[0000]
    DataBlocks: 
      Block:  #='0' name=KGLH0^17499bc1 pins=0 Change=NONE 
        Heap=2bb752c0 Pointer=2bb74498 Extent=2bb742d8 Flags=I/-/P/A/-/-
        FreedLocation=0 Alloc=1634.312500 Size=1732.000000 LoadTime=882474535
----- End of Customized Incident Dump(s) -----

*** 2011-07-12 20:02:09.497

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3,mask=0x0)
----- Current SQL Statement for this session (sql_id=61vxfg0pq5r3m) -----

.
.

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
000000032BB8D3F8       149  package body SYS.DBMS_PIPE

The incident trace file also shows the below call stack:

ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexExplicitEndInc dbgeEndDDEInvocationImpl
dbgeEndDDEInvocation kglpin kglgob kkxpputr kkxpput pevm_icd_call_common pfrinstr_ICAL pfrrun_no_tool
pfrrun plsql_run peicnt kkxexe opiexe opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real opimai OracleThreadStart

- Opatch lsinventory output shows that the patch 10625485 was applied.

Changes

You recently installed a patch that contains the fix for <Bug:10625485> - BUG 10625485 - ORA-600 [KSS_GET_TYPE: BAD CONTROL] FROM CUSTOM PACKAGE USING DBMS_PIPE

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