ORA-00600: [qkswcWithQbcRefdByMain4]

Hello all,
This days I found this in a client’s 12c Database when trying to create a Materialized View:

ORA-00600: internal error code, arguments: [qkswcWithQbcRefdByMain4]

A perfect match to MOS ORA-00600 [qkswcWithQbcRefdByMain4] when Create MV “WITH” clause (Doc ID 2232872.1).

The root cause is documented on BUG 22867413 – ORA-600 CALLING DBMS_ADVISOR.TUNE_MVIEW.
The given solution is to apply Patch 22867413.

After applying patch, issue solved. 🙂

# Alert Log:

Thu May 25 21:33:56 2017
Errors in file /u01/app/oracle/diag/rdbms/dwdb/DWDB/trace/DWDB_ora_35851.trc  (incident=575846):
ORA-00600: internal error code, arguments: [qkswcWithQbcRefdByMain4], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/dwdb/DWDB/incident/incdir_575846/DWDB_ora_35851_i575846.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu May 25 21:33:58 2017
Dumping diagnostic data in directory=[cdmp_20170525213358], requested by (instance=1, osid=35851), summary=[incident=575846].

# Trace File:

Trace file /u01/app/oracle/diag/rdbms/dwdb/DWDB/trace/DWDB_ora_35851.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1
System name:    Linux
Node name:      server01.grepora.com
Release:        2.6.32-504.12.2.el6.x86_64
Version:        #1 SMP Sun Feb 1 12:14:02 EST 2015
Machine:        x86_64
Instance name: DWDB
Redo thread mounted by this instance: 1
Oracle process number: 158
Unix process pid: 35851, image: oracle@server01.grepora.com


*** 2017-05-25 21:33:56.421
*** SESSION ID:(1564.59864) 2017-05-25 21:33:56.421
*** CLIENT ID:() 2017-05-25 21:33:56.421
*** SERVICE NAME:(SYS$USERS) 2017-05-25 21:33:56.421
*** MODULE NAME:(toad.exe) 2017-05-25 21:33:56.421
*** CLIENT DRIVER:() 2017-05-25 21:33:56.421
*** ACTION NAME:() 2017-05-25 21:33:56.421

Incident 575846 created, dump file: /u01/app/oracle/diag/rdbms/dwdb/DWDB/incident/incdir_575846/DWDB_ora_35851_i575846.trc
ORA-00600: internal error code, arguments: [qkswcWithQbcRefdByMain4], [], [], [], [], [], [], [], [], [], [], []

# Dump File:

Dump file /u01/app/oracle/diag/rdbms/dwdb/DWDB/incident/incdir_575846/DWDB_ora_35851_i575846.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1
System name:    Linux
Node name:      server01.grepora.com
Release:        2.6.32-504.12.2.el6.x86_64
Version:        #1 SMP Sun Feb 1 12:14:02 EST 2015
Machine:        x86_64
Instance name: DWDB
Redo thread mounted by this instance: 1
Oracle process number: 158
Unix process pid: 35851, image: oracle@server01.grepora.com


*** 2017-05-25 21:33:56.421
*** SESSION ID:(1564.59864) 2017-05-25 21:33:56.421
*** CLIENT ID:() 2017-05-25 21:33:56.421
*** SERVICE NAME:(SYS$USERS) 2017-05-25 21:33:56.421
*** MODULE NAME:(toad.exe) 2017-05-25 21:33:56.421
*** CLIENT DRIVER:() 2017-05-25 21:33:56.421
*** ACTION NAME:() 2017-05-25 21:33:56.421

[TOC00000]
Jump to table of contents
Dump continued from file: /u01/app/oracle/diag/rdbms/dwdb/DWDB/trace/DWDB_ora_35851.trc
[TOC00001]
ORA-00600: internal error code, arguments: [qkswcWithQbcRefdByMain4], [], [], [], [], [], [], [], [], [], [], []

[TOC00001-END]
[TOC00002]
========= Dump for incident 575846 (ORA 600 [qkswcWithQbcRefdByMain4]) ========
*** 2017-05-25 21:33:56.421
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=4b9g61sa1an98) -----
CREATE MATERIALIZED VIEW OWNER.MVIEW_TEST
BUILD IMMEDIATE
REFRESH COMPLETE
START WITH sysdate
NEXT (sysdate+1)
WITH PRIMARY KEY
AS
with table_qwerty AS (
SELECT a,b,c,d,e
  FROM owner.table alias.....

And this was the problematic MVIEW. 🙂

Cheers!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s