My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.