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:
Post a Comment