ORA-7445 [qksolWriteXML] When Running SQLT (SQLTXPLAIN) To Create A Testcase (Doc ID 1679714.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Trying to build a test case with SQLT (SQLTXPLAIN), this fails with error ORA-7445 [qksolWriteXML]

Alert log reports the ORA-7445 like:

...
Wed Apr 23 15:32:48 2014
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x59C902E, qksolWriteXML()+314] [flags: 0x0, count: 1]
Wed Apr 23 15:32:48 2014
Thread 1 cannot allocate new log, sequence 141420
Checkpoint not complete
  Current log# 1 seq# 141419 mem# 0: +ASMDG1/dbopumb5/onlinelog/group_1.259.797330949
Errors in file /DBA/oracle/diag/rdbms/dbopumb5/DBOPUMB5/trace/DBOPUMB5_ora_20106_sqlt_s31351_tcb_.trc  (incident=103633):
ORA-07445: Exception aufgetreten: CORE Dump [qksolWriteXML()+314] [SIGSEGV] [ADDR:0x4] [PC:0x59C902E] [Address not mapped to object] []
Incident details in: /DBA/oracle/diag/rdbms/dbopumb5/DBOPUMB5/incident/incdir_103633/DBOPUMB5_ora_20106_i103633.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thread 1 advanced to log sequence 141420 (LGWR switch)
  Current log# 2 seq# 141420 mem# 0: +ASMDG1/dbopumb5/onlinelog/group_2.258.797330987
Wed Apr 23 15:33:00 2014
Errors in file /DBA/oracle/diag/rdbms/dbopumb5/DBOPUMB5/incident/incdir_103633/DBOPUMB5_ora_20106_i103633.trc:


The trace file shows a current sql, PL/SQL stack and call stack like:

----- Current SQL Statement for this session (sql_id=d868spfyadpth) -----
BEGIN SYS.DBMS_SQLDIAG.EXPORT_SQL_TESTCASE ( directory     => :directory, sql_id        => :sql_id, exportData    => FALSE, exportPkgbody => TRUE, timeLimit     => :timeLimit, testcase_name => :testcase_name, testcase      => :testcase ); END;

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x957a941a0       145  package body SYS.DBMS_SQLTUNE_INTERNAL
0x957a941a0     12085  package body SYS.DBMS_SQLTUNE_INTERNAL
0x94ea84928      2749  package body SYS.DBMS_SQLTCB_INTERNAL
0x94ea84928      3169  package body SYS.DBMS_SQLTCB_INTERNAL
0x94fb6b068       495  package body SYS.DBMS_SQLDIAG
0x94474c388         1  anonymous block
0x9447fcc98      1161  package body SQLTXPLAIN.SQLT$I
0x9447fcc98      1785  package body SQLTXPLAIN.SQLT$I
0x9447fcc98      2119  package body SQLTXPLAIN.SQLT$I
0x93ddd50c0         1  anonymous block

----- Call Stack Trace -----

... qksolWriteXML kestsProcessSql kestsProcessSqlCallout spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opipls ...

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