Archived Database Upgrade Blog

Can I apply a BP on top of a PSU? Or vice versa? PART 2

Mike Dietrich
Master Product Manager

I thought I won't blog about this again:

But then a colleague of mine raised this simple question:

  • "I have a customer that would like to change from patching using PSU to patching using Bundle Patch. I am wondering what happens if my home has had several PSUs installed. Before applying a BP, would I need to rollback one by one all the PSUs that have been installed in reverse order (tedious) OR only the latest PSU (good)?"

Unfortunately the "simple" solution is hidden deep down in the documentation and not mentioned (as far as I could see) in any MOS Note.

The secret is the opatch option "all_subpatches".

And this is the solution

  • All PSU sub-patches have to be rolled back
  • Use the -all_subpatches option - it will roll them all back in the correct sequence.
    • Note: all overlay patches need rolled back 1st
  • Example:
    • % opatch rollback –id <current patch number> -all_subpatches
  • Documentation says:
    "This option is valid ONLY for composite patches. It allows the user to rollback all sub-patches of a composite series in one shot."

Hope this helps here and there ...


View Comments

Comments ( 2 )
Commenting is closed on this post.

  • guest Friday, January 20, 2017

    After migrate from several GI PSU to BP, datapath continue to rollback the latest GI PSU even if the previous is a BP.

    For example : Patch apply history
    - Apply GI PSU (July 2016)
    - Migrate to BP (July 2016)
    - Apply BP (Oct 2016)
    - Apply BP (Jan 2017)

    GI PSU (July 2016) is rollback during datapath for BP (Oct 2016) and BP (Jan 2017).

    The GI PSU is not full removed from database !


  • Mike Thursday, January 26, 2017

    Please please please ... log an SR with Oracle Support.
    I can't solve all the opatch and datapatch issues getting raised here - I'm always happy to learn about them but the only thing I can do is to file a bug if something comes into my radar.



Integrated Cloud Applications & Platform Services