Tuesday, December 31, 2013


Apply PSU 9 on OEM 11.1.0.1 Base Release


 While running OEM 11.1.0.1, we ran into few issues over a period of time. With 12c Cloud control out for a while, we will considering the upgrade of the existing OEM 11g. Looking at the complexity of 12c upgrade and Oracle suggesting 2 cycles of test, production upgrade still a long shot. 
Mean while, the option we had is to consider the application of PSU on top of base release of OEM 11g. 
Looking around we figured out the latest PSU available was PSU 9 aka 11.1.0.1.9 patch . 

 Following is the outline should one consider the application of PSU patch. 

 If you do not have the latest version of OPatch, then download it from patch# 6880880 for 11.1.0.0.0 release.

Pre-requisite Patch 12620174

 This patch is an auto-update patch. That means that any new install of OMS will have it by default, you dont need to apply if manually. Though, for old installations, one has to apply it manually. 

 This patch is called as generic patch i.e. it can be applied on top of 11.1 release. The purpose of this patch is to enhance the patching process for OMS. If you remember, earlier patches used to have two post patch SQL files, to introduce the SQL changes. Post application of this patch, you will only need one. This will reduce the time as well as the user errors, As there are many who forgot to apply the second file due similar sounding names. 
Another important thing is that, this patch only affects how the SQL changes rolled out by applying patch, it doesn't affect how java changes are rolled out during patch. 

 Steps to apply Patch 12620174

 1. Perquisites: Make sure opatch,unzip are in path. Also ensure you are using latest OPatch version.

 2. Copy the patch to the server and unzip

 $ unzip p12620174_111010_Generic.zip

 3. Shut down services running from the ORACLE_HOME.

 $ emctl stop oms
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

 $ $AGENT_HOME/bin/emctl stop agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Stopping agent … stopped.

 4. Set your current directory to the directory where the patch is located:

 $ cd 12620174
$ opatch napply
OPatch succeeded.

 5. Connect to rcuJDBCEngine as SYS and execute the following sql file. Please make sure you set $ORACLE_HOME to OMS_HOME before you connect to rcuJDBCEngine.

 
$ORACLE_HOME/bin/rcuJDBCEngine sys/welcome1@myhost.myorg.com:1521:sid JDBC_SCRIPT 10154264/patch_10154264.sql $PWD $ORACLE_HOME



Completed SQL script execution normally.

1 scripts were processed



6. Start OMS using the following command. In case of multi-OMS environment, start on all OMS machines



$ 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



Steps to apply 16572176



This is the actual PSU that will roll out the changes to OMS (java+SQL)



1. Perquisites: Make sure opatch,unzip are in path. Also ensure you are using latest OPatch version.

Set ORACLE_HOME to OMS home



2. Ensure that the PSU does not conflict with the already-installed one-off patches. To do so, run the following command to generate a report that lists all conflicting patches.



$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./16572176

Invoking OPatch 11.2.0.1.1



Oracle Interim Patch Installer version 11.2.0.1.1

Copyright (c) 2009, Oracle Corporation. All rights reserved.



PREREQ session

Oracle Home : /u01/app/oracle/Middleware/oms11g

Central Inventory : /u01/app/oraInventory

from : /etc/oraInst.loc

OPatch version : 11.2.0.1.1

OUI version : 11.1.0.8.0

OUI location : /u01/app/oracle/Middleware/oms11g/oui

Log file location : /u01/app/oracle/Middleware/oms11g/cfgtoollogs/opatch/opatch2011-08-04_11-06-55AM.log



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

OPatch detects the Middleware Home as “/u01/app/oracle/Middleware”

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.



Note: If you do see any conflicting patches refer README.txt



3. Stop all om services



$<ORACLE_HOME>/bin/emctl stop oms -all

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



4. Download and Unzip the p16572176_111010_Generic.zip and cd to 16572176



$cd 16572176

$ opatch apply



Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Copyright (c) 2009, Oracle Corporation. All rights reserved.

OPatch succeeded.



5. Connect to rcuJDBCEngine as SYSMAN and run the apply.sql script as follows:



$ /u01/app/oracle/Middleware/oms11g/bin/rcuJDBCEngine sysman@Host:1521:GCREPO JDBC_SCRIPT apply.sql $PWD $ORACLE_HOME



###### SQL Patching operation has started. The Pre-requisites check ######

###### may take upto 3 minutes. Please do not cancel the operation. ######

###### Refer to My Oracle Support note 1326515.1 for more information ######

----------------

Completed SQL script execution normally.

41 scripts were processed



6. Start 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





If you have installed emcli, then run the following command on all the emcli installations:

$ emcli sync



Once the PSU applied on OMS home, you may need to apply patch on Agent Home as well. At the time of writing of this article, the PSU for agent home is not yet available. The latest patch is available for Agent Home is PSU 7.



Patch 9346282 - 11.1.0.1.7 Patch Set Update for Oracle Management Agent. Pls refer following table (as publish in Doc ID - 1358092.1











11.1.0.1

OMSAGENT UnixAGENT Windows


PSU1 (11.1.0.1.1)10065631--


PSU2 (11.1.0.1.2)102700731027360710273607


PSU3 (11.1.0.1.3)11727299934590611778791


PSU4 (11.1.0.1.4)12423703934591312423714


PSU5 (11.1.0.1.5)12833678934592112833724


PSU6  (11.1.0.1.6)13248190934624313248202


PSU7 (11.1.0.1.7)13711705934628213711732


PSU8 (11.1.0.1.8)14766609--


PSU9 (11.1.0.1.9)16572176--


PSU10 (11.1.0.1.10)17154155--














Posted by



at





No comments:
  


































        

      









Subscribe to:
Posts (Atom)