ogg monitor 打补丁

DBA更进一步：不再安分的时代 / 2024-04-22 / 原文

[oracle@oggdb1 ogg_agent]<20240418 10:14:56>$ ./displayMonitorAgentVersion.sh
Monitor Agent Release Version: 12.2.1.2.210930
Build Label: OGGMON_MAIN_PLATFORMS_210915.0010
[oracle@oggdb1 ogg_agent]<20240418 10:14:57>$ 

[oracle@oggdb1 oggmon]<20240418 10:16:20>$ cd ..
[oracle@oggdb1 oggmon_agent122]<20240418 10:16:21>$ ll
total 8
drwxr-x---  5 oracle oinstall  49 May  6  2022 cfgtoollogs
drwxr-xr-x 11 oracle oinstall 135 May  6  2022 instance
drwxr-x--- 19 oracle oinstall 293 May  6  2022 inventory
drwxr-x---  5 oracle oinstall  52 May  6  2022 oggmon
drwxr-x--- 11 oracle oinstall 305 May  6  2022 OPatch
drwxr-x---  7 oracle oinstall  73 May  6  2022 oracle_common
-rw-r-----  1 oracle oinstall 127 May  6  2022 oraInst.loc
drwxr-x---  8 oracle oinstall 129 May  6  2022 oui
-rwx------  1 oracle oinstall  10 May  6  2022 root.sh
drwxr-x---  3 oracle oinstall  20 May  6  2022 veridata
drwxr-x---  5 oracle oinstall  50 May  6  2022 wlserver
[oracle@oggdb1 oggmon_agent122]<20240418 10:16:22>$ pwd
/diaglog/oggmon_agent122
[oracle@oggdb1 oggmon_agent122]<20240418 10:16:23>$ 


--1 更新opatch
export JAVA_HOME=/u01/app/oracle/product/19.10.0/db_1/jdk

[oracle@oggdb1 6880880]<20240418 18:26:45>$ pwd
/home/oracle/0418/6880880
[oracle@oggdb1 6880880]<20240418 18:26:46>$ 
export ORACLE_HOME=/diaglog/oggmon_agent122

注意路径
/u01/app/19.10.0/grid/jdk/bin/java -jar opatch_generic.jar -silent oracle_home=/diaglog/oggmon_agent122

[oracle@oggdb1 OPatch]<20240418 18:31:07>$ ./opatch version
OPatch Version: 13.9.4.2.15

OPatch succeeded.
[oracle@oggdb1 OPatch]<20240418 18:31:18>$ pwd
/diaglog/oggmon_agent122/OPatch
[oracle@oggdb1 OPatch]<20240418 18:31:20>$ 

stop 进程
[oracle@oggdb1 34362913]<20240418 18:33:47>$ /u01/app/replicat/ggsci

--2 应用补丁
[oracle@oggdb1 34362913]<20240418 18:34:38>$ /diaglog/oggmon_agent122/OPatch/opatch  apply
Oracle Interim Patch Installer version 13.9.4.2.15
Copyright (c) 2024, Oracle Corporation.  All rights reserved.
Oracle Home       : /diaglog/oggmon_agent122
Central Inventory : /u01/app/oraInventory
   from           : /diaglog/oggmon_agent122/oraInst.loc
OPatch version    : 13.9.4.2.15
OUI version       : 13.9.4.0.0
Log file location : /diaglog/oggmon_agent122/cfgtoollogs/opatch/opatch2024-04-18_18-34-41PM_1.log
OPatch detects the Middleware Home as "/diaglog/oggmon_agent122"
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   34362913  
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/diaglog/oggmon_agent122')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '34362913' to OH '/diaglog/oggmon_agent122'
ApplySession: Optional component(s) [ oracle.ogg.monitor.server, 12.2.1.2.0 ] , [ oracle.ogg.monitor.server, 12.2.1.2.0 ] , [ oracle.rcu.oggmon, 12.2.1.2.0 ] , [ oracle.rcu.oggmon, 12.2.1.2.0 ] , [ oracle.fmw.upgrade.oggmon, 12.2.1.2.0 ] , [ oracle.fmw.upgrade.oggmon, 12.2.1.2.0 ]  not present in the Oracle Home or a higher version is found.
Patching component oracle.ogg.monitor.agent, 12.2.1.2.0...

Patching component oracle.ogg.monitor.agent, 12.2.1.2.0...
Patch 34362913 successfully applied.
Sub-set patch [31997138] has become inactive due to the application of a super-set patch [34362913].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /diaglog/oggmon_agent122/cfgtoollogs/opatch/opatch2024-04-18_18-34-41PM_1.log
OPatch succeeded.


[oracle@oggdb1 34362913]<20240418 18:35:34>$ /diaglog/oggmon_agent122/OPatch/opatch  lspatches
34362913;One-off
22754279;One-off
21663638;One-off
19795066;One-off
19632480;One-off
19154304;One-off
19030178;One-off


GGSCI (oggdb1) 4> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
JAGENT      RUNNING                                           
PMSRVR      RUNNING                                           


[oracle@oggdb1 ogg_agent]<20240418 18:40:45>$ pwd
/diaglog/oggmon_agent122/oggmon/ogg_agent
[oracle@oggdb1 ogg_agent]<20240418 18:41:01>$ 
[oracle@oggdb1 ogg_agent]<20240418 18:40:41>$ ./displayMonitorAgentVersion.sh
Monitor Agent Release Version: 12.2.1.2.221115
Build Label: OGGMON_MAIN_PLATFORMS_221027.2000
[oracle@oggdb1 ogg_agent]<20240418 18:40:45>$