A new patchset for Oracle 11.2 has been released. This patchset is a full installation of the Oracle Database software. So you don’t need to install 220.127.116.11 before installing 18.104.22.168. You can read the complete list of new features of 22.214.171.124 from here:
I downloaded the patchset and wanted to upgrade my 2-node RAC database. It’s just a test database running on VirtualBox. Latest PSU and GI PSU (12419331 and 12419353) are already applied. Before I upgrade the database, I have also applied patch 12539000. Installer checks if this patch is applied. It seems it’s an important patch because it fixes a bug directly related with upgrade process (Bug 12539000 – 11203:ASM UPGRADE FAILED ON FIRST NODE WITH ORA-03113).
The patchset contains 7 zip files but we need only the first 3 zip files to upgrade our grid and database.
ls -lh *.zip
-rw-r--r-- 1 oracle oinstall 1.3G Sep 24 15:31 p10404530_112030_LINUX_1of7.zip
-rw-r--r-- 1 oracle oinstall 1.1G Sep 24 17:19 p10404530_112030_LINUX_2of7.zip
-rw-r--r-- 1 oracle oinstall 917M Sep 24 15:45 p10404530_112030_LINUX_3of7.zip
First I’ll upgrade the grid infrastructure, then I’ll update the DB. Before you upgrade your database, I recommend you to read “Master Note For Oracle Database Upgrades and Migrations” MOS ID 1152016.1.
As you know, starting from oracle 11gR2, the Oracle DB and grid upgrades are done via the “out of place upgrade”. So I switch to root user, create a new directory for the Oracle software:
chown oracle:oinstall /u02