Shulou(Shulou.com)06/01 Report--

Problem description:

In the morning, a set of RAC instances frequently alarms ORA-00600: internal error code. Parameters: [qosdDirRead: dircnt mismatch], [809], [808]. After MOS query, we only found that bug exists in 12.1, but it has been fixed in 12.2.

Version of the database: 12.2.0.1

Server OS version: redhat 7.3

Process:

But can only submit SR, through the instructions of SR operation, the problem is solved. The following is the operation procedure

SQL > col dir_own# for 9999999999999999SQL > with aa as (select count (*) aa_cnt,dir_own# from opt_directive$ group by dir_own#) select * from aa,opt_directive_own$ bbwhere aa.dir_own# (+) = bb.dir_own#and dir_cntaa.aa_cnt AA_CNT DIR_OWN# DIR_OWN# DIR_CNT- 809 # # # 808SQL > col dir_own# for 99999999999999999999SQL > / AA_CNT DIR_OWN# DIR_OWN# DIR_CNT- 809 11352894694518622562 1135289469451822562 808SQL > Update opt_directive_own$ a set dir_cnt= (select count (*) from opt_directive$ b where a.dir_own#=b.dir_own#) where dir_own#=11352894694518622562 21 row updated.SQL > commit;Commit complete.SQL > with aa as (select count (*) aa_cnt,dir_own# from opt_directive$ group by dir_own#) select * from aa,opt_directive_own$ bbwhere aa.dir_own# (+) = bb.dir_own#and dir_cntaa.aa_cnt 2 34 no rows selectedSQL > SQL > with aa as (select count (*) aa_cnt,dir_own# from opt_directive$ group by dir_own#) select * from aa,opt_directive_own$ bbwhere aa.dir_own# (+) = bb.dir_own#and aa.dir_own#=11352894694518622562 2 3 4 AA_CNT DIR_OWN# DIR_OWN# DIR_CNT- 809 11352894694518622562 11352894694518622562 809

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.