ORA-00600: , : [kcbzwfcro_2]

 

ALTER TABLE os.test drop partition(PMAX)
Tue Sep 28 16:54:29 2021
Errors in file /u01/app/oracle/diag/rdbms/gsdb/gsdb1/trace/gsdb1_ora_457823.trc (incident=480577):
ORA-00600: , : [kcbzwfcro_2], [4294967295], [13], [0], [0], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/gsdb/gsdb1/incident/incdir_480577/gsdb1_ora_457823_i480577.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Sep 28 16:54:32 2021
Dumping diagnostic data in directory=[cdmp_20210928165432], requested by (instance=1, osid=457823), summary=[incident=480577].
Tue Sep 28 16:54:32 2021
Sweep [inc][480577]: completed
Sweep [inc2][480577]: completed
Errors in file /u01/app/oracle/diag/rdbms/gsdb/gsdb1/trace/gsdb1_ora_457823.trc:
ORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰORA-01013: ȡǰOR


***MOS文章
ORA-600:[kcbzwfcro_2] Reported in Alert.log (Doc ID 2085507.1)

Bug 19141040 - ORA-600 [KCBZWFCRO_2], [821514], [1], [32768]

SOLUTION
Verify if next workarounds can be used for your situation:

Flush buffer cache OR to restart the instance

This is because the error will continue whilst the stale buffer is in cache. We can try flushing the buffer cache to invalidate this.
If that doesn't help the instance will need to be restarted to clear the cache.

- OR -

Set "_gc_override_force_cr=false" to avoid this particular issue:
SQL> alter system set "_gc_override_force_cr"=false scope=both sid='*';

There should not be any noticeable performance impact.

If the issue still persists even after testing above options, then we possibly may need to file a new bug report.

 

 

 

 

 

posted @ 2021-09-28 17:24  钱若梨花落  阅读(224)  评论(0编辑  收藏  举报