Oracle 11gR - 11.2.0.2 to 11.2.0.4 upgrade steps

* yum install oracle-rdbms-server-11gR2-preinstall

Download the ‘patch’ software

Currently, the Oracle Database 11.2.0.4 files are not available to download from the usual Oracle Technology Network (OTN) area, instead you have to log into My Oracle Support (MOS)and search for patch number ‘13390677’. It’s probably worth mentioning at this point, that the ‘patch’ is a full install, despite the reference – so you don’t need to download Oracle Database 11.2.0.2 files in addition here

Once you’ve searched for the ‘patch’, select the link appropriate to your platform, in this case ‘Linux x86-64’. When you click download, there will be a total of 7 zip files available. For a standard installation, you only need zip parts 1 and 2…

• p13390677_112040_platform_1of7.zip (Oracle Database, including Oracle RAC components)
• p13390677_112040_platform_2of7.zip (Oracle Database, including Oracle RAC components)

Once you’ve downloaded the software, unzip both files to a staging area:

unzip /tmp/p13390677_112040_Linux-x86-64_1of7.zip -d /u01/app/oracle/software
unzip /tmp/p13390677_112040_Linux-x86-64_2of7.zip -d /u01/app/oracle/software

All of the contents from the above will be extracted to a “database” directory.
Start the installer

Open an X-Windows session to the server as the ‘oracle’ user.

Once you’ve met the requirements, and have unzipped the software, you can start the install:

Upgrade DB using DBUA

Update environment settings

Once the installation has finished, add the appropriate environment variables to your ‘oracle’ user profile.