Skip to Content
avatar image
Former Member

Oracle upgrade from 11.2.0.2 To 11.2.0.3

Hi All,

We will be upgrading the oracle from 11.2.0.2 to 11.2.0.3. I have done upgrade from 9.2.0.7 to 10.2.0.2 But need to know is there any diffrence between the two.

Do we need to use DBUA to upgrade from 11.2.0.2 to 11.2.0.3 or there is any other process is 11g?

Request you to reply.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 22, 2012 at 05:42 AM

    Hi Deepak,

    Oracle 11.2.0.2 to 11.2.0.3 can be done by patchset installation.

    At some point, you have to use dbua for upgrading the database.

    You can either refer to the readme file in the patchset zip file or Oracle documentation.

    http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm

    Br,

    Venky

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22, 2012 at 06:29 AM

    You do not need to use DBUA to update Oracle from 11.2.0.2 and 11.2.0.3 . Its just a patchset installation for Oracle 11.2 .

    This is actually a binary upgrade of oracle . Your database dictionary is not going to change ,hence you do not need to run DBUA.

    Follow these notes to help yourself .

    1631931 Oracle 11.2.0: Patches / Patch collections for 11.2.0.3

    1431799 Oracle 11.2.0: Current Patch Set

    1656659 GI 11.2.0: Patches / Patch Collections for 11.2.0.3

    1524205 Oracle 11.2.0: Database Software Installation

    Add comment
    10|10000 characters needed characters exceeded

    • Hey Deepak,

      yes your procedure is correct (apply the current SBP to the new ORACLE_HOME after step 2).

      The script dbua.sap.sh (by SAP) is just a wrapper for dbua which runs some pre-/post scripts and dbua itself.

      Regards

      Stefan