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 MARCH 02, 2017

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

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