Solutions for ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [1], [0]
ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [1], [0]
We got this error in Oracle 10g. A little about our environment. This is 10.2.0.3 and we are using Transparent Data Encryption (TDE). I found on metalink that there is a bug (see note Note:406958.1) with Complex View Merging and Transparent Data Encryption (TDE).
The fix was to set _complex_view_merging=false or upgrade to 11g. The problem with this approach is that Oracle is not able to efficiently rewrite queries using Complex View Merging and the upgrade to 11g will introduce some risks. Queries that should take seconds may now take minutes due to disabling Complex View Merging. I found a better work around. Do not set _complex_view_merging=false. If you did, set it back to true. Find the offending view that is causing the problem and build it with the /*+ no_merge */ hint.
For example:
CREATE OR REPLACE FORCE VIEW V_TEST_VIEW
AS
SELECT DISTINCT fi.provider_id as fi_id
, co.provider_id as co_id
, ag.provider_id as ag_id
Instead, do this:
CREATE OR REPLACE FORCE VIEW V_TEST_VIEW
AS
SELECT /*+ no_merge */ DISTINCT fi.provider_id as fi_id
, co.provider_id as co_id
, ag.provider_id as ag_id
And there you go. You still get Complex View Merging except on views that contain columns that are encrypted by TDE.
younus hussain said,
July 7, 2008 @ 5:42 am
HI,
this younus hussain , i as oracle dba i got the error says that ora-00600:internal error code,arguments:[keltnfy_IDmnity],[46],[1],[],[],[],[],[]. please tell em what is the solutions of it. thank you
anu said,
August 7, 2008 @ 2:55 am
HI,
While executing one mapping in OWB, an inetrnal error occured as follows.
ORA-00600: internal error code, arguments: [ktspfsall], [], [], [], [], [], [], []
Can someone help in this.Shall i know the reason why am getting the error. Am using oracle9i.
Thanks,
Anu
santosh said,
August 13, 2008 @ 2:58 am
it is because of deadlock and block corruption, find first, which block is corrupted
IGaveUpCrackForThis said,
August 13, 2008 @ 10:35 am
I am getting ERROR: ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0], [0], [0], [1], [1], [0] while working with Oracle 10.2.0.2 on Solaris 10 on a T2000 server. I have been through several forums but cannot find a fix that works for me. I have tried taking the database out of restricted mode and have tried “ALTER SYSTEM SET EVENT=’12099 trace name context forever, level 1′ SCOPE=SPFILE;” which was suggested by someone in HP. I cannot add the no_merge hint because the SQL being used is already stuffed inside .pyc files.
I have a string of 21 things WAITING:
SID SEQ# STATE
———- ———- ——————-
1073 1 WAITING
1079 2 WAITING
1084 6 WAITING
1086 2 WAITING
1088 2039 WAITING
… and so on
Thank you VERY much!!!
Sean (sean@riverturn.com)
Tom said,
September 8, 2008 @ 7:37 am
Sean,
There is a hidden parameter that you will find on metalink to turn sort view merging off (setting to false).
Tom said,
September 8, 2008 @ 7:38 am
Actually, just try this.
set _complex_view_merging=false