My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.




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


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

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