This content has been marked as final. Show 5 replies
1 person found this helpful
Junr DBA wrote:ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Refresh MatView causing ORA ORA-00600: internal error code, arguments: , [0x1106559F0], , , error.
Database Version: 220.127.116.11, IBM AIX system
when run: dbms_mview.refresh('mart.mv_cust_header','?') , it fails with the above error.
Fixed few times by dropping and rebuldibng the MatView but it is not resolved. The issue is with production system.
Any help on this will be greatly appreciated.
Is it bug in 18.104.22.168 version?
Thanks for everyone's help!
As advised Oracle Support was able to find the root cause:
Just thought would share the information.
Solution from Oracle:
Patch resolves issues but is not available on 22.214.171.124 on this operating system. No new patches are being generated for 126.96.36.199. Patch is available on top of 188.8.131.52 and is included in PSU patchsets starting with 184.108.40.206 PSU 1.
Upgrade to 220.127.116.11 and then EITHER:
Apply the one-off patch 7330434.
Apply the latest patchset.
Note 752137.1 : ORA-00600  or ORA-00600  During Fast Refresh Of Materialized View
Note 7330434.8 : Bug 7330434 - Memory corruption / OERI:17147 from DBMS_MVIEW.REFRESH
I was also getting the same error while running below query
CREATE TABLE TEMP_TABLE AS select * from (select DATE,CIRCLE from SOMETABLE) PIVOT (MAX(CIRCLE) FOR CIRCLE IN ('xxx' AS "xxx" ,'YYY' AS "YYY" )) order by DATE desc
ORA-00600: internal error code, arguments: [qkngbAllocate.6], , , , , , , , , , , 
But in Enterprise edition this was running with warning and in Standard one edition it was giving error.
Late i try to set the NLS_SORT at session level and now its running proper in Standard Edition.
ALTER SESSION SET NLS_SORT=BINARY
Its works ......