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: and later   [Release: 10.1 and later ]
Information in this document applies to any platform.
***Checked for relevance on 30-Jan-2012***




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:

  Failed to pin a library cache object after 50 attempts.
  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


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