Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized views.
The problem is identified as a “Could Not Reproduce” bug, but there is no patch because it cannot be recreated.
The error received during the operation is as follows.
1 2 3 4 5 6 7 |
ORA-12012: error on auto execute of job "ADURUOZ"."XXXXXXX" ORA-12008: error in materialized view refresh path ORA-00600: internal error code, arguments: [qcsprfro_tree:jrs present], [0x7F2B3E558138], [], [], [], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745 ORA-06512: at "ADURUOZ.YYYYY", line 40 |
In order to solve the problem, the relevant materialized view needs to be dropped and recreated. Then the error will not repeat.