Thinking Out Loud

January 9, 2011

RMAN Bug 10306699 ORA-01008

Filed under: oracle — mdinh @ 5:12 pm

I just wanted to share a RMAN bug that I have encountered, just in case you get infected as well.

The OS is

> uname -an
SunOS  5.10 Generic_142909-17 sun4u sparc SUNW,SPARC-Enterprise

> rman

Recovery Manager: Release 11.2.0.2.0 - Production on Sat Jan 8 07:28:19 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target /

DBGSQL: TARGET> select count(*) into :dbstate from v$parameter where lower(name) = '_dummy_instance' and upper(value) = 'TRUE'
DBGSQL: sqlcode = 1008
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01008: not all variables bound

RMAN>

Bug 10306699: ORA-1008 DURNING RMAN BACKUP AFTER UPGRADING TO 11.2.0.2.0
https://supporthtml.oracle.com/ep/faces/secure/km/BugDisplay.jspx?id=10306699&bugProductSource=Oracle&h=Y

Suggested solution was to set cursor_sharing=EXACT

Also, it helps to flush the shared pool before connecting to target.

UPDATED:

As Gerrit has stated in the comment, there is a patch available.

Have not seen the issue since then.

Patch  9877980      : applied on Sun Aug 21 20:12:30 PDT 2011
Unique Patch ID:  13349636
   Created on 19 Jan 2011, 18:34:07 hrs PST8PDT
   Bugs fixed:
     9877980

 

Advertisements

10 Comments »

  1. thanks for sharing !!!

    Comment by bart — June 14, 2011 @ 11:52 am | Reply

  2. This bug is non-public, but there is a problem description:
    https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1280447.1

    There is a patch available.

    Comment by Gerrit Haase — October 14, 2011 @ 9:56 am | Reply

    • Thanks. Updated the post with feedback.

      Comment by mdinh — October 14, 2011 @ 12:12 pm | Reply

  3. it’s really great man.i just altered the parameter cursor_sharing from “force” to “exact”. now i am able to connect database through RMAN

    Comment by Bhabani — September 17, 2012 @ 1:57 pm | Reply

  4. Simply want to say your article is as astonishing.

    The clearness for your post is simply cool and i could think you are knowledgeable in this subject.
    Well with your permission let me to grab your RSS feed to stay updated
    with approaching post. Thank you 1,000,000 and please keep up the rewarding work.

    Comment by instagram — February 1, 2015 @ 11:53 am | Reply

  5. Hello there! Your webpage is loading lagging ,
    this went on just like a minute or so to reload,
    I really have no idea whether it’s just simply me
    or maybe your websites but twitter performed acceptable for
    me. Nevertheless, Let me thank you very much for placing fantastic blog post.
    Everybody who actually stumbled on this great site must have observed this article extremely useful.
    This one is excellent everything that you have concluded on this
    site and want to discover even more posts by you. Immediately after
    checking out the article, I have book-marked
    your webblog.

    Comment by dota 2 treasure key hack april 2014 — July 31, 2015 @ 12:08 am | Reply

  6. Heya I don’t know if it’s me or maybe your webblog but it is starting slow , I had
    to spend just like a couple of minutes to
    successfully load still , facebook operates absolutely for me.
    However , thanks for publishing lovely blog post.

    Most people who actually came to this site should have noticed this article honestly handy.
    This one is actually brilliant everything that you actually have implemented on this
    page and would like to see more content from you.
    After checking out the article, I’ve book-marked your web page.

    Comment by madden15-coins.com — August 30, 2015 @ 4:59 pm | Reply

  7. Hello Your web page starts up honestly slow for my situation,
    I not really know who’s issue is that but twitter and facebook starts up quite
    good. Anyways, I appreciate you for creating
    such type of brilliant blog post. Most people who actually stumbled on this great site should have noticed this informative
    article absolutely useful. I really hope I’ll be able to
    get more remarkable information and I should certainly compliment your site simply
    by telling you’ve done wonderful job. To get more knowledge from articles that you publish, I have book
    marked this web page.

    Comment by fifa15psp.com — September 9, 2015 @ 4:54 pm | Reply

  8. Hi Yahoo works good for my situation yet your website is starting steadily which took around a few minutes to successfully load, I don’t know whether or not it’s my own issue perhaps site problems.

    Well, I need to thank you so much for placing wonderful article.
    I’m sure it has already been incredibly useful to user
    who actually visit here. This one is without a doubt wonderful what you have
    implemented and wish to check out even more cool content by you.
    I ‘ve got you book marked to see blogs you publish.

    Comment by www.androidgta5.com — April 16, 2016 @ 12:43 pm | Reply

  9. Thanks for publishing this amazing post. I’m a long time
    viewers yet I’ve never been compelled to leave a remark. I signed up for your blog and also shared this on my Facebook
    Many thanks once more for your fantastic blog post!

    Comment by BestWebHostingSolution — October 6, 2016 @ 11:01 pm | Reply


RSS feed for comments on this post. TrackBack URI

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

Blog at WordPress.com.

%d bloggers like this: