My Oracle Support Banner

Transaction Over DBLINK In RAC Fails With ORA-600 [18209] After Migration To RDBMS 19c (Doc ID 2757856.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.0.0.0 to 20.0.0.0.0 Beta [Release 19 to 20.0]
Information in this document applies to any platform.

Symptoms

Issue is usually noticed thru the database alert log that will show following errors for the RAC instance where the affected session is connected into:

2021-02-25T09:17:11.112824-06:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file <path>/<SID>_ora_36241842.trc (incident=28940):
ORA-00600: internal error code, arguments: [18209], [0x7000100987B39B8], [0x7000100724AD178], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file <path>/<SID>_ora_36241842.trc (incident=28941):
ORA-00600: internal error code, arguments: [18209], [0x7000100987B39B8], [0x7000100724AD178], [], [], [], [], [], [], [], [], []

 

While inspecting the incident trace file, you can identify the offended SQL, something similar to this:

----- Current SQL Statement for this session (sql_id=cykruvvwa2y9f) -----
SELECT ... FROM <TABLE>@<DBLINK> ... WHERE ...
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----

.
*** 2021-02-26T12:15:13.636964-06:00
[02]: dbgeExecuteForError [diag_dde]
[03]: dbgePostErrorKGE [diag_dde]
[04]: dbkePostKGE_kgsf [rdbms_dde]
[05]: kgeade []
[06]: kgeriv_int []
[07]: kgeriv []
[08]: kgesiv []
[09]: ksesic2 [KSE]
[10]: k2lbeg [Two_Phase]<-- Signaling
[11]: k2sibg [Two_Phase]
[12]: npibeg [NPI]
[13]: opixbeg [OPI]
[14]: opiexe [Time_Limit]
[15]: opipls [OPI]
[16]: opiodr [OPI]
[17]: rpidrus [RPI]
[18]: skgmstack []
[19]: rpidru [RPI]
[20]: rpiswu2 [RPI]
[21]: rpidrv [RPI]
[22]: psddr0 [PROGINT_PLSQL]
[23]: psdnal [PROGINT_PLSQL]
[24]: pevm_EXECC [PLSQL_Code_Execution]
[25]: pfrinstr_EXECC [PLSQL_Code_Execution]
[26]: pfrrun_no_tool [PLSQL_Code_Execution]
[27]: pfrrun [PLSQL_Code_Execution]
[28]: plsql_run [PLSQL_PSD_Standalones]
[29]: peicnt [PLSQL_Code_Execution]
[30]: kkxexe [PROGINT_PLSQL]
[31]: opiexe [Time_Limit]
[32]: kpoal8 [PROGINT_MISC]
[33]: opiodr [OPI]

 

 

Changes

 Upgraded RDBMS to 19c.

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
Changes
Cause
Solution
References


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