1.) Patchset :
2.) Patchset Updates :
How to get Oracle Patches :
ii.) Oracle Database
Most of the database patching activities involve, in the following sequence
- Update "Oracle Database Software" using './runInstaller' or 'opatch apply' known as "Installation" Tasks.
- Update "Oracle Database" (catupgrd.sql or catbundle.sql ...etc) to make it compatible for newly patched "Oracle database Software" known as "Post Installation" tasks.
- Software update and then
- Database update.
- Applying an interim patch.
- Rolling back the application of an interim patch.
- Detecting conflict when applying an interim patch after previous interim patches have been applied. It also suggests the best options to resolve a conflict .
- Reporting on installed products and interim patch.
The patch metadata exist in the inventory.xml and action.xml files exists under <stage_area>/<patch_id>/etc/config/
Inventory .xml file have the following information :
- Bug number
- Unique Patch ID
- Date of patch year
- Required and Optional components
- OS platforms ID
- Instance shutdown is required or not
- Patch can be applied online or not
Actions .xml file have the following information .
- File name and it location to which it need to be copied
- Components need to be re-linked
- Information about the optional and required components
Here are steps for applying patches on linux Platform :
1.) Download the required Patches from My Oracle Support (MOS) :
- Login to metalink.
- Click "Patches & Updates" link on top menu.
- On the patch search section enter patch number and select the platform of your database.
- Click search.
- On the search results page, download the zip file.
2.) Opatch version :
Oracle recommends that we use the latest released OPatch , which is available for download from My Oracle Support . OPatch is compatible only with the version of Oracle Universal Installer that is installed in the Oracle home. We can get all Opatch command by using Opatch help command .
3.) Stop all the Oracle services :
Before applying Optach , make sure all the Oracle services are down . If they are not down then stop/down the oracle related Services . Let's crosscheck it
$ ps -ef |grep pmon
oracle 15871 15484 0 11:20 pts/2 00:00:00 grep pmon
$ ps -ef |grep tns
oracle 15874 15484 0 11:20 pts/2 00:00:00 grep tns
4.) Take Cold Backup :
- Take the Oracle software directory backup
$ tar -zcvf /u01/app/oracle/product/11.2.0/ohsw-bkp-b4-ptch.tar.gz /u01/app/oracle/product/11.2.0
- Take backup of oracle database .
$ tar -zcvf /u01/app/oracle/oradata/dbfl-b4-ptch.tar.gz /u01/app/oracle/oradata
Here all the database files are in oradata directory .
- Take backup of OraInventary
$ tar -zcvf /u01/app/oraInventary/orinv-b4-ptch.tar.gz /u01/app/oraInventary
5.) Apply OPatches
Set our current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
$ export PATH=$ORACLE_HOME/OPatch:$PATH:
$ opatch apply .
6.) Post Installation :
7.) Finally check the status of patch status :
We can check the final status of applied patched new Oracle Home by using the below command .
SQL > select * from dba_registry_history order by action_time desc ;
i.) If we are using a Data Guard Physical Standby database, we must install this patch on both the primary database and the physical standby database .
ii.) While applying patching take care of mount point status .There should be sufficient Space .
There are few good demo on Optach . Check the below link
For More About Opatch : Click Here
Enjoy :-) :-)