Bug 5155885 – cursor_sharing=similar

Running Oracle 10.2.0.2 on Solaris 9. Encountered Bug 5155885 where my database parameter cursor_sharing = similar. Found the errors below in my alert log file:

ORA-00600: internal error code, arguments: [kkslgbv0], [], [], [], [], [], [], []

A quick check on Metalink using “ora-600 kkslgbv0” as my search criteria and I find the answers in Metalink Notes 263158.1 and 382567.1. It is mentioned as a bug specific to Oracle 10.2.0.2 64-bit in Note 382567.1.

Resolution is:

1) Set cursor_sharing to exact
-or
2) Download and apply Patch 5155885 from Metalink.

For now, I settled on Option #1.

I can’t find any reference to Bug 5155885 being fixed in the 10.2.0.3 Patch Set (Metalink Note 401435.1).

According to Metalink Note 401436.1, the bug fix is included in the 10.2.0.4 Patch Set. Availability of the 10.2.0.4 Patch Set is expected in Q4 2007 according to recent information from Oracle Apps Technology blog and Laurent Schneider’s blog.

Update (27-Nov-2007)
It appears the 10.2.0.4 patch set has been pushed into 2008. More information in Laurent Schneider’s blog post.

About these ads

2 Responses to Bug 5155885 – cursor_sharing=similar

  1. link on 263158.1 is broken, it points to http://https://metalink.oracle.com/
    Regards
    Laurent

  2. mrothouse says:

    Thanks Laurent. One too many http. The link has now been fixed.

    Mike

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: