Tags

11g (5) 12c (6) 18c (3) 19c (4) ASM (1) Critical Patch (11) Data Pump (1) Dataguard (9) Diverse (3) GRID (7) GitLab (2) Linux (8) OEM (2) ORA Errors (13) Oracle (12) RMAN (4)
Showing posts with label Apply PSU to the OEM 13c. Show all posts
Showing posts with label Apply PSU to the OEM 13c. Show all posts

Saturday, March 7, 2020

Apply PSU to the OEM 13c



Apply PSU to the OEM 13c

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment.

PSU apply to your Enterprise Manager Cloud Control 13c
How to apply patch (PSU) in Oracle Enterprise Manager 13c
1. Download the latest PSU in the MOS (My Oracle Support)
2. Download the required OPatch and OMSPatcher.

We can download the latest OPatch from the following link.
"https://updates.oracle.com/download/6880880.html"
I have downloaded the following patch Version “OPatch 13.9.3.3.0"
 p6880880_139000_Generic.zip

NOTE: 

There is no mechanism to revert only OPatch to an older version. That is why make sure that you backup your middleware home.
Make sure OMS is stopped.
'<ORACLE_HOME>/bin/emctl stop oms -all'
/u01/oracle/app/home/middleware/bin/emctl stop oms -all

export ORACLE_HOME=<EM_MW_HOME>
$ORACLE_HOME/oracle_common/jdk/bin/java –jar <PATCH_HOME>/6880880/opatch_generic.jar -silent oracle_home=$ORACLE_HOME
...
...
Logs successfully copied to /oracle/app/oraInventory/logs.

To validate the installation:
cd <ORACLE_HOME>/OPatch    
$ ./opatch version
OPatch Version: 13.9.3.3.0
OPatch succeeded.

opatch lspatches

Download the latest OMSPatcher Version.
“https://updates.oracle.com/download/19999993.html”
Unzip the new OMSPatcher version.

cd /u01/oracle/app/home/middleware/
mv OMSPatcher OMSPatcher_old
unzip /oracle/download/OPatch_middleware/p19999993_133000_Generic.zip -d /u01/oracle/app/home/middleware

Validate OMSPatcher version.
$ORACLE_HOME/OMSPatcher/omspatcher version
OMSPatcher Version: 13.8.0.0.3
OPlan Version: 12.2.0.1.6
OsysModel build: Tue Sep 04 18:15:05 PDT 2018
OMSPatcher succeeded.

Upgrade OPatch on Agent Home.
export ORACLE_HOME=<AGENT_BASE_DIR>/agent_13.x.0.0.0
$ORACLE_HOME/jdk/bin/java -jar <PATCH_HOME>/6880880/opatch_generic.jar -silent oracle_home=$ORACLE_HOME
...
...
Logs successfully copied to /oracle/app/oraInventory/logs.

Generating the property file.

Note: You will be asked to enter the credentials for the user: weblogic (Admin Server).
cd $ORACLE_HOME/OMSPatcher/wlskeys
$ORACLE_HOME/OMSPatcher/wlskeys/createkeys.sh -oh $ORACLE_HOME -location $ORACLE_HOME/OMSPatcher/wlskeys
 $ORACLE_HOME/OMSPatcher/wlskeys/createkeys.sh -oh /u01/oracle/app/home/middleware -location /u01/oracle/app/home/middleware/OMSPatcher/wlskeys

Unzip the file and check prerequisites.
Download Base Platform OMS home.
EM BP Patch Set Update 13.3.0.0.200114 Patch 30592540
p30592540_133000_Generic.zip

We need to know required hostname and port. We can get the correct detail as follow.
/u01/oracle/app/home/middleware/bin/emctl status oms -details
 ...
 ...
WLS Domain Information
Domain Name            : GCDomain
Admin Server Host      : oradbprd01.th.com
Admin Server HTTPS Port: 7102
...
...

Create property file:
more property_file
AdminServerURL=t3s:// oradbprd01.th.com:7102
AdminConfigFile=/u01/oracle/app/home/middleware/OMSPatcher/wlskeys/config
AdminKeyFile=/u01/oracle/app/home/middleware/OMSPatcher/wlskeys/key
 
cd <PATCH_TOP_DIR>/30592540
/u01/oracle/app/home/middleware/OMSPatcher/omspatcher apply -analyze -property_file /u01/oracle/app/home/middleware/OMSPatcher/wlskeys OMSPatcher.OMS_DISABLE_HOST_CHECK=true

If you get this error.
OMSPatcher failed with error code 231

Try with the following command with –bitonly option: OMS (Doc ID 2257840.1)

/u01/oracle/app/home/middleware/OMSPatcher/omspatcher apply -bitonly -analyze -property_file /u01/oracle/app/home/middleware/OMSPatcher/wlskeys/ OMSPatcher.OMS_DISABLE_HOST_CHECK=true

Stopping and Applying the patch in the OMS Server.
$ORACLE_HOME/bin/emctl stop oms

/u01/oracle/app/home/middleware/OMSPatcher/omspatcher apply -bitonly -property_file /u01/oracle/app/home/middleware/OMSPatcher/wlskeys/ OMSPatcher.OMS_DISABLE_HOST_CHECK=true

OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

OMSPatcher version : 13.8.0.0.3
OUI version        : 13.9.1.0.0
Running from       : /u01/oracle/app/home/middleware
Log file location  : /u01/oracle/app/home/middleware/cfgtoollogs/omspatcher/opatch2020-02-07_16-41-50PM_1.log

OMSPatcher log file: /u01/oracle/app/home/middleware/cfgtoollogs/omspatcher/30592540/omspatcher_2020-02-07_16-41-53PM_deploy.log

WARNING: OMSPatcher has been invoked with 'bitonly' option but the System patch provided has deployment metadata.
Invocation in 'bitonly' mode will prevent OMSPatcher from deploying artifacts.

Do you want to proceed? [y|n]
y
User Responded with: Y

Running apply prerequisite checks for sub-patch(es) "30592540" and Oracle Home "/u01/oracle/app/home/middleware"...
Sub-patch(es) "30592540" are successfully analyzed for Oracle Home "/u01/oracle/app/home/middleware"

To continue, OMSPatcher will do the following:
[Patch and deploy artifacts]   :

Do you want to proceed? [y|n]
y
User Responded with: Y

Applying sub-patch(es) "30592540"
Please monitor log file: /u01/oracle/app/home/middleware/cfgtoollogs/opatch/opatch2020-02-07_16-41-53PM_1.log

Complete Summary
================
All log file names referenced below can be accessed from the directory "/u01/oracle/app/home/middleware/cfgtoollogs/omspatcher/2020-02-07_16-41-50PM_SystemPatch_30592540_1"

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

                        Featureset   Sub-patches                                     Log file
                        ----------   -----------                                     --------
  oracle.sysman.top.oms_13.3.0.0.0      30592540   30592540_opatch2020-02-07_16-41-53PM_1.log
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1)  OMSPatcher has been invoked with 'bitonly' option but the System patch provided has deployment metadata.
Invocation in 'bitonly' mode will prevent OMSPatcher from deploying artifacts.
--------------------------------------------------------------------------------
OMSPatcher Session completed with warnings.
Log file location: /u01/oracle/app/home/middleware/cfgtoollogs/omspatcher/30592540/omspatcher_2020-02-07_16-41-53PM_deploy.log

OMSPatcher completed with warnings.

Start OMS Server after apply patch.

$ORACLE_HOME/bin/emctl start oms

Patch Installation is completed.



physical standby without duplicate command

physical standby without duplicate command create a physical standby database using RMAN without using duplicate command PURPOSE:   All docu...