Friday, August 23, 2024

13.5.0 Enterprise Manager Cloud Control Base Platform Monthly Release Update (RU) 23 - July 2024

Ref: 13.5.0 Enterprise Manager Cloud Control Base Platform Monthly Release Update (RU) 23 (Doc ID 3040236.1)

A. System Information

πŸ‘‰Database version
[oracle@monitor-db ~]$ opatch lspatches
36233263;Database Release Update : 19.23.0.0.240416 (36233263)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

OPatch succeeded.

πŸ‘‰OMS version
[oracle@monitor-app ~]$ . oms_env
[oracle@monitor-app ~]$ omspatcher lspatches


oracle.sysman.db.oms.plugin/13.5.1.0.0            Plugin              36335368            36329033            Oracle Enterprise Manager for Oracle Database 13c Release 5 Plug-in Update 22 (13.5.1.22) for Oracle Management Service

oracle.sysman.cfw.oms.plugin/13.5.1.0.0           Plugin              36335368            36329231            Oracle Enterprise Manager for Cloud Framework 13c Release 5 Plug-in Update 22 (13.5.1.22) for Oracle Management Service

oracle.sysman.xa.oms.plugin/13.5.1.0.0            Plugin              36335368            36329152            Oracle Enterprise Manager for Exadata 13c Release 5 Plug-in Update 22 (13.5.1.22) for Oracle Management Service

oracle.sysman.top.oms/13.5.0.0.0                  Core                36335368            36329009            Oracle Enterprise Manager 13c Release 5 Platform Update 22 (13.5.0.22) for Oracle Management Service

oracle.sysman.si.oms.plugin/13.5.1.0.0            Plugin              36335368            36329196            Oracle Enterprise Manager for Systems Infrastructure 13c Release 5 Plug-in Update 22 (13.5.1.22) for Oracle Management Service

oracle.sysman.emas.oms.plugin/13.5.1.0.0          Plugin              36335368            36329020            Oracle Enterprise Manager for Fusion Middleware 13c Release 5 Plug-in Update 22 (13.5.1.22) for Oracle Management Service

πŸ‘‰Agent version
[oracle@monitor-app ~]$ . agent_env 
[oracle@monitor-app ~]$ agentpatcher lspatches


oracle.sysman.si.agent.plugin/13.5.1.0.0          Plugin              36335371            36335417            Oracle Enterprise Manager for Systems Infrastructure 13c Release 5 Plug-in Update 22 (13.5.1.22) for Oracle Management Agent

oracle.sysman.top.agent/13.5.0.0.0                Core                36335371            36335374            Oracle Enterprise Manager 13c Release 5 Platform Update 22 (13.5.0.22) for Oracle Management Agent

πŸ‘‰OMSPatcher & OPatch version
[oracle@monitor-app ~]$ . oms_env 
[oracle@monitor-app ~]$ omspatcher version

OMSPatcher Version: 13.9.5.21.0
OPlan Version: 12.2.0.1.16
OsysModel build: Tue Apr 28 18:16:31 PDT 2020

OMSPatcher succeeded.

[oracle@monitor-app ~]$ opatch version
OPatch Version: 13.9.4.2.16

OPatch succeeded.

Ref
  • 13.5: How To Upgrade Enterprise Manager 13.5 Cloud Control OMSPatcher Utility to the Latest Version (Doc ID 2809842.1)
  • EM 13c: How To Upgrade Enterprise Manager 13.4 Cloud Control OMSPatcher Utility to the Latest Version (Doc ID 2646080.1)

B. Installing the Release Update - Traditional Patching - July 2024
Note: Patching RU 23 after patching Holistic Patch, so we do not need patching omspatcher and opatch

Because of patching RU 23 from RU 22, so we can bypass patching:
  • MLR Patch 35430934 (or its superset) which includes 32720458 and 33607709
  • Patch 34153238
  • Patch 31657681

🌞Start Oracle WebLogic Administration server ONLY
[oracle@monitor-app ~]$ . oms_env
[oracle@monitor-app ~]$ emctl stop oms –all
[oracle@monitor-app ~]$ emctl start oms -admin_only
[oracle@monitor-app ~]$ emctl status oms -details


🌞Creating a Property File
[oracle@monitor-app ~]$ . oms_env
[oracle@monitor-app ~]$ $ORACLE_HOME/OMSPatcher/wlskeys/createkeys.sh -oh /u01/app/oracle/middleware -location /home/oracle/encrypted


The oraclehome passed is valid.
The wls url is t3s://monitor-app.taolaobidao.com:7102

Please enter weblogic admin server username : weblogic
Please enter weblogic admin server password : 

The cfgFile is /home/oracle/encrypted/config
The keyFile is /home/oracle/encrypted/key

Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Fri Aug 23 11:03:23 ICT 2024
Storing WLS User configuration

Admin url: t3s://monitor-app.taolaobidao.com:7102
Admin Config File: /home/oracle/encrypted/config
Key File : /home/oracle/encrypted/key

Please enter weblogic admin server username :
Enter Admin user's password: 
Fri Aug 23 11:03:23 ICT 2024
Connecting to AdminServer
Connecting to t3s://monitor-app.taolaobidao.com:7102 with userid weblogic ...
<Aug 23, 2024 11:03:24 AM ICT> <Info> <Security> <BEA-090905> <Disabling the CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true.> 
<Aug 23, 2024 11:03:24 AM ICT> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG128 to HMACDRBG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true.> 
<Aug 23, 2024 11:03:24 AM ICT> <Info> <Security> <BEA-090908> <Using the default WebLogic SSL Hostname Verifier implementation.> 
Successfully connected to Admin Server "EMGC_ADMINSERVER" that belongs to domain "GCDomain".
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...
The username and password that were used for this WebLogic Server connection are stored in /home/oracle/encrypted/config and /home/oracle/encrypted/key.
Disconnected from weblogic server: EMGC_ADMINSERVER
******************  **********************88
0
User configuration file created: /home/oracle/encrypted/config
User key file created: /home/oracle/encrypted/key
'createkeys' succeeded.

[oracle@monitor-app ~]$ vi /home/oracle/encrypted/oem_property_file_RU23
AdminServerURL=t3s://monitor-app.taolaobidao.com:7102
AdminConfigFile=/home/oracle/encrypted/config
AdminKeyFile=/home/oracle/encrypted/key

🌞Installing the RU 23 (36494040) in Traditional Patching
Ref: 13.5: What is Rapid Platform Update and How To Apply Patches on OMS? (Doc ID 2784805.1)

[oracle@monitor-app ~]$ . oms_env 
[oracle@monitor-app ~]$ cd /source/monitor/patch/36494040


// Analyze for testing. Not patching by this method before testing carefully
[oracle@monitor-app 36494040]$ omspatcher deploy -analyze -property_file /home/oracle/encrypted/oem_property_file_RU23 

// Analyze for traditional patching
[oracle@monitor-app 36494040]$ omspatcher apply -analyze -property_file /home/oracle/encrypted/oem_property_file_RU23 

[oracle@monitor-app 36494040]$ omspatcher apply -property_file /home/oracle/encrypted/oem_property_file_RU23

Check log in /u01/app/oracle/middleware/cfgtoollogs/omspatcher/36494040

🌞Verify patching
[oracle@monitor-app ~]$ omspatcher status
[oracle@monitor-app ~]$ omspatcher lspatches | grep 36494040
oracle@monitor-app ~]$ opatch lsinventory | grep 13.5.1.23
 
C. Apply Agent RU 23 – July 2024
Ref: 13.5: How to Upgrade AgentPatcher to the Latest Version (Doc ID 2810322.1)

[oracle@monitor-app ~]$ . agent_env 
[oracle@monitor-app ~]$ agentpatcher version
AgentPatcher Version: 13.9.5.8.0 // latest opatch version
OPlan Version: 12.2.0.1.16
OsysModel build: Tue Apr 28 18:16:31 PDT 2020

AgentPatcher succeeded.

[oracle@monitor-app ~]$ agentpatcher lspatches
// Log in /u01/app/oracle/agent/agent_13.5.0.0.0/cfgtoollogs/agentpatcher

Analyze patching
[oracle@monitor-app ~]$ agentpatcher apply -analyze /source/monitor/patch/36494050

Patching
[oracle@monitor-app ~]$ emctl stop agent
[oracle@monitor-app ~]$ agentpatcher apply /source/monitor/patch/36494050
[oracle@monitor-app ~]$ emctl status agent
[oracle@monitor-app ~]$ emctl upload agent
[oracle@monitor-app ~]$ agentpatcher lspatches

NOTE:
If patching Holistic Patch before patching OMS RU patch, we do not need to patch omspatcher and opatch