Martins Blog

Trying to explain complex things in simple terms

Patch 10270073 – 11.1.0.1.2 Patch Set Update for Oracle Management Service

Posted by Martin Bach on February 1, 2011

Today is patch day – on my current site we are having quite a few problems with our management server (OMS from now on). It occasionally simply “hangs” and doesn’t respond when connecting to the SSH port. A few minutes later it’s back to normal-but this behaviour is not reproducible.

So in an effort to please Oracle support who couldn’t find a reason for this I decided to apply Patch Set Update 2 to the OMS to get it to 11.1.0.1.2. I would also like to filter the corresponding agent patch for our 11.1 agents through as well. The PSU has been released 2 weeks ago so it’s reasonably fresh.The patches for OMS and agent are generic, which is nice as it implies they are available for every platform. Our OMS had had problems before, and one-off patches have been applied. So the first step as always with PSUs is to check if there are conflicts. The readme file has the required instructions. I unzipped p10270073_111010_Generic.zip in /tmp/ and then executed the prerequisite checker in /tmp as shown in this example:

<pre>[oms]oracle@oms $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./10270073
Invoking OPatch 11.1.0.8.0

Oracle Interim Patch Installer version 11.1.0.8.0
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/middleware/oms11g
Central Inventory : /u01/app/oracle/product/oraInventory
 from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.1.0.8.0
OUI version       : 11.1.0.8.0
OUI location      : /u01/app/oracle/product/middleware/oms11g/oui
Log file location : /u01/app/oracle/product/middleware/oms11g/cfgtoollogs/opatch/opatch2011-02-01_08-48-14AM.log

Patch history file: /u01/app/oracle/product/middleware/oms11g/cfgtoollogs/opatch/opatch_history.txt

OPatch detects the Middleware Home as "/u01/app/oracle/product/middleware"

Invoking prereq "checkconflictagainstohwithdetail"

ZOP-40: The patch(es) has conflicts/supersets with other patches installed in the Oracle Home (or) among themselves.

Prereq "checkConflictAgainstOHWithDetail" failed.

Summary of Conflict Analysis:

Patches that can be applied now without any conflicts are :
10270073

Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
9563902, 9537948, 9489355

Following patches will be rolled back from Oracle Home on application of the patches in the given list :
9563902, 9537948, 9489355

Conflicts/Supersets for each patch are:

Patch : 10270073

 Bug Superset of 9563902
 Super set bugs are:
 9491872,  9476313,  9544428

 Bug Superset of 9537948
 Super set bugs are:
 9537948

 Bug Superset of 9489355
 Super set bugs are:
 9489355

OPatch succeeded.
[oms]oracle@oms $

OK, so a few one-offs will be rolled back. Let’s get started. First of all we have to stop the OMS as shown here:

[oms]oracle@oms $ emctl stop oms
<pre>Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down

The next step is to apply the patch. Here’s the sample session:

[oms]oracle@oms $ cd 10270073

[oms]oracle@oms $ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 11.1.0.8.0

Oracle Interim Patch Installer version 11.1.0.8.0
Copyright (c) 2009, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/middleware/oms11g
Central Inventory : /u01/app/oracle/product/oraInventory
 from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.1.0.8.0
OUI version       : 11.1.0.8.0
OUI location      : /u01/app/oracle/product/middleware/oms11g/oui
Log file location : /u01/app/oracle/product/middleware/oms11g/cfgtoollogs/opatch/opatch2011-02-01_09-00-00AM.log

Patch history file: /u01/app/oracle/product/middleware/oms11g/cfgtoollogs/opatch/opatch_history.txt

OPatch detects the Middleware Home as "/u01/app/oracle/product/middleware"

ApplySession applying interim patch '10270073' to OH '/u01/app/oracle/product/middleware/oms11g'
Interim patch 10270073 is a superset of the patch(es) [  9563902 9537948 9489355 ] in the Oracle Home
OPatch will rollback the subset patches and apply the given patch.
Execution of 'sh /tmp/10270073/custom/scripts/init -apply 10270073 ':

Return Code = 0

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '10270073' for restore. This might take a while...
Backing up files affected by the patch '9563902' for restore. This might take a while...
Backing up files affected by the patch '9537948' for restore. This might take a while...
Backing up files affected by the patch '9489355' for restore. This might take a while...
ApplySession rolling back interim patch '9563902' from OH '/u01/app/oracle/product/middleware/oms11g'

Patching component oracle.sysman.oms.core, 11.1.0.1.0...
Copying file to "/u01/app/oracle/product/middleware/oms11g/sysman/omsca/scripts/wls/create_domain.py"
RollbackSession removing interim patch '9563902' from inventory
ApplySession rolling back interim patch '9537948' from OH '/u01/app/oracle/product/middleware/oms11g'

Patching component oracle.sysman.oms.core, 11.1.0.1.0...
Updating jar file "/u01/app/oracle/product/middleware/oms11g/sysman/jlib/emInstall.jar" with "/u01/app/oracle/product/middleware/oms11g/.patch_storage/9537948_Apr_12_2010_03_37_52/files//sysman/jlib/emInstall.jar/oracle/sysman/configassistant/addon/AddOnConfigAssistantDriver.class"
Updating jar file "/u01/app/oracle/product/middleware/oms11g/sysman/jlib/emInstall.jar" with "/u01/app/oracle/product/middleware/oms11g/.patch_storage/9537948_Apr_12_2010_03_37_52/files//sysman/jlib/emInstall.jar/oracle/sysman/configassistant/addon/AddOnConfigAssistantDriver$1.class"
Updating jar file "/u01/app/oracle/product/middleware/oms11g/sysman/jlib/emInstall.jar" with "/u01/app/oracle/product/middleware/oms11g/.patch_storage/9537948_Apr_12_2010_03_37_52/files//sysman/jlib/emInstall.jar/oracle/sysman/configassistant/addon/AddOnConfigAssistantDriver$AddOnFileFilter.class"
RollbackSession removing interim patch '9537948' from inventory
ApplySession rolling back interim patch '9489355' from OH '/u01/app/oracle/product/middleware/oms11g'

Patching component oracle.sysman.oms.core, 11.1.0.1.0...
Copying file to "/u01/app/oracle/product/middleware/oms11g/bin/HAConfigCmds.pm"
RollbackSession removing interim patch '9489355' from inventory

OPatch back to application of the patch '10270073' after auto-rollback.

Backing up files affected by the patch '10270073' for rollback. This might take a while...

Patching component oracle.sysman.oms.core, 11.1.0.1.0...
Updating jar file "/u01/app/oracle/product/middleware/oms11g/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/policy/PolicyViolationsController.class"
[...]
Copying file to "/u01/app/oracle/product/middleware/oms11g/bin/SecureOMSCmds.pm"
Copying file to "/u01/app/oracle/product/middleware/oms11g/sysman/emdrep/scripts/SecureAgent_oms.pl"
ApplySession adding interim patch '10270073' to inventory

Verifying the update...
Inventory check OK: Patch ID 10270073 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 10270073 are present in Oracle Home.
Execution of 'sh /tmp/10270073/custom/scripts/post -apply 10270073 ':

Return Code = 0
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67620:Interim patch 10270073 is a superset of the patch(es) [  9563902 9537948 9489355 ] in the Oracle Home
--------------------------------------------------------------------------------
OPatch Session completed with warnings.

OPatch completed with warnings.

This process took 1 hour on my SPARC zone-not too impressed actually. But I’m blaming it on the overloaded box instead of the patch process.The outcome of the patching looks ok to me-I already knew I applied PSU 2 as a superset of 3 other patches. The next step is to apply the post install script. This is done by calling a JDBC application as shown here:

[oms]oracle@oms $ $ORACLE_HOME/bin/rcuJDBCEngine sys/secretpassword@repositoryHost:1821:REPOSDB JDBC_SCRIPT post_install_script.sql $PWD $ORACLE_HOME
Extracting Statement from File Name: 'post_install_script.sql' Line Number: 1
Extracted SQL Statement: [alter session set current_schema=SYSMAN]
 Statement Type: 'DDL Statement'
Executing SQL statement: alter session set current_schema=SYSMAN
Extracting Statement from File Name: 'post_install_script.sql' Line Number: 1
Extracting Statement from File Name: 'post_install_script.sql' Line Number: 1
Extracted SQL Statement: [SET serveroutput on size 1000000]
Skipping Unsupported Statement
 Statement Type: 'Oracle RCU NotSupported SQLPlus Statement'
Extracting Statement from File Name: 'post_install_script.sql' Line Number: 2
Extracted SQL Statement: [BEGIN
 EXECUTE IMMEDIATE 'drop table bundle_component_files';
 EXCEPTION WHEN OTHERS THEN
 IF sqlcode = -942 THEN
 NULL;
 ELSE
 RAISE;
 END IF;
END;
]
....
 END;
 END IF;
 END IF;
 RAISE;
END;
]
 Statement Type: 'BEGIN/END Anonymous Block'
Completed SQL script execution normally.
1 scripts were processed
<pre>[oms]oracle@oms $ $ORACLE_HOME/bin/rcuJDBCEngine sys/secretpassword@repositoryHost:1821:REPOSDB JDBC_SCRIPT post_install_patch.sql $PWD $ORACLE_HOME
(output omitted-rather lengthy...)
</pre>

Now finally it’s time to start the OMS and cross our fingers to see if it worked:

[oms]oracle@oms $ emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server Successfully Started
Oracle Management Server is Up
[oms]oracle@oms $

I’d call this success-I managed to log on to the OMS and performed some basic testing which implied the patch was successfully applied.

3 Responses to “Patch 10270073 – 11.1.0.1.2 Patch Set Update for Oracle Management Service”

  1. Hi Martin,

    I have experienced high CPU Utilization (before applying PSU) by the OMS and blogged about it: http://www.ora-solutions.net/web/2010/11/11/grid-control-11g-diagnosing-oms-high-cpu-utilization/

    It was caused by parallel garbage collection of java vm. However, in my case, it burned only one core. If you have more than one core, it should not overload the whole box.

    Regards,
    Martin

  2. shah said

    I think you missed one script here. you have to run tow scrips as part of the post installation .

    Install the PSU by running the following command:

    $ opatch apply

    Connect to rcuJDBCEngine as SYS and run the post_install_script.sql script as follows:

    $ORACLE_HOME/bin/rcuJDBCEngine sys/@:: JDBC_SCRIPT post_install_script.sql $PWD $ORACLE_HOME

    If the previous step runs successfully, then you must run the post_install_patch.sql as SYS user:

    $ORACLE_HOME/bin/rcuJDBCEngine sys/@:: JDBC_SCRIPT post_install_patch.sql $PWD $ORACLE_HOME

    Restart the OMS by running the following command from its Oracle home:

    $ emctl start oms

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: