Thursday, May 20, 2010

10gR2 RAC ORA-00600 kgeade_is_0

Full Error on alert.log :
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []

Line from trace file :
select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :
w or (changescn_wrap = :w and changescn_base >= :b))

Having the initialization parameter PARALLEL_EXECUTION_MESSAGE_SIZE set to a different value on one or more instances in the cluster could cause an error when querying the gv$ views.

Solution

Make the parameter same across all RAC instances.

ALTER SYSTEM SET parallel_execution_message_size=2148 SCOPE=SPFILE SID='*';

Restart instance having this errors !!!

No comments:

Post a Comment