Compile or Create Procedure Errors With ORA-600[17069] (Doc ID 314404.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.4 and later   [Release: 10.1 and later ]
Information in this document applies to any platform.
***Checked for relevance on 30-Jan-2012***

Symptoms

CREATE OR REPLACE PACKAGE BODY <owner.package_name>

--OR--                                                                                 

ALTER PACKAGE <owner.package_name> COMPILE BODY

errors with ORA-00600: internal error code, arguments: [17069], [0x39EDEF958], [], [], [], [], [], []

Top of the Call Stack Trace
----------------------------
ksedmp kgeriv kgesiv kgesic1 kglgob kgldpo0 kgldpo kgldon pkldon pkloud phnnrl_name_resolve_by_loading ...

The description of the ORA-600 [17069] is as follows:

DESCRIPTION:        
  Failed to pin a library cache object after 50 attempts.
ARGUMENTS:         
  Arg [a] Library Cache Object Handle.

Example: ORA-00600: internal error code, arguments: [17069], [0x39EDEF958]

Search the trace file for the handle: 39EDEF958 from [0x39EDEF958] which is the second argument.

You will find something like:

          SO: 39fdaeda0, type: 54, owner: 3a47144c0, flag: INIT/-/-/0x00
          LIBRARY OBJECT LOCK: lock=39fdaeda0 handle=39edef958 mode=S    <========handle (2nd argument)
          call pin=0 session pin=0 hpc=0000 hlc=0000
          htl=39fdaee10[3a18e71f8,3a18e71f8] htb=3a18e71f8
          user=3a57febc0 session=3a57febc0 count=1 flags=[0000] savepoint=6062
          LIBRARY OBJECT HANDLE: handle=39edef958                            <==========handle (2nd argument)
          name=OWNER.PROCEDURE_NAME@REMOTE_DATABASE_LINK        <==========object name

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