Oracle Enterprise Manager 12.1.0.2.0 PSU 1

Thanks to @BrianPardy for tweeting the availability of the first patch set update for Oracle Enterprise Manager 12.1.0.2.0. Brian also blogged about it.
The PSU Readme lists quite a number of bugs fixed in the PSU. Surprisingly the application of the patch is quite easy.

I applied it to my 12.1.0.2.0 lab environment without any issues. Just to test for real application on test and production servers.

  • Download the patch 14840279  from My Oracle Support to your OMS server.
  • Extract the zip file
  • Make sure opatch is in your PATH.


[oracle@oem3 14840279]$ which opatch
/usr/bin/which: no opatch in (/u01/app/oracle/Middleware/oms/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin)
[oracle@oem3 14840279]$ export PATH=$OMS_HOME/OPatch:$PATH
[oracle@oem3 14840279]$ which opatch
/u01/app/oracle/Middleware/oms/OPatch/opatch 
  • Set your ORACLE_HOME environment variable to your OMS Home.
[oracle@oem3 14840279]$ echo $ORACLE_HOME
[oracle@oem3 14840279]$ export ORACLE_HOME=$OMS_HOME
  • Use opatch lsinventory to verify the status of the inventory and version of opatch. Opatch should be the latest available version. In this case it was 11.1.0.9.8 which was the version bundled with 12.1.0.2.0 so no update was necessary.
[oracle@oem3 14840279]$ opatch lsinventory
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/Middleware/oms
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/app/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-01-16_23-49-17PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/Middleware"
Lsinventory Output file location : /u01/app/oracle/Middleware/oms/cfgtoollogs/opatch/lsinv/lsinventory2013-01-16_23-49-17PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
EM Platform (OMS)                                                    12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :
Patch  13983293     : applied on Sat Sep 15 18:55:57 CDT 2012
Unique Patch ID:  14779750
   Created on 25 Apr 2012, 02:18:06 hrs PST8PDT
   Bugs fixed:
     13587457, 13425845, 11822929


--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@oem3 14840279]$ cd ..

  • Stop the oms

  • Run prerequisite checks to check for any conflicts with one-off patches. If there are one-offs they may have to be rolled back prior to applying the PSU. The Readme contains instructions on what action to take in this case.
[oracle@oem3 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./14840279
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/Middleware/oms
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/app/oracle/Middleware/oms/cfgtoollogs/opatch/opatch2013-01-16_23-53-49PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/Middleware"
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
  • Apply the patch
[oracle@oem3 14840279]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.9.8
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/Middleware/oms
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/Middleware/oms/oraInst.loc
OPatch version    : 11.1.0.9.8
OUI version       : 11.1.0.9.0
Log file location : /u01/app/oracle/Middleware/oms/cfgtoollogs/opatch/14840279_Jan_16_2013_23_54_24/apply2013-01-16_23-54-24PM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/Middleware"
Applying interim patch '14840279' to OH '/u01/app/oracle/Middleware/oms'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...
Patching component oracle.sysman.oms.core, 12.1.0.2.0...
Verifying the update...
Patch 14840279 successfully applied
Log file location: /u01/app/oracle/Middleware/oms/cfgtoollogs/opatch/14840279_Jan_16_2013_23_54_24/apply2013-01-16_23-54-24PM_1.log
OPatch succeeded.
  • Make the post_deploy.sh script executable.
[oracle@oem3 14840279]$ chmod +x post_deploy.sh 
  • Execute the post deploy script (repository database and listener should be running)
[oracle@oem3 14840279]$ ./post_deploy.sh
Post deploy OMS automation script [Version: 11.1.0.9.9, Build date: November 12, 2012]
_______________________________________________________________________________________
Please enter Patch Location: /home/oracle/14840279
Please enter SYSMAN password:

The script will run the following command(s):
/u01/app/oracle/Middleware/oms/bin/emctl applypatch repos -patchHome /home/oracle/14840279
/u01/app/oracle/Middleware/oms/bin/emctl register oms metadata -service namedsql -file /u01/app/oracle/Middleware/oms/sysman/metadata/namedsql/loader_report_sql.xml -core
/u01/app/oracle/Middleware/oms/bin/emctl register oms metadata  -service report -file /u01/app/oracle/Middleware/oms/sysman/metadata/reports/Loader_Statistic.xml -core
/u01/app/oracle/Middleware/oms/bin/emctl register oms metadata -service swlib -file /u01/app/oracle/Middleware/oms/sysman/metadata/swlib/multioms -core
/u01/app/oracle/Middleware/oms/bin/emctl register oms metadata -service swlib -file /u01/app/oracle/Middleware/oms/sysman/metadata/swlib/patch -core

Please monitor log file "/home/oracle/14840279/log/2013-01-16-23-58-44.log"...

Script completed successfully.
  • Start the OMS 
[oracle@oem3 14840279]$ emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
Starting WebTier...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up

 That's it. Hopefully this solves a lot of issues that users have been complaining about.

Comments

Post a Comment

Popular posts from this blog

Setup a Wordpress site in 10 Minutes using Oracle Container Cloud Service

Image
Oracle Container Cloud Service Oracle Container Cloud Service lets you easily deploy applications based on docker images. If you don't have an existing application you can create one on docker. However, the easiest method to get a full application up and running is by deploying a stack. Oracle Container Cloud Service provides several example stacks that you can deploy, including web servers based on NGINX or Apache, MongoDB database, and Wordpress. You can find more examples on Oracle GitHub Site . Let's see just how easy it is to spin up a Wordpress site using the Oracle Container Cloud Service. Prerequisites: Access to Oracle Cloud Account Subscription to Oracle IaaS Service First, go to the Oracle Container Cloud Service console and launch a new service. In this example, I created a service with three containers. One manager and two worker nodes. Choose an appropriate "shape" for your compute instances. Note: Oracle uses the term "shape" to r...
Read more

Oracle Home Cloning: Tools and Techniques

One of the many necessary and frequent tasks that a database administrator performs before creating a database is installing the Oracle database binaries. These binaries form what is known as an Oracle Home (referenced by the ORACLE_HOME environment variable on Linux and UNIX environments). Unfortunately, this is also one of the most mundane and uninteresting tasks a DBA can perform. So like all good DBAs know, the best way to deal with such repetitive task is to automate it. Automating installations of Oracle database binaries enables us to reliably repeat the process to enable faster installation as well as provide identical copies of the software in multiple environments. Fortunately, Oracle allows us to clone the Oracle database binaries from one environment to another. Cloning your Oracle binaries from a source copy with all the necessary patches applied enables us to have gold images which can then be deployed to multiple environments. The procedure for cloning an Oracle home...
Read more

Using XFS on Oracle Linux

Install xfs packages on Oracle Linux 6.6 via Oracle Public Yum [root@matthew ~]# yum install xfsprogs Loaded plugins: refresh-packagekit Setting up Install Process public_ol6_UEKR3_latest | 1.2 kB 00:00 public_ol6_UEK_latest | 1.2 kB 00:00 public_ol6_UEK_latest/primary | 19 MB 00:02 public_ol6_UEK_latest 407/407 public_ol6_addons | 1.2 kB 00:00 public_ol6_addons/primary | 77 kB 00:00 public_ol6_addons 269/269 public_ol6_latest | 1.4 kB 00:00 public_ol6_latest/primary | 46 MB 00:05 public_ol6_latest 29302/29302 http://public-yum.oracle.com/beta/repo/OracleLinux/OL6/uek3/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found" Trying other mirror. Resolving Dependencies --> Running transaction check ---> Package xfsprogs.x86_64 0:3.1.11-1.0.5.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================...
Read more