Tuesday, September 10, 2013

So has anyone done a successful in place upgrade?

My experience with and in non RAC dual home ASM ( ok grid infrastructure )/Database home showed that you were forced to do out of place upgrades.  I will document this at some point doing the upgrade with to same environment.
So you end up with 4 oracle homes the old grid/old database the new grid/new database then you had to clobber/remove the old ones ( well or leave a real mess ).

Now if you read the older 11.2 ReadMe's and install guides yes it did "say" that yes you could do an in place upgrade but ... well it was a lie and ... well it did not work.  So you were forced to do the out of place.

Looking at the latest ReadMe ( just a quick look ) is giving me a sense of deja vu ... this sure seems to read like the old stuff I remember that said yes you could do it.

Anyone have any real world testing done now with to provide any feedback here before I wade on in?

This is how it reads now ... for ...

In-Place Upgrade

This feature enables you to upgrade an existing installation of Oracle database to Oracle Database 11g Release 2 ( into the same Oracle home directory by replacing the existing database files. The patch set application requires more downtime and is not recommended. This upgrade type requires less disk space.

If you select In-place upgrade to upgrade Oracle database to the latest version, then you must:
  • Review "Optionally Performing an In-Place Upgrade (Into the Same Oracle Home)" in Oracle Database Upgrade Guide.
  • Take a complete backup of your Oracle home directory before you perform the upgrade.

Out-of-Place Upgrade

This feature enables you to install Oracle Database 11g Release 2 ( in a new, separate Oracle home directory. After the installation is complete, the data from the database in the old Oracle home directory is migrated to the database in the new Oracle home directory.

Out-of-place upgrade process is similar to Oracle database upgrade from one version to another and is the recommended type. The benefits of this upgrade type is that the patch set application requires much less downtime, and is safer when the patch set application must be aborted. This upgrade type requires more disk space to accommodate two Oracle home directories simultaneously.


  1. Any udpate on this, is it possible to get some step to upgrade database 11204 from 11203...


  2. This comment has been removed by the author.

  3. Oracle strongly recommends that you do not upgrade Oracle Database to release using the existing Oracle home. This procedure is provided only if for some reason you have no alternative but to use the existing Oracle home.

    DISCLAIMER: Read the entire set of instructions and understand what you are doing prior to starting this procedure. If you are not a seasoned DBA, I would not recommend you do this. Also, if you mess up, I am not responsible in any way. This is done at your own risk.

    With that being said, these are the instructions that I used when installing the patch to my installation. They are modified from the Oracle instructions I found online.

    Be advised that all of the databases using the current installation will need to be shutdown first. Also any other processes. i.e. the listener, dbconsole, agents, etc. you may have running in there.

    My EXAMPLE structure is like this:
    $ORACLE_BASE = /u01/app/oracle

    All instructions are based on this EXAMPLE layout.

    1. Obtain the Oracle Database release software from My Oracle Support at https://support.oracle.com/

    2. Backup your "$ORACLE_BASE/oraInventory" directory
    As root:
    tar cf oraInventory.tar oraInventory
    mv oraInventory oraInventory.11203
    tar xf oraInventory.tar

    3. Detach the $ORACLE_HOME with the following command:
    $ORACLE_HOME/oui/bin/runInstaller -detachHome ORACLE_HOME=$ORACLE_HOME

    4. Rename or move this $ORACLE_HOME software directory to a temporary name:
    AS root:
    cd $ORACLE_BASE/OraHome
    tar cf 11203.tar 11g -- this is a precautionary measure, never needed it.
    mv 11g 11203
    5. Start OUI and select release Software Only.

    6. For Location, select the same location as used for release
    i.e. $ORACLE_BASE/OraHome/11g

    7. After the installation completes, restore the configuration data for the old Oracle home. Restore the backed up configuration data files (from the old ORACLE_HOME to the new ORACLE_HOME)
    Restore them however you like, these are just my examples.
    cp -p $ORACLE_BASE/OraHome/11203/dbs $ORACLE_HOME/dbs
    cp -p $ORACLE_BASE/OraHome/11203/network/admin/* $ORACLE_HOME/network/admin
    cp -pr $ORACLE_BASE/OraHome/11203/hostname_dbname $ORACLE_HOME
    cp -pr $ORACLE_BASE/OraHome/11203/owb/bin/admin/* $ORACLE_HOME/owb/bin/admin
    cp -pr $ORACLE_BASE/OraHome/11203/oc4j/j2ee/OC4J_DBConsole_hostname_dbname $ORACLE_HOME/oc4j/j2ee/
    Specify the actual name for hostname_dbname where hostname is the actual hostname and dbname is the actual database name.

    8. Run DBUA from $ORACLE_HOME/bin directory and select the database instance to perform the upgrade to

    If things Go South:
    As root:
    mv oraInventory.11203 oraInventory
    cd $ORACLE_BASE/OraHome
    mv 11203 11g

    My apologies for the layout, I couldn't seem to get the format to look the way it does in my word document.

    Good luck!

  4. Thanks Larry ... a great starting place. At some point I will test it out and document it when you are running ASM which gets even more complicated ... two separate different oracle homes for both grid infrastructure and the regular oracle home environment.

  5. Larry and John, Thank you for the information... A great help!