Skip to Content

11g upgrade conflict

I had applied all the 11g patches according to the SAP Note and ran into what is called an online patch. From the Oracle® Database SAP® Bundle Patch 11.2.0.2.0 - 201012 readme: You cannot apply or roll back an online patch if the database is down.

So I do the dbua and get all done and go to apply the patch. opatch gives me this message:

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/oracle/BSN/112_64')

AH! So which is it?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 10, 2011 at 09:41 PM

    I ended up bringing down the database, removing the patch which was never installed, bringing up the database, then doing the online patching.

    Add a comment
    10|10000 characters needed characters exceeded

    • When you upgrade from Oracle 10g to Oracle 11g you can first install only the database software into the new filesystem or folder structure

      On unix /oracle/<SID>/11202 and a link 112_64 -> /oracle<SID>/11202 will be made

      After installing the software you can apply the bundle patch to this new Oracle installation (make sure your env variables are pointing to new Oracle installation)

      The online patches that are in that bundle patch have an offline counterpart in the same bundle patch so you can just apply the bundle patch using MOPatch and you do not need to apply any more patches afterwards when the database is online

      Before running DBUA to do the actual upgrade you then need to switch back to env variables of old Oracle installation and shut down SAP + Oracle 10g and the Oracle listener

      I do agree the SAP notes and documentation on installing patchsets etc are confusing.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.