Home » RDBMS Server » Server Administration » ora-00600 error in alert log file (10.2.0.2 solaris 10 64 bit)
ora-00600 error in alert log file [message #317368] Wed, 30 April 2008 18:54 Go to next message
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.
Re: ora-00600 error in alert log file [message #317369 is a reply to message #317368] Wed, 30 April 2008 18:58 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
submit a Service Request to Oracle to report this bug.
Re: ora-00600 error in alert log file [message #317719 is a reply to message #317368] Fri, 02 May 2008 15:06 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: ora-00600 error in alert log file [message #317734 is a reply to message #317731] Fri, 02 May 2008 17:15 Go to previous messageGo to next message
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
Re: ora-00600 error in alert log file [message #317752 is a reply to message #317734] Sat, 03 May 2008 02:26 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Interesting link and article.
Thanks.

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


Current Time: Sun Dec 04 13:07:30 CST 2016

Total time taken to generate the page: 0.08891 seconds