How to perform out-of place manual upgrade from 11.2.0.1 to 11.2.0.2
Solution : 11.2.0.2 patch set software is a full release. 11.2.0.2 OUI does not update existing 11.2.0.1 ORACLE_HOME files and performs a new installation. There are two method Out-of-Place (Oracle's recommended approach)
In-Place
But here, we need to understand what exactly this method is: 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