– Complete Checklist for Manual Upgrades to 11gR2 – Either take a Cold or Hot backup of your source database (advisable to have cold backup).Īll my work was actually performed by following these links: – Install the latest available Critical Patch Update (if available). – Install the latest opatch available for your platform and database version (if available). – Install the latest available Patchset from Metalink (if available). – Download and install Oracle 11g Release 2 in a new Oracle Home. – Check the certification of Oracle 11gR2 with your Platform/Operating system before downloading and installing Oracle 11gR2. Basically, the first things to be done for this procedure are: The database was using ASM, but I should notify at the beginning that the configuration is for a Stand-Alone Server and not RAC. Recently, I was upgrading a database from 11.1.0.7 to the current 11.2.0.3 version. This way, reviewing the documentation and preparing the actual action plan can be less confusing and time consuming. Tired of that, I now usually try making my own manuals at the end of such actions. I eventually get lost in all the information gathered while reviewing such documentation.

However, I was never able to find a specific step-by-step guide simply because of the jumps from page to page. Well that all sounds nice, and we definitely need to look at the documentation no matter how often we do such upgrades, patch or do any other action.

My actual, and I believe the most common, approach is to first search through the official Oracle documentation to try finding step-by-step procedures for what we need. Occasionally during our regular DBA tasks, we get a client request or simply notice the need and actually suggest an upgrade of a particular RDBMS, GI, OMS, or any other Oracle product. Part I – Installing and patching the software

Oracle 11g database version 11.1.0.7