OraFAQ Forum: Server Administration » ora-00600 error in alert log file

Home » RDBMS Server » Server Administration » ora-00600 error in alert log file (10.2.0.2 solaris 10 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-00600 error in alert log file [message #317368]

Wed, 30 April 2008 18:54

skumar.dba
Messages: 82
Registered: October 2007

Member

hai,

i am getting this error in the alert log file. i am not sure what was the problem. can any one help to to fix it.

ORA-00600: internal error code, arguments: [KGHLKREM1], [0x43DB845F8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x43DB845F8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x43DB845F8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x43DB845F8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x43DB845F8], [], [], [], [], [], []

why this problem comes. can any one give some idea to fix the problem.

Report message to a moderator

Re: ora-00600 error in alert log file [message #317369 is a reply to message #317368]

Wed, 30 April 2008 18:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

submit a Service Request to Oracle to report this bug.

Report message to a moderator

Re: ora-00600 error in alert log file [message #317719 is a reply to message #317368]

Fri, 02 May 2008 15:06

rlockard
Messages: 19
Registered: April 2008
Location: Baltimore, MD

Junior Member

This is an unpublished bug that leads to sga corruption. The work around is published in Metalink Note:389621.

You should check with oracle support on this and/or read the metalink note as the fix involves setting the _bloom_filter_enabled parameter in the init.ora file. Because this is an _ parameter there may be unintended consequences. For that reason, I'm not giving the complete answer. Please read the note and talk to support.

This bug will be fixed in 10.2.0.4 and 11.

-Rob

[Updated on: Fri, 02 May 2008 15:10]

Report message to a moderator

Re: ora-00600 error in alert log file [message #317731 is a reply to message #317719]

Fri, 02 May 2008 16:33

skumar.dba
Messages: 82
Registered: October 2007

Member

Rob,

thanks for responce. can you please tell me what is the use of this parameter.

_bloom_filter_enabled =false.

i am not able to get much information in the google.
Regards
kumar

Report message to a moderator

Re: ora-00600 error in alert log file [message #317734 is a reply to message #317731]

Fri, 02 May 2008 17:15

rlockard
Messages: 19
Registered: April 2008
Location: Baltimore, MD

Junior Member

I'm kind of busy. I don't have time to go into a lot of detail right now.

Be sure you read the note and/or talk to support before using this.

Here is a link to bloom filter.
http://en.wikipedia.org/wiki/Bloom_filter

-Rob

Report message to a moderator

Re: ora-00600 error in alert log file [message #317752 is a reply to message #317734]

Sat, 03 May 2008 02:26

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Interesting link and article.
Thanks.

Regards
Michel

Report message to a moderator

Previous Topic:	Importing datafiles from oracle 8 into oracle 10
Next Topic:	tablespace is 92% used.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 01:53:53 CST 2024