I am testing my database which is already on 11gr1 working fine for application but after migration from 11gR1 to 11gR2 i am getting the below error while running application on a view:-
ORA-03113: end-of-file on communication channel
Process ID: 3280
Session ID: 35 Serial number: 11301
Above Error gets resolved after changing the order of underline tables and recreate But their is another error i am getting with same test case means select from a view
ORA-00600: internal error code, arguments: [kkqtSetOp.1], , , , , ,, , , , , 
This view is complex and nested. But working fine in 10g 11gR1. Please help...
Edited by: 832546 on Feb 8, 2011 1:48 AM
Welcome 2 oracle forums :)
Please refer MOS tech note:
*ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KKOCXJ : PJPCTX] When Executing a SQL [ID 566823.1]*
see Workaround section and make sure parameter optimizerpush_pred_cost_based* is set to false.
If this doesn't help, please see trace file for the specific session.
X A H E E R
Yes i have done below
1. alter system Set "_optimizer_order_by_elimination_enabled"=false;
2. alter session set "_complex_view_merging"=false;
3. alter system set "_optimizer_push_pred_cost_based"=false;
But it doesnot help and about tracing the session what i get...
Till now i have find this issue for three views, all of them on different tables.
example is below
if i use count(*) its working fine
from View1 f
from View2 i
But if i use
select f.ID, f.TYPE, f.RELEASE, f.PRIMARY_RELEASE, f.TEAM
from view1 f
select i.ID, i.TYPE, i.RELEASE, i.PRIMARY_RELEASE, i.TEAM
from view2 i
Then i get
ORA-00600: internal error code, arguments: [kkqtSetOp.1], , , , , , , , , , , 
Edited by: 832546 on Feb 8, 2011 3:06 AM
Above errors ORA-00600: internal error is resolved after i submit SR. They suggest to change parameter “_optimizer_join_factorization” to false.
But i am still facing with another error with view on oracle 11gr2
ORA-03113: end-of-file on communication channel...
Below is the work around i done for "ORA-03113: end-of-file on communication channel"
Join Condition for view is
If i run by just removing any one of above join condition is works fine but since i dont know business logic so i come up with solution below
1. create table t111 as select * from t1;
2. rename table t1 to abc
3. rename t111 to t1
Now it is starts working.
I don't know what had happen but i find workaround not solution.
If somebody suggest the solution and reason why this happening highly appreciated.
Edited by: 832546 on Feb 14, 2011 3:24 AM
Please check below notes which could be helpful to understand your issue:
Connections To Database Terminate With ORA-3113 end-of-file on communication channel [ID 1104673.1]
DIAGNOSING ORA-3113 ERRORS [ID 1020463.6]
ORA-03113 on Unix - What Information to Collect [ID 17613.1]
OERR: ORA 3113 "end-of-file on communication channel" [ID 19790.1]
Thanks for this suggestion ... setting the optimizer to false did help me. The problem I was facing was with my Views... every time I executed a view, I would experience the ORA-00600 error. I set the optimizer to false and restarted my database server. I experience this on Oracle 11.2 on Windows.
This seems to be a bug (8896955)
Queries may raise ora-600 [kkqtSetOp: 0] or ora-600 [kkqtSetOp.1]
or the query may fail to be fully optimized with table expansion, star transformation and join factorization all together when the query is eligible for all 3 transformations.