Tuesday, August 02, 2011

Bad or Good Idea to solve ORA-00600: internal error code, arguments: [kgasra_2]

Not sure. it's bad idea or just good what I can solve the issue. On Oracle 11gR2 Grid Infrastructure (RAC), one node had CPU peak and database froze all nodes... checked in alert log file.
PMON failed to acquire latch, see PMON dump
Instance on this node restarted... everything seemed ok... but found ORA-00600: internal error code, arguments: [kgasra_2] on other nodes.
Errors in file /u01/app/oracle/diag/rdbms/db/db1/trace/db1_ora_8131.trc (incident=150521):
ORA-00600: internal error code, arguments: [kgasra_2], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/db/db1/incident/incdir_150521/db1_ora_8131_i150521.trc
I found out in trace file... found about SQL statement to get data and then I flushed buffer_cache all nodes.
SQL> ALTER SYSTEM FLUSH BUFFER_CACHE;

System altered.
It may be bad idea.. but it solved for me - -"

No comments: