ORA-7445[QMRGSN], Ora-7445 [Qmtremoveref] While creating a new database (Doc ID 466502.1)

Last updated on MAY 13, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6.0
This problem can occur on any platform.

Symptoms

Alert.log shows the following error being generated while creating a new database

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0xA553A7D, qmtRemoveRef.()+87]
Errors in file /oracle/app/diag/rdbms/orcl1106/orcl1106/trace/orcl1106_ora_5613.trc (incident=11244):
ORA-07445: exception encountered: core dump [qmtRemoveRef.()+87] [SIGSEGV] [ADDR:0x8] [PC:0xA553A7D] [Address not mapped to object] []
Incident details in: /oracle/app/diag/rdbms/orcl1106/orcl1106/incident/incdir_11244/orcl1106_ora_5613_i11244.trc

Trace file shows that the Current SQL Statement is

CREATE OR REPLACE VIEW XDB.DOCUMENT_LINKS2 AS
SELECT resid source_id, any_path source_path,
(select resid
from resource_view
where equals_path(res, extractvalue(value(xl), '/*/@xlink:href', 'xmlns:xlink="http://www.test.org/1999/xlink"')) = 1) target_id,
extractvalue(value(xl), '/*/@xlink:href', 'xmlns:xlink="http://www.test.org/1999/xlink"') target_path
FROM
resource_view r,
table(xmlsequence(extract(res, '//*[@xlink:href]', 'xmlns:xlink="http://www.test.org/1999/xlink"'))) xl

Call stack trace is

skdstdst ksedst1 ksedst dbkedDefDump ksedmp ssexhd
qmtRemoveRef qmxtrCleanRewriteCt qmxtrxopn2 qmxtrxopn
qmxtrxopt qmxtrxopt qmxtrxopt qmxtrProcessFrodef
qmxtrProcessFrodefE qmxtrProcessFroClau qmxtrPreProcessFroClause
qmxtrxq lause qmxtrxop_rl_rwt qmxtrxop koksspend kkmdrvend

Reviewing the alert.log for previous errors shows numerous occurences of
ORA-00600: internal error code, arguments: [qmrgsn], [4278370576], [], [], [], []

The following parameter is also set as follows
db_securefile = "ALWAYS"

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