DBA Hub

📋Steps in this guide1/10

Apply Patch on OMS - Bright DBA

Apply Oracle Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718 for Oracle Management Service

oracle upgradeintermediate
by OracleDba
13 views
1

Overview

Apply Oracle Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718 for Oracle Management Service 0. Overview Goal: We are going to apply PSU 25904755 (Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718)

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Goal: We are going to apply PSU 25904755 (Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718)
[oracle@rac1 ~]$
/u01/app/oracle/mwroem131/bin/emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
<--- Enter password
Console Server Host        : rac1.rajasekhar.com
HTTP Console Port          : 7788
HTTPS Console Port         : 7803
HTTP Upload Port           : 4889
HTTPS Upload Port          : 4903
EM Instance Home           : /u01/app/oracle/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /u01/app/oracle/gc_inst/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://rac1.rajasekhar.com:7803/em
Upload URL: https://rac1.rajasekhar.com:4903/empbs/upload

WLS Domain Information
Domain Name            : GCDomain
Admin Server Host      : rac1.rajasekhar.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: rac1.rajasekhar.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://rac1.rajasekhar.com:9851/xmlpserver
BI Publisher Server Logs: /u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/
BI Publisher Log        : /u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log
[oracle@rac1 ~]$
Prerequisites:
weblogic admin server URL(t3s://rac1.rajasekhar.com:7102):>
weblogic admin server username(weblogic):>
weblogic admin server password:>
2

Section 2

/u01/app/oracle/mwroem131/bin/emctl status oms -details Prerequisites: 1. Environment OMS Home : /u01/app/oracle/mwroem131

Code/Command (click line numbers to comment):

1
2
3
4
Platform   	: Linuxx86_64
Server IP 	: 192.168.2.101
OEM Version     : 13c Release 1
OMS Home	: /u01/app/oracle/mwroem131
3

Section 3

2. Download the patch from MOS 3. Upgrade OMSPatcher

Code/Command (click line numbers to comment):

1
2
3
https://updates.oracle.com/download/25904755.html

http://www.br8dba.com/upgrade-omspatcher/
4

Section 4

4. List patches which were applied /u01/app/oracle/mwroem131/OMSPatcher/omspatcher lspatches -oh /u01/app/oracle/mwroem131 -- Looks like no PSU applied on OMS home. 5. Unzip patch

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
[oracle@rac1 ~]$
export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$
/u01/app/oracle/mwroem131/OMSPatcher/omspatcher
lspatches
-oh /u01/app/oracle/mwroem131
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       : /u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_18-55-36PM_1.log

Component Name/Version                            Component Type      System Patch        (Sub)-Patches       Patch Description
------------------------                          -------------       -------------       --------------      ------------------
oracle.jrf.adfrt/12.1.3.0.0                       Core                N/A                 22065592            One-off

oracle.webcenter.pageeditor/12.1.3.0.0            Core                N/A                 20882747            One-off

oracle.bi.xdo/12.1.3.0.0                          Core                N/A                 21839888            One-off

oracle.wls.clients/12.1.3.0.0                     Core                N/A                 19953516            One-off

oracle.xdk.jrf.jaxp/12.1.3.0.0                    Core                N/A                 19345252            One-off

oracle.wls.libraries/12.1.3.0.0                   Core                N/A                 21252292            One-off
                                                                      N/A                 21243471            One-off
                                                                      N/A                 18836900            One-off
                                                                      N/A                 19879223            One-off
                                                                      N/A                 19730967            One-off
                                                                      N/A                 20758863            One-off
                                                                      N/A                 19953516            One-off

oracle.xdk.jrf.xmlparserv2/12.1.3.0.0             Core                N/A                 19345252            One-off

oracle.fmwconfig.common.wls.shared/12.1.          Core                N/A                 18974665            One-off
3.0.0

oracle.bali.cabo/12.1.3.0.0                       Core                N/A                 18814458            One-off

oracle.ldap.rsf/12.1.3.0.0                        Core                N/A                 20022048            One-off

oracle.fmwconfig.common.shared/12.1.3.0.          Core                N/A                 18974665            One-off
0

oracle.ohs2/12.1.3.0.0                            Core                N/A                 19901079            One-off
                                                                      N/A                 20222451            One-off

oracle.wlsplugins/12.1.3.0.0                      Core                N/A                 20442348            One-off

oracle.wls.core.app.server/12.1.3.0.0             Core                N/A                 19982906            One-off

oracle.wls.workshop.code.completion.supp          Core                N/A                 19953516            One-off
ort/12.1.3.0.0


NOTE: N/A indicates that the subpatch mentioned in the Subpatches column was applied as a one-off patch and not as part of any system patch.

OMSPatcher has saved inventory details for the above component at below location.
"/u01/app/oracle/mwroem131"

For more details on installed patch(es), Please do "/u01/app/oracle/mwroem131/OPatch/opatch lsinventory -details"

OMSPatcher succeeded.
[oracle@rac1 ~]$
-- Looks like no PSU applied on OMS home.
5

Section 5

5. Unzip patch 6. Patch Verification using analyze -- No need to shutdown OMS

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
[oracle@rac1 MWPSU]$
pwd
/u01/app/backup/MWPSU
[oracle@rac1 MWPSU]$
[oracle@rac1 MWPSU]$
unzip p25904755_131000_Generic.zip
[oracle@rac1 MWPSU]$ ls -ltr
total 36076
drwxr-x---. 4 oracle oinstall       95 Jun 12  2017
25904755
-rw-r--r--. 1 oracle oinstall 36940116 Jun  2 18:50 p25904755_131000_Generic.zip
[oracle@rac1 MWPSU]$

-- No need to shutdown OMS
[oracle@rac1 ~]$
export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$
/u01/app/oracle/mwroem131/OMSPatcher/omspatcher apply /u01/app/backup/MWPSU/25904755 -
analyze
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       : /u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_19-05-18PM_1.log

OMSPatcher log file: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-06-05PM_analyze.log

Please enter OMS weblogic admin server
URL(t3s://rac1.rajasekhar.com:7102):>
Please enter OMS weblogic admin server username(weblogic):>
Please enter OMS weblogic admin server password:>
Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "25904755" and Oracle Home "/u01/app/oracle/mwroem131"...
Sub-patch(es) "25904755" are successfully analyzed for Oracle Home "/u01/app/oracle/mwroem131"
Complete Summary
================


All log file names referenced below can be accessed from the directory "/u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/2019-06-02_19-05-18PM_SystemPatch_25904755_1"

Prerequisites analysis summary:
-------------------------------
The following sub-patch(es) are applicable:
Featureset   Sub-patches                                          Log file
             ----------   -----------                                          --------
oracle.sysman.top.oms      25904755   25904755_ApplyPrereq2019-06-02_19-09-06PM_2.log
Log file location: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-06-05PM_analyze.log
OMSPatcher succeeded.
[oracle@rac1 ~]$
6

Section 6

analyze 7. Stop OMS /u01/app/oracle/mwroem131/bin/emctl stop oms 8. Apply Patch

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
[oracle@rac1 ~]$
export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$
/u01/app/oracle/mwroem131/bin/emctl stop oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
[oracle@rac1 ~]$
7

Section 7

8. Apply Patch /u01/app/oracle/mwroem131/OMSPatcher/omspatcher apply Please enter OMS weblogic admin server URL(t3s://rac1.rajasekhar.com:7102):> Please enter OMS weblogic admin server username(weblogic):> Please enter OMS weblogic admin server password:> y <--- Applying sub-patch "25904755 " to component "oracle.sysman.top.oms" and version "13.1.0.0.0"...

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
[oracle@rac1 25904755]$ pwd
/u01/app/backup/MWPSU/25904755
[oracle@rac1 25904755]$
/u01/app/oracle/mwroem131/OMSPatcher/omspatcher apply
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       : /u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_19-20-08PM_1.log

OMSPatcher log file: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-20-36PM_deploy.log
Please enter OMS weblogic admin server
URL(t3s://rac1.rajasekhar.com:7102):>
Please enter OMS weblogic admin server username(weblogic):>
Please enter OMS weblogic admin server password:>
Configuration Validation: Success
Running apply prerequisite checks for sub-patch(es) "25904755" and Oracle Home "/u01/app/oracle/mwroem131"...
Sub-patch(es) "25904755" are successfully analyzed for Oracle Home "/u01/app/oracle/mwroem131"

To continue, OMSPatcher will do the following:
[Patch and deploy artifacts]   : Apply sub-patch(es) [ 25904755 ] to component "oracle.sysman.top.oms" and version "13.1.0.0.0";
                                 Apply RCU artifact with patch "/u01/app/oracle/mwroem131/.omspatcher_storage/25904755_Jun_12_2017_03_40_04/original_patch";
                                 Register MRS artifact "targetType";
                                 Register MRS artifact "storeTargetType";
                                 Register MRS artifact "default_collection";
                                 Register MRS artifact "swlib"
Do you want to proceed? [y|n]
y <---
User Responded with: Y
Applying sub-patch "25904755 " to component "oracle.sysman.top.oms" and version "13.1.0.0.0"...
Updating repository with RCU reference file "/u01/app/oracle/mwroem131/.omspatcher_storage/25904755_Jun_12_2017_03_40_04/original_patch"

Registering service "targetType" with register file "/u01/app/oracle/mwroem131/sysman/metadata/targetType/oldVersions/host/12.1.0.5/host.xml"...

Registering service "storeTargetType" with register file "/u01/app/oracle/mwroem131/sysman/metadata/targetType/oldVersions/host/12.1.0.5/host.xml"...

Registering service "default_collection" with register file "/u01/app/oracle/mwroem131/sysman/metadata/default_collection/oldVersions/host/12.1.0.5/host.xml"...

Registering service "swlib" with register file "/u01/app/oracle/mwroem131/sysman/metadata/swlib/patch"...

Complete Summary
================


All log file names referenced below can be accessed from the directory "/u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/2019-06-02_19-20-08PM_SystemPatch_25904755_1"

Patching summary:
-----------------
Binaries of the following sub-patch(es) have been applied successfully:
Featureset   Sub-patches                                     Log file
                        ----------   -----------                                     --------
oracle.sysman.top.oms_13.1.0.0.0      25904755   25904755_opatch2019-06-02_19-23-00PM_3.log
Deployment summary:
-------------------

The following artifact(s) have been successfully deployed:

               Artifacts                                                      Log file
               ---------                                                      --------
                     SQL       rcu_applypatch_original_patch_2019-06-02_19-24-36PM.log
          MRS-targetType           emctl_register_targetType_2019-06-02_19-27-11PM.log
     MRS-storeTargetType      emctl_register_storeTargetType_2019-06-02_19-27-38PM.log
  MRS-default_collection   emctl_register_default_collection_2019-06-02_19-28-13PM.log
               MRS-swlib                emctl_register_swlib_2019-06-02_19-28-35PM.log


Log file location: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-20-36PM_deploy.log
OMSPatcher succeeded.
[oracle@rac1 25904755]$
8

Section 8

Binaries of the following sub-patch(es) have been applied successfully: OMSPatcher succeeded. 9. List Patches /u01/app/oracle/mwroem131/OMSPatcher/omspatcher lspatches

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
[oracle@rac1 ~]$
export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$
/u01/app/oracle/mwroem131/OMSPatcher/omspatcher lspatches
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       :
/u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_19-29-59PM_1.log

Component Name/Version                            Component Type      System Patch        (Sub)-Patches       Patch Description
------------------------                          -------------       -------------       --------------      ------------------
oracle.sysman.top.oms/13.1.0.0.0                  Core                25904755
25904755
enterprise manager base platform - oms 13.1.0.0.170718 psu (generic)
oracle.jrf.adfrt/12.1.3.0.0                       Core                N/A                 22065592            One-off

oracle.webcenter.pageeditor/12.1.3.0.0            Core                N/A                 20882747            One-off

oracle.bi.xdo/12.1.3.0.0                          Core                N/A                 21839888            One-off

oracle.wls.clients/12.1.3.0.0                     Core                N/A                 19953516            One-off

oracle.xdk.jrf.jaxp/12.1.3.0.0                    Core                N/A                 19345252            One-off

oracle.wls.libraries/12.1.3.0.0                   Core                N/A                 21252292            One-off
                                                                      N/A                 21243471            One-off
                                                                      N/A                 18836900            One-off
                                                                      N/A                 19879223            One-off
                                                                      N/A                 19730967            One-off
                                                                      N/A                 20758863            One-off
                                                                      N/A                 19953516            One-off

oracle.xdk.jrf.xmlparserv2/12.1.3.0.0             Core                N/A                 19345252            One-off

oracle.fmwconfig.common.wls.shared/12.1.          Core                N/A                 18974665            One-off
3.0.0

oracle.bali.cabo/12.1.3.0.0                       Core                N/A                 18814458            One-off

oracle.ldap.rsf/12.1.3.0.0                        Core                N/A                 20022048            One-off

oracle.fmwconfig.common.shared/12.1.3.0.          Core                N/A                 18974665            One-off
0

oracle.ohs2/12.1.3.0.0                            Core                N/A                 19901079            One-off
                                                                      N/A                 20222451            One-off

oracle.wlsplugins/12.1.3.0.0                      Core                N/A                 20442348            One-off

oracle.wls.core.app.server/12.1.3.0.0             Core                N/A                 19982906            One-off

oracle.wls.workshop.code.completion.supp          Core                N/A                 19953516            One-off
ort/12.1.3.0.0


NOTE: N/A indicates that the subpatch mentioned in the Subpatches column was applied as a one-off patch and not as part of any system patch.

OMSPatcher has saved inventory details for the above component at below location.
"/u01/app/oracle/mwroem131"

For more details on installed patch(es), Please do "/u01/app/oracle/mwroem131/OPatch/opatch lsinventory -details"

OMSPatcher succeeded.
[oracle@rac1 ~]$
9

Section 9

oracle.sysman.top.oms/13.1.0.0.0 Core 25904755 25904755 enterprise manager base platform - oms 13.1.0.0.170718 psu (generic) 10. Start OMS /u01/app/oracle/mwroem131/bin/emctl start oms Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[oracle@rac1 ~]$
export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$
/u01/app/oracle/mwroem131/bin/emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
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@rac1 ~]$
10

Section 10

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!