Errors: ORA-600[kcbrls_2] ORA-600[kcbgcur_1] ORA-600 in The Alert Log
Last updated on OCTOBER 25, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 22.214.171.124 - Release: 10.2 to 11.2
Information in this document applies to any platform.
While these errors can all point to an issue in the database buffer cache, you may have tried to flush the buffer cache but the errors return.
SQL> alter system flush buffer_cache;
When analyzing/validating the affected table(s), you find an error (e.g. ORA-1498 or ORA-1499) reported during the analyze command indicating corruption.
SQL> analyze table <owner>.<table_name> validate structure cascade;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms