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 10.1.0.4 and laterOracle 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.
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
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
| Symptoms |
| Cause |
| Solution |