Getting ORA-00600: internal error code, arguments: [qcsvsci1] in 11G
829597Jan 8 2011 — edited Jan 8 2011I am getting ORA-600 error while parsing sql in oracle 11g environments. In one of the environment the object used in sql is SYNONYM and in OTHER the same object is Materialized view. Following is the snippet from trace file that got generated. The error that we see in Frame [16] is the one which is causing problem we can ignore
Frame [48] as this error is because of frame 16. The best part is that when I fire this query through SQLPlus or in Toad I don't see this problem. Only when this query is fire through CRM I see this problem. Anyone has any Idea about this problem.
========== FRAME [16] (qcsvsci()+152 -> kgeasnmierr()) ==========
defined by frame pointers 0x7ffff3745460 and 0x7ffff3745430
CALL TYPE: call ERROR SIGNALED: yes COMPONENT: SQLParser_*
RDI 000000000B7C8EA0 RSI 00002B4AD8C36C30 RDX 00007FFFF3734CE0
RCX 0000000000000002 R8 0000000000000000 R9 00000000000003E9
RAX 00007FFFF3745400 RBX 00002B4AD9599BC0 RBP 00007FFFF3745460
R10 0000000100000000 R11 000000000B7C8EA0 R12 000000018890DBA8
R13 000000000B7C8EA0 R14 00002B4AD95A9440 R15 00002B4AD8C36C30
RSP 00007FFFF3745440 RIP 0000000002CED972
Dump of memory from 0x7ffff3745430 to 0x7ffff3745460
7FFFF3745430 F3745460 00007FFF 02CED977 00000000 [`Tt.....w.......]
7FFFF3745440 00000000 00000000 0000001B 00000000 [................]
7FFFF3745450 00000000 00000000 024E610E 00000000 [.........aN.....]
========== FRAME [48] (_start()+36 -> __libc_start_main()) ==========
defined by frame pointers 0x0 and 0x7ffff374e5c0
CALL TYPE: call ERROR SIGNALED: yes COMPONENT: (null)
RDI 0000000000A077D8 RSI 0000000000000002 RDX 00007FFFF374E5E8
RCX 0000000000000000 R8 000000000989C440 R9 0000000000000002
RAX 0000000000000000 RBX 0000000000000000 RBP 0000000000000000
R10 0000003C00000000 R11 0000000000000000 R12 0000000000A07700
R13 00007FFFF374E5E0 R14 0000000000000000 R15 0000000000000000
RSP 00007FFFF374E5D0 RIP 0000000000A07724
Thanks in Advance......