SYSTEM PATCH/PSU FOR OEM 13cR2

SYSTEM PATCH/PSU FOR OEM 13cR2

In today's demonstration I am going to show how to apply PSU/System Patch to OMS Server. The reason for applying the patch as we are facing some bug hit in my environment.

Below are bug which can be fix after applying PatchSet:

Enterprise Manager for Systems Infrastructure: 13.2.1.0.0

· 25292163: EM SI Plugin Bundle Patch 13.2.1.0.170131.......

· 24785360: Host node is shown as the subnode ......

Enterprise Manager for Oracle Database: 13.2.1.0.0

· 25291362: EM DB Plugin Bundle Patch 13.2.1.0.170131 ............

· 25443348: Tracking bug to add sql script to register changes of chargeback/database.xml............

· 25361430: Tracking bug to register meta version from 13.2.1.0.161231 DB Plugin Bundle............

· 25340600: No data is displayed for metric: PDB - cpu time in chargeback............

· 25334003: SIHA Rollback fails when DB running on host............

· 25331825: GI Gold Image Creation Failure due to Large no. Patches............

· 24742759: ERROR: Failed to alter the mode of the Pluggable Database PDB............

· 25308711: ZDLRA DP fails with ORA-00922 in redo transport user validation/creation script............

· 25176739: Snapshot retention as per Admin discretion Policy settings............

· 25098485: 'ORA-01722' during modifying adaptive thresholds from 12105 EM............

· 25295869: Unable to Delete Snapshot Profile............

· 25295935: Snap Clone DB Instance pointing to the Source DB FRA............

· 25298500: Tracking bug for Back-porting dbplugin side changes for fix hhkaur_csnovfixes............

· 24695873: DM 13c : 'ORA-00904: 'EDITIONABLE': invalid identifier' in ADM Ref.Relationships............

· 25294782: USE ARCHIVELOG CURRENT IN PLACE OF SWITCH LOGFILE FOR SYNCHRONOUS ACTION............

· 22709047: Garbled Character when performing Save Mask Bundle............

· 24822934: [EM13.2PG] unable to copy the password file from ASM for far sync creation............

· 25170293: Exadata 12.1/12.2 RAC DB AWR Report does not show data for all nodes, shows one............

· 24831549: emcli migrate_noncdb_to_pdb verb fails in Migration Import............

· 24573192: Need separate target type for PDBaaS instances............

· 23629445: Tablespace search not working when switching to CDB container level............

· 24360223: EM Cloud control showing incorrect OBJECT_TYPE for dependent object............

· 24607089: Create Exadata Test Master PDB failing from UI............

· 24961823: MOVE datafile locations while creating PDB un-plug/plug............

· 21899436: DO NOT USE ROWNUM IN MAPPING TABLE CTAS............

· 25427621: Tracking bug to register meta version from 13.2.1.0.0 DB Plugin in BP............

Download the Patch/OPatch/OMSPatcher from support related to your version.

[oracle@oem250 Middleware13c]$ cd /ora_nfs/software/Oracle/database/PSU_OEM/13cR2/

[oracle@oem250 13cR2]$ ls -ltrah

total 376M

-rw-r--r-- 1 500 501 375M Jul 3 2017 p25362912_132000_Generic_13cR2_Jul2017.zip

drwxr-xr-x 4 500 501 4.0K Jul 3 2017 ..

-rw-r--r-- 1 500 501 715K Jul 3 2017 p19999993_132000_Generic_OMSPatcher.zip

drwxr-xr-x 2 500 501 4.0K Jul 3 2017 .

Unzip the OMSPatcher to Middleware Home

[oracle@oem250 13cR2]$ unzip -d /u01/app/oracle/Middleware13c p19999993_132000_Generic_OMSPatcher.zip

Archive: p19999993_132000_Generic_OMSPatcher.zip

creating: /u01/app/oracle/Middleware13c/OMSPatcher/

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/omspatcher.bat

creating: /u01/app/oracle/Middleware13c/OMSPatcher/jlib/

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/jlib/omspatcher.jar

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/jlib/oracle.omspatcher.classpath.jar

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/jlib/oracle.omspatcher.classpath.unix.jar

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/jlib/oracle.omspatcher.classpath.windows.jar

creating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/

creating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/

creating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/oms_child_scripts/

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery.bat

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls.bat

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/omspatcher

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/scripts/oms/omspatcher.bat

creating: /u01/app/oracle/Middleware13c/OMSPatcher/wlskeys/

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/wlskeys/createkeys.cmd

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/wlskeys/createkeys.sh

creating: /u01/app/oracle/Middleware13c/OMSPatcher/oms/

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/oms/generateMultiOMSPatchingScripts.pl

inflating: /u01/app/oracle/Middleware13c/OMSPatcher/omspatcher

inflating: /u01/app/oracle/Middleware13c/readme.txt

inflating: /u01/app/oracle/Middleware13c/PatchSearch.xml

Also Unzip the download System Patch / PSU to staging location

[oracle@oem250 13cR2]# unzip -d 25362912/ p25362912_132000_Generic_13cR2_Jul2017.zip

Archive: p25362912_132000_Generic_13cR2_Jul2017.zip

creating: 25362912/25362912/

creating: 25362912/25362912/25310724/

inflating: 25362912/25362912/25310724/README.txt

creating: 25362912/25362912/25310724/etc/

creating: 25362912/25362912/25310724/etc/config/

inflating: 25362912/25362912/25310724/etc/config/artifact_rollback.xml

inflating: 25362912/25362912/25310724/etc/config/artifact_apply.xml

inflating: 25362912/25362912/25310724/etc/config/inventory.xml

inflating: 25362912/25362912/25310724/etc/config/actions.xml

creating: 25362912/25362912/25310724/files/

creating: 25362912/25362912/25310724/files/oracle.sysman.xa.oms.plugin/

creating: 25362912/25362912/25310724/files/oracle.sysman.xa.oms.plugin/13.2.1.0.0/

creating: .....

.....................

......zipping contd..

.....................

creating: 25362912/25362912/25292163/files/oracle.sysman.si.oms.plugin/13.2.1.0.0/em.plugin.common.symbol/oracle.sysman.si.oms.plugin_13.2.1.0.0/

creating: 25362912/25362912/25292163/files/oracle.sysman.si.oms.plugin/13.2.1.0.0/em.plugin.common.symbol/oracle.sysman.si.oms.plugin_13.2.1.0.0/archives/

inflating: 25362912/25362912/25292163/files/oracle.sysman.si.oms.plugin/13.2.1.0.0/em.plugin.common.symbol/oracle.sysman.si.oms.plugin_13.2.1.0.0/archives/emsi.war

inflating: 25362912/PatchSearch.xml

Check the existing version of OPatch

[oracle@oem250 OPatch]$ ./opatch version

OPatch Version: 13.8.0.0.0

Since OMSPatcher required the latest version of JDK. So I download the latest and install on my OMS Server.

[oracle@oem250 JDK]$ ls -ltra

total 345332

-rwxrwxrwx 1 500 501 168066783 Oct 17 2016 jdk-8u101-linux-i586.rpm

drwxrwxrwx 11 777 501 4096 Jul 3 2017 ..

drwxrwxrwx 2 root root 4096 Jul 3 2017 jdk_64

drwxr-xr-x 3 500 501 4096 Jul 3 2017 .

[oracle@oem250 jdk_64]$ sudo chmod -R 777 *

[oracle@oem250 jdk_64]$ sudo rpm -ivh jdk-8u131-linux-x64.rpm

Preparing... ########################################### [100%]

1:jdk1.8.0_131 ########################################### [100%]

Unpacking JAR files...

tools.jar...

plugin.jar...

javaws.jar...

deploy.jar...

rt.jar...

jsse.jar...

charsets.jar...

localedata.jar...

[oracle@oem250 ~]$ java -version

java version "1.8.0_131"

Java(TM) SE Runtime Environment (build 1.8.0_131-b11)

Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, mixed mode)

Installing Latest OPatch (13.9.1.3.0)

[oracle@oem250 jdk_64]$ java -jar /ora_nfs/software/Oracle/database/Patch/OPatch/6880880/opatch_generic.jar -silent oracle_home=$ORACLE_HOME

Launcher log file is /tmp/OraInstall2017-06-30_07-23-00AM/launcher2017-06-30_07-23-00AM.log.

Extracting the installer . . . . Done

Checking if CPU speed is above 300 MHz. Actual 3494.416 MHz Passed

Checking swap space: must be greater than 512 MB. Actual 7999 MB Passed

Checking if this platform requires a 64-bit JVM. Actual 64 Passed (64-bit not required)

Checking temp space: must be greater than 300 MB. Actual 10969 MB Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-06-30_07-23-00AM

Installation Summary

Disk Space : Required 26 MB, Available 76,894 MB

Feature Sets to Install:

Next Generation Install Core 13.9.1.0.1

OPatch 13.9.1.3.0

OPatch Auto OPlan 13.9.1.0.0

Session log file is /tmp/OraInstall2017-06-30_07-23-00AM/install2017-06-30_07-23-00AM.log

Loading products list. Please wait.

40%

Loading products. Please wait.

42%

43%

44%

45%

.....

95%

96%

98%

97%

99%

Updating Libraries

Starting Installations

...

.....

S_COMP_INPROGRESS_SAVE_INVENTORY

Component : oracle.glcm.opatchauto.core.actions.classpath

S_COMP_INPROGRESS_SAVE_INVENTORY

Component : oracle.glcm.opatchauto.core.wallet.classpath

S_COMP_INPROGRESS_SAVE_INVENTORY

Logs successfully copied to /u02/app/oraInventory/logs.

Validating the Latest OPatch (13.9.1.3.0)

[oracle@oem250 jdk_64]$ cd $ORACLE_HOME

[oracle@oem250 Middleware13c]$ cd OPatch

[oracle@oem250 OPatch]$ ./opatch version

OPatch Version: 13.9.1.3.0

OPatch succeeded.

[oracle@oem250 OPatch]$

[oracle@oem250 OPatch]$ ./opatch lspatches

24450351;One-off

23519804;One-off

22065592;One-off

21252292;One-off

21243471;One-off

20882747;One-off

20758863;One-off

20442348;One-off

20222451;One-off

20022048;One-off

19982906;One-off

19953516;One-off

19901079;One-off

19879223;One-off

19730967;One-off

19345252;One-off

18974665;One-off

18836900;One-off

18814458;One-off

23527146;One-off

20741228;JDBC 12.1.3.1 BP1

OPatch succeeded.

Creating a Property File

The automated patching functionality achieved using opatchauto expects WebLogic Administration Server URL and credentials as an input for patching and configuration detection operations. Primarily, the WebLogic Administration server is the host that manages the Managed Server where the OMS instance is deployed. If you do not want to set the credentials every time you are prompted while patching the OMS, you can update the property file. OPatch allows you to repeatedly provide the inputs using property file option.

Steps for how to create a property file for OPatch:

[oracle@oem250 OPatch]$ /u01/app/oracle/Middleware13c/OMSPatcher/wlskeys/createkeys.sh -h /u01/app/oracle/Middleware13c -location /tmp

Please enter weblogic admin server username: weblogic

Please enter weblogic admin server password:

Warning: weblogic.Admin is deprecated and will be removed in a future release. WLST should be used instead of weblogic.Admin.

Creating the key file can reduce the security of your system if it is not kept in a secured location after it is created. Creating new key...

Trying to get configuration and key files for the given inputs...

This operation will take some time. Please wait for updates...

User configuration file created: /tmp/config

User key file created: /tmp/key

'createkeys' succeeded.

[oracle@oem250 OPatch]$ vi 13cOEM.propertyfile

[oracle@oem250 OPatch]$

[oracle@oem250 OPatch]$ more 13cOEM.propertyfile

AdminServerURL=t3s://oem250.ora.com:7102

AdminConfigFile=/tmp/config

AdminKeyFile=/tmp/key

You can get the admin server URL by executing oms details as below:

[oracle@oem250 OPatch]$ emctl status oms -details

Oracle Enterprise Manager Cloud Control 13c Release 2

Enter Enterprise Manager Root (SYSMAN) Password :

Console Server Host : oem250.ora.com

HTTP Console Port : 7788

HTTPS Console Port : 7802

HTTP Upload Port : 4889

HTTPS Upload Port : 4903

EM Instance Home : /u01/app/oracle/gc_inst1/em/EMGC_OMS1

OMS Log Directory Location : /u01/app/oracle/gc_inst1/em/EMGC_OMS1/sysman/log

OMS is not configured with SLB or virtual hostname

Agent Upload is locked.

OMS Console is locked.

Active CA ID: 1

Console URL: https://oem250.ora.com:7802/em

Upload URL: https://oem250.ora.com:4903/empbs/upload

WLS Domain Information

Domain Name : GCDomain

Admin Server Host : oem250.ora.com

Admin Server HTTPS Port: 7102

Admin Server is RUNNING

Oracle Management Server Information

Managed Server Instance Name: EMGC_OMS1

Oracle Management Server Instance Host: oem250.ora.com

WebTier is Up

Oracle Management Server is Up

JVMD Engine is Up

BI Publisher Server Information

BI Publisher Managed Server Name: BIP

BI Publisher Server is Up

BI Publisher HTTP Managed Server Port : 9701

BI Publisher HTTPS Managed Server Port : 9803

BI Publisher HTTP OHS Port : 9788

BI Publisher HTTPS OHS Port : 9851

BI Publisher is locked.

BI Publisher Server named 'BIP' running at URL: https://oem250.ora.com:9851/xmlpserver

BI Publisher Server Logs: /u01/app/oracle/gc_inst1/user_projects/domains/GCDomain/servers/BIP/logs/

BI Publisher Log : /u01/app/oracle/gc_inst1/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log

Analyze the Patch before apply to OMS

[oracle@oem250 25362912]$ /u01/app/oracle/Middleware13c/OMSPatcher/omspatcher apply -analyze -property_file /tmp/13cOEM.propertyfile

OMSPatcher Automation Tool

OMSPatcher version : 13.8.0.0.2

OUI version : 13.9.1.0.0

Running from : /u01/app/oracle/Middleware13c

Log file location : /u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/opatch2017-06-30_10-15-41AM_1.log

OMSPatcher log file: /u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/25362912/omspatcher_2017-06-30_10-15-52AM_analyze.log

WARNING: Could not apply the patch "25105054" because the "oracle.sysman.emfa.oms.plugin with version 13.2.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.

WARNING: Could not apply the patch "25359607" because the "oracle.sysman.csm.oms.plugin with version 13.2.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.

Configuration Validation: Success

Running apply prerequisite checks for sub-patch(es) "25292157,25291362,25310724,25292154,25310689,25118889,25303753,25305707,25292163" and Oracle Home "/u01/app/oracle/Middleware13c"...

Sub-patch(es) "25292157,25291362,25310724,25292154,25310689,25118889,25303753,25305707,25292163" are successfully analyzed for Oracle Home "/u01/app/oracle/Middleware13c"

Complete Summary

================

All log file names referenced below can be accessed from the directory "/u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/2017-06-30_10-15-41AM_SystemPatch_25362912_1"

Prerequisites analysis summary:

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

The following sub-patch(es) are applicable:

Featureset Sub-patches Log file

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

oracle.sysman.top.oms 25292157,25291362,25310724,25292154,25310689,25118889,25303753,25305707,25292163 25292157,25291362,25310724,25292154,25310689,25118889,25303753,25305707,25292163_opatch2017-06-30_10-15-51AM_1.log

The following sub-patches are incompatible with components installed in the OMS system:

25105054,25359607

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

The following warnings have occurred during OPatch execution:

1) Could not apply the patch "25105054" because the "oracle.sysman.emfa.oms.plugin with version 13.2.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.

2) Could not apply the patch "25359607" because the "oracle.sysman.csm.oms.plugin with version 13.2.1.0.0" core component of the OMS or the plug-in for which the patch is intended is either not deployed or deployed with another version in your Enterprise Manager system.

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

OMSPatcher Session completed with warnings.

Log file location: /u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/25362912/omspatcher_2017-06-30_10-15-52AM_analyze.log

OMSPatcher completed with warnings.

We can ignore the warning as reference component has not been deployed by me. If you have deployed and still getting error please get in touch with Oracle Support.

Stopping OMS

Before applying system patch ensure that OMS is not running.

[oracle@oem250 25362912]$ emctl stop oms

Oracle Enterprise Manager Cloud Control 13c Release 2

Stopping Oracle Management Server...

Oracle Management Server Successfully Stopped

Oracle Management Server is Down

JVMD Engine is Down

[oracle@oem250 25362912]$

Applying System Patch to OMS 13cR2

[oracle@oem250 25362912]$ /u01/app/oracle/Middleware13c/OMSPatcher/omspatcher apply -property_file /tmp/13cOEM.propertyfile

OMSPatcher Automation Tool

OMSPatcher version : 13.8.0.0.2

OUI version : 13.9.1.0.0

Running from : /u01/app/oracle/Middleware13c

Log file location : /u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/opatch2017-06-30_10-32-35AM_1.log

OMSPatcher log file: /u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/25362912/omspatcher_2017-06-30_10-32-45AM_deploy.log

Configuration Validation: Success

Running apply prerequisite checks for sub-patch(es) "25292157,25291362,25310724,25292154,25310689,25118889,25303753,25305707,25292163" and Oracle Home "/u01/app/oracle/Middleware13c"...

Sub-patch(es) "25292157,25291362,25310724,25292154,25310689,25118889,25303753,25305707,25292163" are successfully analyzed for Oracle Home "/u01/app/oracle/Middleware13c"

To continue, OMSPatcher will do the following:

[Patch and deploy artifacts] : Apply sub-patch(es) [ 25118889 25291362 25292154 25292157 25292163 25303753 25305707 25310689 25310724 ]

Apply RCU artifact with patch "/u01/app/oracle/Middleware13c/.omspatcher_storage/25291362_Jan_24_2017_07_13_51/original_patch";

Apply RCU artifact with patch "/u01/app/oracle/Middleware13c/.omspatcher_storage/25292154_Jan_21_2017_23_04_52/original_patch";

Apply RCU artifact with patch "/u01/app/oracle/Middleware13c/.omspatcher_storage/25303753_Jan_13_2017_22_35_20/original_patch";

Do you want to proceed? [y|n]

User Responded with: Y

Applying sub-patch(es) "25118889,25291362,25292154,25292157,25292163,25303753,25305707,25310689,25310724"

Please monitor log file: /u01/app/oracle/Middleware13c/cfgtoollogs/opatch/opatch2017-06-30_10-32-44AM_1.log

Updating repository with RCU reference file "/u01/app/oracle/Middleware13c/.omspatcher_storage/25291362_Jan_24_2017_07_13_51/original_patch" for plugin home "/u01/app/oracle/Middleware13c/plugins/oracle.sysman.db.oms.plugin_13.2.1.0.0"

Updating repository with RCU reference file "/u01/app/oracle/Middleware13c/.omspatcher_storage/25292154_Jan_21_2017_23_04_52/original_patch" for plugin home "/u01/app/oracle/Middleware13c/plugins/oracle.sysman.vi.oms.plugin_13.2.1.0.0"

......

Registering service "OutOfBoxRole" with register file "/u01/app/oracle/Middleware13c/plugins/oracle.sysman.db.oms.plugin_13.2.1.0.0/metadata/security/OutOfBoxRoles/dbSvcOOBRoles.xml" for plugin id as "oracle.sysman.db"...

Please monitor log file: /u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/2017-06-30_10-32-35AM_SystemPatch_25362912_1/emctl_register_OutOfBoxRole_2017-06-30_10-56-30AM.log

Complete Summary

================

All log file names referenced below can be accessed from the directory "/u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/2017-06-30_10-32-35AM_SystemPatch_25362912_1"

Patching summary:

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

Binaries of the following sub-patch(es) have been applied successfully:

Featureset Sub-patches Log file

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

oracle.sysman.top.oms_13.2.0.0.0 25118889,25291362,25292154,25292157,25292163,25303753,25305707,25310689,25310724 25118889,25291362,25292154,25292157,25292163,25303753,25305707,25310689,25310724_opatch2017-06-30_10-32-44AM_1.log

The following sub-patches are incompatible with components installed in the OMS system:

25105054,25359607

Deployment summary:

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

The following artifact(s) have been successfully deployed:

Artifacts Log file

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

SQL rcu_applypatch_original_patch_2017-06-30_10-37-32AM.log

SQL rcu_applypatch_original_patch_2017-06-30_10-37-51AM.log

SQL rcu_applypatch_original_patch_2017-06-30_10-37-59AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-38-08AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-39-30AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-40-12AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-40-21AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-40-32AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-40-41AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-40-49AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-40-58AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-41-09AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-41-18AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-41-26AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-41-35AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-41-44AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-41-52AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-41-59AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-42-07AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-42-15AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-42-22AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-42-29AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-42-37AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-42-44AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-42-55AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-43-03AM.log

MRS-targetType emctl_register_targetType_2017-06-30_10-43-15AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-43-24AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-43-49AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-43-59AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-44-07AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-44-14AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-44-22AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-44-28AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-44-35AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-44-46AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-44-53AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-01AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-08AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-14AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-21AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-27AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-33AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-39AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-46AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-53AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-45-59AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-46-07AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-46-14AM.log

MRS-default_collection emctl_register_default_collection_2017-06-30_10-46-22AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-46-29AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-46-41AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-46-53AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-46-59AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-47-07AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-47-15AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-47-23AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-47-30AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-47-37AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-47-44AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-47-52AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-00AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-06AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-14AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-20AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-27AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-33AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-41AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-49AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-48-56AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-49-03AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-49-11AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-49-17AM.log

MRS-storeTargetType emctl_register_storeTargetType_2017-06-30_10-49-27AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-49-35AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-49-47AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-49-54AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-01AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-08AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-15AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-22AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-30AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-36AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-44AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-51AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-50-58AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-51-09AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-51-17AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-51-25AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-51-33AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-51-42AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-51-51AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-51-59AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-52-08AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-52-15AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-52-23AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-52-30AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-52-37AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-52-44AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-52-53AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-53-02AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-53-08AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-53-15AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-53-22AM.log

MRS-procedures emctl_register_procedures_2017-06-30_10-53-29AM.log

MRS-swlib emctl_register_swlib_2017-06-30_10-53-35AM.log

MRS-swlib emctl_register_swlib_2017-06-30_10-54-00AM.log

MRS-swlib emctl_register_swlib_2017-06-30_10-54-18AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-54-27AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-54-33AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-54-41AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-54-50AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-54-55AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-55-01AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-55-07AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-55-13AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-55-19AM.log

MRS-systemStencil emctl_register_systemStencil_2017-06-30_10-55-24AM.log

MRS-omsPropertyDef emctl_register_omsPropertyDef_2017-06-30_10-55-30AM.log

MRS-omsPropertyDef emctl_register_omsPropertyDef_2017-06-30_10-55-37AM.log

MRS-OPCServicemetrics emctl_register_OPCServicemetrics_2017-06-30_10-55-42AM.log

MRS-relocate emctl_register_relocate_2017-06-30_10-55-49AM.log

MRS-jobTypes emctl_register_jobTypes_2017-06-30_10-55-54AM.log

MRS-jobTypes emctl_register_jobTypes_2017-06-30_10-56-03AM.log

MRS-jobTypes emctl_register_jobTypes_2017-06-30_10-56-11AM.log

MRS-jobTypes emctl_register_jobTypes_2017-06-30_10-56-17AM.log

MRS-TargetPrivilege emctl_register_TargetPrivilege_2017-06-30_10-56-24AM.log

MRS-OutOfBoxRole emctl_register_OutOfBoxRole_2017-06-30_10-56-30AM.log

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

The following warnings have occurred during OPatch execution:

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

OMSPatcher Session completed with warnings.

Log file location: /u01/app/oracle/Middleware13c/cfgtoollogs/omspatcher/25362912/omspatcher_2017-06-30_10-32-45AM_deploy.log

OMSPatcher completed with warnings.

[oracle@oem250 25362912]$

Once patch is applied, start the OMS

[oracle@oem250 25362912]$ emctl start oms

Oracle Enterprise Manager Cloud Control 13c Release 2

Starting Oracle Management Server...

WebTier Successfully Started

Oracle Management Server Successfully Started

Oracle Management Server is Up

JVMD Engine is Up

Starting BI Publisher Server ...

BI Publisher Server Already Started

BI Publisher Server is Up

[oracle@oem250 25362912]$ emctl status oms -details

Oracle Enterprise Manager Cloud Control 13c Release 2

Enter Enterprise Manager Root (SYSMAN) Password :

Console Server Host : oem250.ora.com

HTTP Console Port : 7788

HTTPS Console Port : 7802

HTTP Upload Port : 4889

HTTPS Upload Port : 4903

EM Instance Home : /u01/app/oracle/gc_inst1/em/EMGC_OMS1

OMS Log Directory Location : /u01/app/oracle/gc_inst1/em/EMGC_OMS1/sysman/log

OMS is not configured with SLB or virtual hostname

Agent Upload is locked.

OMS Console is locked.

Active CA ID: 1

Console URL: https://oem250.ora.com:7802/em

Upload URL: https://oem250.ora.com:4903/empbs/upload

WLS Domain Information

Domain Name : GCDomain

Admin Server Host : oem250.ora.com

Admin Server HTTPS Port: 7102

Admin Server is RUNNING

Oracle Management Server Information

Managed Server Instance Name: EMGC_OMS1

Oracle Management Server Instance Host: oem250.ora.com

WebTier is Up

Oracle Management Server is Up

JVMD Engine is Up

BI Publisher Server Information

BI Publisher Managed Server Name: BIP

BI Publisher Server is Up

BI Publisher HTTP Managed Server Port : 9701

BI Publisher HTTPS Managed Server Port : 9803

BI Publisher HTTP OHS Port : 9788

BI Publisher HTTPS OHS Port : 9851

BI Publisher is locked.

BI Publisher Server named 'BIP' running at URL: https://oem250.ora.com:9851/xmlpserver

BI Publisher Server Logs: /u01/app/oracle/gc_inst1/user_projects/domains/GCDomain/servers/BIP/logs/

BI Publisher Log : /u01/app/oracle/gc_inst1/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log

Validate the Applied Patch

[oracle@oem250 25362912]$ /u01/app/oracle/Middleware13c/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 13.9.1.3.0

Oracle Home : /u01/app/oracle/Middleware13c

Central Inventory : /u02/app/oraInventory

from : /u01/app/oracle/Middleware13c/oraInst.loc

OPatch version : 13.9.1.3.0

OUI version : 13.9.1.0.0

Log file location : /u01/app/oracle/Middleware13c/cfgtoollogs/opatch/opatch2017-06-30_11-11-48AM_1.log

OPatch detects the Middleware Home as "/u01/app/oracle/Middleware13c"

Lsinventory Output file location : /u01/app/oracle/Middleware13c/cfgtoollogs/opatch/lsinv/lsinventory2017-06-30_11-11-48AM.txt

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

Local Machine Information::

Hostname: oem250.ora.com

ARU platform id: 226

ARU platform description:: Linux_AMD64

Interim patches (30) :

Patch 25310724 : applied on Fri Jun 30 10:37:22 IST 2017

Unique Patch ID: -1485059321

Patch description: "EM Exadata Plugin Bundle Patch 13.2.1.0.170131"

Created on 21 Jan 2017, 20:28:41 hrs PST8PDT

Bugs fixed:

25310724, 25091814, 23562422, 25168123, 25150645, 24908610, 24682259

25070305, 23643366, 25112359, 24976467, 25426955

Patch 25310689 : applied on Fri Jun 30 10:37:16 IST 2017

Unique Patch ID: -1484286138

Patch description: "EM Cloud Plugin Bundle Patch 13.2.1.0.170131"

Created on 12 Jan 2017, 21:42:18 hrs PST8PDT

Bugs fixed:

25310689, 24613025, 23482786, 25176842

Patch 25305707 : applied on Fri Jun 30 10:37:06 IST 2017

Unique Patch ID: -1484289138

Patch description: "EM CFW Plugin Bundle Patch 13.2.1.0.170131"

Created on 12 Jan 2017, 22:32:18 hrs PST8PDT

Bugs fixed:

25305707, 25298526

Patch 25303753 : applied on Fri Jun 30 10:37:00 IST 2017

Unique Patch ID: -1484375720

Patch description: "EM SMF Plugin Bundle Patch 13.2.1.0.170131"

Created on 13 Jan 2017, 22:35:20 hrs PST8PDT

Bugs fixed:

25303753, 25301587, 20546123

Patch 25292163 : applied on Fri Jun 30 10:36:54 IST 2017

Unique Patch ID: -1484352157

Patch description: "EM SI Plugin Bundle Patch 13.2.1.0.170131"

Created on 13 Jan 2017, 16:02:37 hrs PST8PDT

Bugs fixed:

25292163, 24785360, 25118880, 24511923, 24959801

Patch 25292157 : applied on Fri Jun 30 10:36:46 IST 2017

Unique Patch ID: -1485093406

Patch description: "EM FMW Plugin Bundle Patch 13.2.1.0.170131"

Created on 22 Jan 2017, 05:56:46 hrs PST8PDT

Bugs fixed:

25292157, 25361441, 23587701, 25291263, 25298850, 25175594, 23720864

25237633, 25427398, 25105061, 25099380, 25095346, 24680049, 23609278

24706723, 24675946, 24760891, 24350834, 24841106, 23740703

Patch 25292154 : applied on Fri Jun 30 10:36:37 IST 2017

Unique Patch ID: -1485068692

Patch description: "EM OVI Plugin Bundle Patch 13.2.1.0.170131"

Created on 21 Jan 2017, 23:04:52 hrs PST8PDT

Bugs fixed:

25292154, 25362204, 25236809, 25333426, 25202328, 22818714, 25180438

25428304, 25105073, 24333993, 24717618, 24334006, 24334014, 24618145

24505172, 24841122, 24717470

Patch 25291362 : applied on Fri Jun 30 10:36:29 IST 2017

Unique Patch ID: -1485270831

Patch description: "EM DB Plugin Bundle Patch 13.2.1.0.170131"

Created on 24 Jan 2017, 07:13:51 hrs PST8PDT

Bugs fixed:

25291362, 25443348, 25361430, 25340600, 25334003, 25331825, 24742759

25308711, 25176739, 25098485, 25295869, 25295935, 25298500, 24695873

25294782, 22709047, 24822934, 25170293, 24831549, 24573192, 23629445

24360223, 24607089, 24961823, 21899436, 25427621, 25105047, 24670458

25122067, 25150258, 25142263, 24669985, 24429946, 24961081, 25119217

25057020, 24661986, 24533474, 24845223, 22957131, 23317489, 25088934

24364595, 24953120, 24803101, 24576809, 24676840, 22330235, 24976851

24785236, 24750917, 24705223, 24914115, 24839755, 22962076, 22962930

24290067, 24326779, 24402161, 25315582, 24841028, 24583131, 23550674

Patch 25118889 : applied on Fri Jun 30 10:36:11 IST 2017

Unique Patch ID: -1481118499

Patch description: "EM VT Plugin Bundle Patch 13.2.1.0.161231"

Created on 7 Dec 2016, 05:48:19 hrs PST8PDT

Bugs fixed:

25118889, 24452838, 24949074

Patch 24450351 : applied on Wed Oct 26 00:57:42 IST 2016

Unique Patch ID: 20496871

Patch description: "One-off"

Created on 12 Aug 2016, 22:22:01 hrs UTC

Bugs fixed:

19030178, 24011099

This patch overlays patches:

20741228

This patch needs patches:

20741228

as prerequisites

Patch 23519804 : applied on Wed Oct 26 00:57:36 IST 2016

Unique Patch ID: 20275609

Patch description: "One-off"

Created on 14 Jun 2016, 15:24:56 hrs PST8PDT

Bugs fixed:

19311376, 22188506, 18477237, 22744088, 21341093, 18463773, 19512148

Patch 22065592 : applied on Wed Oct 26 00:57:09 IST 2016

Unique Patch ID: 19475726

Patch description: "One-off"

Created on 21 Oct 2015, 07:49:08 hrs PST8PDT

Bugs fixed:

18383525, 17885478, 20555876, 19914499, 19451617, 18941343, 18561941

19453923, 18897951, 20503882, 19531350, 18686661, 18866433, 19899388

19525853, 20833923, 19462789, 21280268, 16052571, 19889786, 21114997

19973915, 19292195, 20020330, 18922387, 18472289, 21524870, 18090947

19933990, 19663878, 20262541, 20509175, 14672694, 18744399, 19044876

20990401, 18697986, 20687540, 16463045, 20526373, 18614741, 19357552

21182975, 21115193, 20679193, 19645748, 21076750, 20881649, 18636197

18537665, 18638872, 18845424, 20425852, 20806435, 18756770, 18940245

20363226, 19921764, 19952825, 18843495, 20571779, 20951458, 19974995

Patch 21252292 : applied on Wed Oct 26 00:56:33 IST 2016

Unique Patch ID: 19206337

Patch description: "One-off"

Created on 6 Aug 2015, 23:55:53 hrs PST8PDT

Bugs fixed:

21252292

Patch 21243471 : applied on Wed Oct 26 00:56:30 IST 2016

Unique Patch ID: 19056556

Patch description: "One-off"

Created on 15 Sep 2015, 18:17:28 hrs PST8PDT

Bugs fixed:

20613957, 19703527, 19883023

Patch 20882747 : applied on Wed Oct 26 00:56:18 IST 2016

Unique Patch ID: 19064183

Patch description: "One-off"

Created on 3 Jul 2015, 06:42:30 hrs PST8PDT

Bugs fixed:

20882747

Patch 20758863 : applied on Wed Oct 26 00:56:11 IST 2016

Unique Patch ID: 18985888

Patch description: "One-off"

Created on 2 Jun 2015, 07:19:42 hrs PST8PDT

Bugs fixed:

20758863

Patch 20442348 : applied on Wed Oct 26 00:56:08 IST 2016

Unique Patch ID: 19368787

Patch description: "One-off"

Created on 30 Sep 2015, 03:52:52 hrs PST8PDT

Bugs fixed:

20442348

Patch 20222451 : applied on Wed Oct 26 00:56:04 IST 2016

Unique Patch ID: 18777978

Patch description: "One-off"

Created on 12 May 2015, 05:10:36 hrs PST8PDT

Bugs fixed:

20222451

Patch 20022048 : applied on Wed Oct 26 00:56:01 IST 2016

Unique Patch ID: 18432406

Patch description: "One-off"

Created on 12 Jun 2015, 07:24:17 hrs PST8PDT

Bugs fixed:

20022048

Patch 19982906 : applied on Wed Oct 26 00:55:58 IST 2016

Unique Patch ID: 18562707

Patch description: "One-off"

Created on 6 Feb 2015, 10:37:02 hrs PST8PDT

Bugs fixed:

19982906

Patch 19953516 : applied on Wed Oct 26 00:55:55 IST 2016

Unique Patch ID: 18426451

Patch description: "One-off"

Created on 2 Jan 2015, 03:46:32 hrs PST8PDT

Bugs fixed:

19953516

Patch 19901079 : applied on Wed Oct 26 00:55:44 IST 2016

Unique Patch ID: 18908837

Patch description: "One-off"

Created on 11 May 2015, 02:40:27 hrs PST8PDT

Bugs fixed:

19901079

Patch 19879223 : applied on Wed Oct 26 00:55:41 IST 2016

Unique Patch ID: 18471308

Patch description: "One-off"

Created on 2 Feb 2015, 11:04:41 hrs PST8PDT

Bugs fixed:

19879223

Patch 19730967 : applied on Wed Oct 26 00:55:32 IST 2016

Unique Patch ID: 18262783

Patch description: "One-off"

Created on 12 Nov 2014, 12:51:40 hrs Asia/Calcutta

Bugs fixed:

19730967

Patch 19345252 : applied on Wed Oct 26 00:55:22 IST 2016

Unique Patch ID: 18260320

Patch description: "One-off"

Created on 1 Jun 2015, 20:28:24 hrs PST8PDT

Bugs fixed:

19345252

Patch 18974665 : applied on Wed Oct 26 00:55:18 IST 2016

Unique Patch ID: 18864521

Patch description: "One-off"

Created on 28 Apr 2015, 20:41:41 hrs Asia/Calcutta

Bugs fixed:

18974665

Patch 18836900 : applied on Wed Oct 26 00:55:14 IST 2016

Unique Patch ID: 18085119

Patch description: "One-off"

Created on 25 Sep 2014, 12:03:11 hrs Asia/Calcutta

Bugs fixed:

18836900

Patch 18814458 : applied on Wed Oct 26 00:55:02 IST 2016

Unique Patch ID: 17839335

Patch description: "One-off"

Created on 10 Jul 2014, 05:17:13 hrs PST8PDT

Bugs fixed:

18814458

Patch 23527146 : applied on Wed Oct 26 00:53:11 IST 2016

Unique Patch ID: 20381077

Patch description: "One-off"

Created on 6 Jul 2016, 23:12:09 hrs PST8PDT

Bugs fixed:

23527146

Patch 20741228 : applied on Wed Oct 26 00:53:05 IST 2016

Unique Patch ID: 18985724

Patch description: "JDBC 12.1.3.1 BP1"

Created on 2 Jun 2015, 05:57:41 hrs PST8PDT

Bugs fixed:

20741228

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

OPatch succeeded.

If you feel like some component is not working after applying patch then you can rollback the patch using below approach.

Deinstalling the System Patch

To deinstall the patch, follow these steps:

1. Navigate to the <PATCH_TOP_DIR>/25362912 directory:

$ cd <PATCH_TOP_DIR>/25362912

2. Deinstall the patch by running the following command:

On Unix:

$ omspatcher rollback -id
25292154,25292157,25310689,25310724,25359607,25305707,25292163,25303753,25291362,25105054,25118889
-property_file <location of property file>

On Windows:

$ omspatcher rollback -id
25292154,25292157,25310689,25310724,25359607,25305707,25292163,25303753,25291362,25105054,25118889
-property_file <location of property file>

For information on how to retrieve the list of sub-patches of the System patch, see Section 5."

Note:

For single OMS environment, opatchauto will run the patching steps.

For multi-OMS environment, opatchauto provides instructions that you need to follow in your environment to complete the patch deinstall process.
For stand by OMS, opatchauto prints a list of steps that you need to perform to complete the patching process.”

Start the OMS by after applying patch.

[oracle@oem250 25362912]$

emctl
start oms

Oracle Certified Master's - Blogs

Home

Tuesday, July 4, 2017

SYSTEM PATCH/PSU FOR OEM 13cR2

Deinstalling the System Patch

No comments:

Post a Comment