Dear All,
Today i got below alerts in 2 nd node of the rac
Sun Apr 13 09:03:35 2014
Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb2/trace/proddb2_ora_16814.trc (incident=811178):
ORA-00600: internal error code, arguments: [4464], [10], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/proddb/proddb2/incident/incdir_811178/proddb2_ora_16814_i811178.trc
Error 600 trapped in 2PC on transaction 14.23.7820203. Cleaning up.
Error stack returned to user:
ORA-00600: internal error code, arguments: [4464], [10], [1], [], [], [], [], [], [], [], [], []
Sun Apr 13 09:03:43 2014
Trace dumping is performing id=[cdmp_20140413090343]
Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb2/trace/proddb2_ora_16814.trc (incident=811179):
ORA-00600: internal error code, arguments: [4427], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4464], [10], [1], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/proddb/proddb2/incident/incdir_811179/proddb2_ora_16814_i811179.trc
Sun Apr 13 09:03:44 2014
Sweep [inc][811179]: completed
Sweep [inc][811178]: completed
Sweep [inc2][811178]: completed
Transaction recovery: lock conflict caught and ignored
Transaction recovery: lock conflict caught and ignored
Transaction recovery: lock conflict caught and ignored
Transaction recovery: lock conflict caught and ignored
1.what is the impact of this "Transaction recovery: lock conflict caught and ignored"
2. what about this "Transaction recovery: lock conflict caught and ignored", this is happening every log switch. is it related to the same bug?
i raise TAR with oracle they suggested.
This issue is related to Bug 9857702 ORA-600 [4464] / ORA-600 [4139] by ROLLBACK for a table with supplemental logging enabled
Solution
This bug is fixed in 11.2.0.2 and 12.1.
One off patches are also available on MOS under Patch 9857702.
P.S: There are no workarounds for this bug.