ORA-00600: internal error code, arguments: [kpobav-1]

I have Oracle 11.2.0.1 Enterprise Edition installed on my Solaris 10 server. Suddenly i observed "ORA-00600: internal error code, arguments: [kpobav-1]" in my alert log file.

It's clear ORA-00600 is an Oracle internal exception. So we need to go to https://support.oracle.com/. On further investigate at Oracle support. I found it a bug.

Bug 9703463  ORA-3137 [12333] or ORA-600 [kpobav-1] When Using Bind Peeking


This note gives a brief overview bug 9703463.
 The content was last updated on: 22-NOV-2010
 Click here for details of each of the sections below.

Affects:

Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 11.1 but BELOW 12.1
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

Frequent errors like ORA-3137 [12333] are raised. If the patch for bug:9243912
has been applied, you will see ORA-600 [kpobav-1] errors.

Rediscovery Notes:
  Optimizer bind peeking in use 
  The call stack includes "kpobav opibvg kxsPeekBinds kkscsCompareBinds"
  The KXSCFBPE flag is set, and the CTXFTCA flag is not set

  See note:1243836.1 for a detailed description of the diagnostics

Workaround:
  Disable bind peeking by setting:

  SQL> alter system set "_optim_peek_user_binds"=false;
 
HOOKS OERI:kpobav-1 ERROR:ORA-3137 PARAMETER:_optim_peek_user_binds STACKHAS:kxsPeekBinds LIKELYAFFECTS XAFFECTS_11.1.0.6 XAFFECTS_V11010006 AFFECTS=11.1.0.6 XAFFECTS_11.1.0.7 XAFFECTS_V11010007 AFFECTS=11.1.0.7 XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_CBO TAG_ERROR TAG_OERI CBO ERROR OERI FIXED_11.2.0.2 FIXED_12.1.0.0
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

Bug:9703463 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
 ----------------------------------------------------------------------------------------------------------------------------------------------------
I apply this workaround on server but unfortunately it doesn't work. It might be possible it works for your case. So my next move is to upgrade my Oracle database s/w from Oracle 11.2.0.1 Enterprise Edition to Oracle 11.2.0.2 Enterprise Edition.

When moving towards  Oracle 11.2.0.2 Enterprise Edition I observed some new changes introduced on it. Follow the link http://umeshsharmasblog.blogspot.com/2011/04/important-changes-to-oracle-database.html.

I install Oracle 11.2.0.2 Enterprise Edition according to the changes and recommendations. Next step is to upgrade database. After completing all these activities.

I observe alert log file then i don't find ORA-00600: internal error code, arguments: [kpobav-1] in my alert log file. The issue is resolved by Upgrading my Oracle s/w from Oracle 11.2.0.1 Enterprise Edition to Oracle 11.2.0.2 Enterprise Edition.

This post is about Specific ORA-0600 error, I would recommend to see General approach for troubleshooting  ORA-00600 and ORA-07445 Internal error which is applicable to all ORA-07445 Internal error  and ORA-00600 internal errors.

2 comments:

  1. I was wondering if you ever thought of changing the structure of your website?
    Its very well written; I love what youve got to say.
    But maybe you could a little more in the way of content so people could connect with it better.
    Youve got an awful lot of text for only having one or two images.
    Maybe you could space it out better?
    Also see my webpage > custom decals

    ReplyDelete
  2. Friend, Thanks for your suggestion. I will work on it.

    ReplyDelete