My Oracle Support Banner

SELECT from DBA_NETWORK_ACLS ORA-600 [qmxqtmChkXQAtomMapSQL:2] alt source and XDB SGA reset to NULL ORA-01422 for XML / XDB in 11.2.0.3 (Doc ID 1579564.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Trying to query ACLs.(SELECT * FROM dba_network_acls order by acl, host;)

errors out with      ORA-00600: internal error code, arguments: [qmxqtmChkXQAtomMapSQL:2], [], [], [], [], [], [], [], [], [], [], []

Similar to Doc ID 1108619.1 The associated trace file may include the following partial stack:

ksedst1 ksedst dbkedDefDump ksedmp qm_init_uga qmxtcInitGlobals qmxtrCheckRewrite qmxtrxopn2 qmxtrxopt qmxtrxopt qmxqrwRewriteXMLQry qmxqrsRewriteXMLQry _h qmxqrsRewriteXMLQry qmxtrxopn2 qmxtrxopt qmxtrxopt qmxtrxopt qmxtrxopt qmxtrxopt qmxtrxlog qmxtrxq qmxtrxq qmxtrxop_rl_rwt qmxtrxop koksspend kkmdrvend kkmdrv opiSem opiDeferredSem opitca


The Alert log also has the following errors continuously ...


...
...
 

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


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.