ORA-00600 [kkdlGetCkyName1] When Schema Synonym Is Used (Doc ID 2277515.1)

Last updated on AUGUST 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.6.0 to 12.1.0.2 [Release 8.0.6 to 12.1]
Information in this document applies to any platform.

Symptoms

ORA-00600: internal error code, arguments: [kkdlGetCkyName1]

During SELECT from a schema SYNONYM on 11g database or lower

select * from my_user.table

Call stack similar to :

[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]
[04]: kgeadse []
[05]: kgerinv_internal []
[06]: kgerinv []
[07]: kgeasnmierr []
[08]: kkdlGetCkyName []<-- Signaling
[09]: kkoiqb [SQL_Costing]
[10]: kkooqb [SQL_Costing]
[11]: kkoqbc [SQL_Costing]
[12]: apakkoqb [SQL_APA]
[13]: apaqbdDescendents [SQL_APA]
[14]: apaqbdList [SQL_APA]
[15]: apaqbd [SQL_APA]
[16]: apadrv [SQL_APA]
[17]: opitca []
[18]: kksLoadChild [cursor]
[19]: kxsGetRuntimeLock [cursor]
[20]: kksfbc [cursor]
[21]: kkspsc0 [cursor]
[22]: kksParseCursor [cursor]
[23]: opiosq0 []
[24]: kpooprx []
[25]: kpoal8 []
[26]: opiodr []
[27]: ttcpip []
[28]: opitsk []
[29]: opiino []
[30]: opiodr []
[31]: opidrv []
[32]: sou2o []
[33]: opimai_real []
[34]: ssthrdmain []
[35]: main []
[36]: __libc_start_main []

 

Changes

 _enable_schema_synonyms set to TRUE 

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