Sunday, January 16, 2011

Steps to patch Oracle Grid Control from 10.2.0.1 to 10.2.0.4

In my case I had already installed grid control 10.2.0.1 and had chosen the option 'Enterprise Manager using New Database'.

For the purpose of this blog I will refer to the machine with grid control 10.2.0.1 installed as node1.

First I downloaded the patch from the following link:
http://www.oracle.com/technetwork/oem/grid-control/downloads/linuxsoft-099441.html

Once the download is complete I unzipped the files to node1. This created the following files:

3731596.zip
3822442.zip
p3731593_10204_LINUX.zip
p4239444_10104_LINUX.zip
p4329444_10105_LINUX.zip
README.txt

Before starting the patch process I ensured that all the services of the grid control in node1 are stopped. For doing this I executed the following set of commands:
$ /u01/app/oracle/product/10.2.0/oms10g/bin/emctl stop oms
$ /u01/app/oracle/product/10.2.0/oms10g/bin/emctl stop iasconsole
$ /u01/app/oracle/product/10.2.0/oms10g/opmn/bin/opmnctl stop all
$ /u01/app/oracle/product/10.2.0/agent10g/bin/emctl stop agent

Then I shutdown the repository database:
$ sqlplus / as sysdba
SQL> shutdown immediate


Remember that the repository database created while installing oracle grid control 10.2.0.1 is version 10.1.0.4.0 hence this needs to be updated before the patch can be applied.
For doing this I extracted the file p4329444_10104_LINUX.zip. This will create the following folder:
4329444

Now I set the environment variable OBJECT_MODE to 32_64.
$ export OBJECT_MODE=32_64

I navigated to the folder 432944 using the command
$ cd 432944
and then applied the patch using the opatch utility as follows:
$ opatch apply
Note: Make sure that the ORACLE_HOME is set to database home. In order to identify make use of the echo command otherwise the above opatch will fail.

Now that the patch is applied I started the repository database again using  the emrep database sid:
$ export ORACLE_SID=emprep
SQL> sqlplus / as sysdba
SQL> startup

Now I checked the listener status:
$ lsnrctl status
if down then startup the listener using the command
$ lsnrctl start

Now for applying the patch on the grid control I extracted the p3731593_10204_LINUX as a result it created a folder 3731593 which in turn had a Disk1 folder and a readme.html file within it.

I navigated to the Disk1 folder and started the patch installer using the following set of commands:
$ cd 3731593/Disk1
$ ./runInstaller

During the installation I selected the OMS home which was located in the /u01/app/oracle/product/10.2.0/oms10g folder.

Once the patch was applied on the OMS I needed to apply it on the agent running in node1. For doing this I once again ran the runInstaller located in 3731593/Disk1 folder and this time selected the agent home.

Note: If there are agents running on other system that are to be patched then I apply the following steps:

1. Shutdown the agent:
$ /u01/app/oracle/product/10.2.0/agent10g/bin/emctl stop agent

2. Extract the p3731593 archive.

3. Run the patch installer:
$ cd 3731593/Desk1
$ ./runInstaller

4. During the installation select the agent home which in my case was located in /u01/app/oracle/product/10.2.0/agent10

5. After the patch is applied the agent is automatically started which can be verified using the command:
$ /u01/app/oracle/product/10.2.0/agent10g/bin/emctl status agent

No comments:

Post a Comment