Oracle 11.2.0.2 In-Place & Out-of-Place Upgrade

We can perform database upgrade from 11.2.0.1 to 11.2.0.2 in 2 ways

1. In-Place
2. Out-of-Place (Oracle's recommended approach)

In prior releases, how it worked

DB Upgrade 8i to 10g (Out-Of-Place)

We install Oracle binaries for 10g at new location, then use DBUA or catupgrd.sql script to upgrade DB. This is Out-of-Place migration (i.e. created new oracle home, from inventory perspective).

DB Upgrade 10.2.0.1 to 10.2.0.4 (In-Place)

Here we won’t install 10.2.0.4 patchset in new home (Oracle won’t let us do that, as it is a patch), but select the existing home to upgrade. We also keep a backup of original 10.2.0.1, as we may have to fail back.

As 11.2.0.2 is not a patch and full install.  It does not allow us to install binaries in existing 11.2.0.1 home (i.e. In-Place). But as I mentioned above, we can perform both upgrades

Case of In-Place upgrade

It is mandatory to move/rename existing oracle home and then install new binaries in existing oracle home path (i.e. same physical location but new binaries). Then run the upgrade script. In case of failure, we can revert back to original home (provided we have backup of old 11.2.0.1 home).

Case of Out-of-Place upgrade

We need to install 11.2.0.2 in new home and run the upgrade script.

In both cases, we have to provision space for two oracle homes. In case of Out-of-Place upgrade it is mandatory. In case of In-Place migration it is good to have, but not mandatory.

Advertisements
This entry was posted in Oracle 11.2.0.x, Oracle 11g Enhancements, Oracle Database Upgrade and tagged . Bookmark the permalink.

5 Responses to Oracle 11.2.0.2 In-Place & Out-of-Place Upgrade

  1. karnash says:

    Hi,
    can you advise me “how do we migrate the Oracle Database from the older Oracle home to 11.2.0.2 OH for out-of-place upgrade. I have 11.2.0.1 and want to upgrade to 11.2.0.2 on RH.
    I have installed 11.2.0.2 software only to a new OH. Can you advise how do I now migrade the db to this new OH or how do I do the upgrade. Thanks

  2. karnash says:

    Hi Yogesh,
    do we set _datafile_write_errors_crash_instance to true or false ?

    • It’s up to you to decide “what should happen in case of write failure continue/crash”

      Refer Metalink Note – Bug 7691270 – Crash the DB in case of write errors (rather than just offline files) [ID 7691270.8]

  3. chintan says:

    thanks sir,its very useful me to do upgradation 10.2.0.4 to 11.2.0.2

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