ORA-600 [ksmcat: no current call heap] Error On Remote Gateway Query (Doc ID 1385437.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When querying a remote table via Oracle Gateways an ORA-600 [ksmcat: no current call heap] error may be encountered, possibly followed by ORA-600 [qksxaDumpXml:1]  error.  The call stack for the error will resemble the following:


... ksmcat kqlnrc kglgpr kgiina kgiinp peiinspbn kkxpispbn kgmexec evapls evaopnc rpiswu2 evaopn2 qerocnClose qerocCloseReal kxsffir kxsFreeWorkArea kxsFreeExecutionHeap kksParseCursor opiosq0 kpooprx kpoal8 opiodr ...

Additionally, when trying to insert a value into a table extracted from a remote table via Heterogenous Services, such as:

insert into scott.my_tables select TABLE_NAME TAB_NAME_S,
                                   COLUMN_NAME COL_NAME_S,
                                   upper('T_' || TABLE_NAME) TAB_NAME_B,
                                   upper(COLUMN_NAME) COL_NAME_B,
                                   data_type
                              from ALL_TAB_COLUMNS@remotedb where rownum = 1;

this errors with:


ORA-02055: distributed update operation failed; rollback required
ORA-02047: cannot join the distributed transaction in progress

Inserting directly into the table works though, as does executing the remote database SELECT query.

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