Oracle notes: ORA-00600 [kksfbc-reparse-infinite-loop]

Users in Tianjin reported that the Oracle 10.2.0.4 RAC database generated a large number of trc files a few days ago, resulting in full support of the file system of oracle.

Check oracle alert logs on the corresponding host, there are a lot of ORA-00600 [kksfbc-reparse-infinite-loop] error logs, of course, along with a lot of trc files, each file is in the range of 50 MB to MB.

The metalink query has a corresponding bug description (ID: 752428.1), and briefly describes the cause of the bug triggering: synonym is referenced in the query view, the synonym is invalid because the data dictionary is not automatically updated because the source object is changed, causing view access errors. The corresponding bug id: Bug 7460291.

Metalink provides three solutions:

1. Upgrade oracle to 10.2.0.5 or 11.2.0.1 or later;

2. Use patch 7460291;

3. recompile the synonym that does not match d_timestamp in stime and sys. dependency $ in sys. obj $.

Log on to the system to find the wrong synonym:

Select OWNER, object_name, object_type

From dba_objects

Where object_id in (select a. obj #

From obj $ a, dependency $ B

Where a. obj # = B. d_obj #

And a. stime <> B. d_timestamp;

After checking, the synonym has been found to be valid. It should be because the software project team has re-compiled and the database has no error logs, and no further processing is required.