ORA-00600: internal error code, arguments: [kjbrref:pkey], [2630360], [481], [], []

I faced with that error on two node RAC on AIX system with ASM. One of our instance reboot itself and database alert.log mention below errors:

 ORA-00600: internal error code, arguments: [kjbrref:pkey], [2630360], [481], [1113572], [0], [], [], [], [], [], [], []
 Incident details in: lms3_3211996_i4178879.trc
 Fri Feb 17 21:10:14 2019
 Trace dumping is performing id=[cdmp_20120217211014]
 Fri Feb 17 21:10:17 2019
 Sweep [inc][4178879]: completed
 Sweep [inc2][4178879]: completed

We raised Sr and got that  explanation from Oracle:

It is a known issue,From 11.2, for DRM , we have an additional concept called gc read mostly concept in which if this gc read mostly lock is acquired by an instance which reads a block 50 times more than the other instance/(s)

The lock is acquired on the object’s block and if another instance calls the same block for 50 more times than the current instance which is acquiring the lock, the lock gets moved to the new instance This is called block affinity gc read mostly feature in 11.2 .Obviously, due to this lock, overheads and latencies are expected behavior and LMS getting stuck in DRM is a known issue when using this Disabling the gc read mostly locking will help you avoid many known issues like ORA-600 errors leading to instance crashes:-
Bug 12408350 – ORA-600 [kjbrasr:pkey] in RAC with read mostly locking (Doc ID 12408350.8)
So, in other words, please set the hidden parameter “_gc_read_mostly_locking”=FALSE scope=spfile for all the instances of the database and bounce the database instances for this parameter to take effect

Some additional metalink notes:
ORA-600 [kjbrasr:pkey] [ID 406803.1]
Instance Crashes with ORA-00600 [kjbrref:pkey] [ID 1106052.1]
Top 5 RAC Instance Crash Issues [ID 1375405.1]  << Issue 3


Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Connecting to %s

%d blogcu bunu beğendi: