Patch GG Monitoring agent

-

 For GG Admin, Patching is a day-to-day activity. In this blog, we will show you to patch Oracle GG Monitoring agent.

Step1: Take the backup of the GG monitoring agent binary. 

tar -cvf /tmp/gg_agent.tar /opt/ogg/oggmon

Step 2: Take backup of the current Inventory.

export ORACLE_HOME=/opt/ogg/oggmon
$ORACLE_HOME/OPatch/opatch lsinv

Step 3: Stop the running jagent and pmsrvr from GG prompt.

ggsci> stop pmsrvr
ggsci> stop jagent

Step 4: Patch GG Monitoring agent home. 

Unzip the latest patch in any directory and cd to patch directory.

cd /opt/ogg/software/31997138

==> Set ORACLE_HOME to GG monitoring agent and apply patch. 
export ORACLE_HOME=/opt/ogg/oggmon

==> Make sure you have latest opatch installed

GGHOST01:/opt/ogg/software/31997138>$ORACLE_HOME/OPatch/opatch version

OPatch Version: 13.9.1.0.0

OPatch succeeded.

==> Apply patch 

GGHOST01:/opt/ogg/software/31997138>$ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 13.9.1.0.0

Copyright (c) 2022, Oracle Corporation. All rights reserved.

Oracle Home : /opt/ogg/oggmon

Central Inventory : /opt/ogg/oraInventory

from : /opt/ogg/oggmon/oraInst.loc

OPatch version : 13.9.1.0.0

OUI version : 13.9.1.0.0

Log file location : /opt/ogg/oggmon/cfgtoollogs/opatch/opatch2022-11-03_03-01-12AM_1.log

OPatch detects the Middleware Home as "/opt/ogg/oggmon"

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 31997138

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 = '/opt/ogg/oggmon')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '31997138' to OH '/opt/ogg/oggmon'

ApplySession: Optional component(s) [ oracle.rcu.oggmon, 12.2.1.2.0 ] , [ oracle.rcu.oggmon, 12.2.1.2.0 ] , [ oracle.ogg.monitor.server, 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...

Skip copying to "/opt/ogg/oggmon/oggmon/ogg_agent/cfg_templates/Config.properties" because it is the same as

the file in incoming patch "/opt/ogg/software/31997138/files/oracle.ogg.monitor.agent/12.2.1.2.0/monitor.agent.common.symbol/ogg_agent/cfg_templates/Config.properties"

Skip copying to "/opt/ogg/oggmon/oggmon/ogg_agent/cfg_templates/logging-config.xml" because it is the same as

the file in incoming patch "/opt/ogg/software/31997138/files/oracle.ogg.monitor.agent/12.2.1.2.0/monitor.agent.common.symbol/ogg_agent/cfg_templates/logging-config.xml"

Patch 31997138 successfully applied.

Sub-set patch [31748559] has become inactive due to the application of a super-set patch [31997138].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /opt/ogg/oggmon/cfgtoollogs/opatch/opatch2022-11-03_03-01-12AM_1.log

OPatch succeeded.

Step 3: Start  jagent and pmsrvr from GG prompt.

ggsci> start pmsrvr
ggsci> start jagent

You can learn more about oracle database administration: 

Pro Oracle GoldenGate for the DBA

Oracle Security Tools Installation and Configuration

Expert Oracle Exadata 

Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting

Expert Oracle RAC 12c

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

Please check our other blogs for GoldenGate.

Location: Singapore

Comments

Post a Comment

Please do not enter any spam link in comment Section suggestions are Always Appreciated. Thanks.. !

Popular posts from this blog

Restart Innodb MySQL Cluster after Complete outage(All node Down)

-
Image
Restart Innodb MySQL Cluster after Complete outage(All node Down) In DBA World, Their could be activity(like DC Migration) where all node of an MySQL Innodb cluster need to brought down. In MySQL Innodb cluster, We need to follow below steps in order to bring up cluster. 1) Start all node in the MySQL Innodb cluster. systemctl start myql 2) Try to connect cluster using mysqlsh and check status. 3) Strat cluster using complete outage command. Restart Cluster using below command: var cluster = dba.rebootClusterFromCompleteOutage(); root@mysqlhost01:~# mysqlsh --uri clusteradmin@mysqlhost01:3306 Please provide the password for 'clusteradmin@mysqlhost01:3306': ************************ Save password for 'clusteradmin@mysqlhost01:3306'? [Y]es/[N]o/Ne[v]er (default No): MySQL Shell 8.0.17 Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of...
Read more

Oracle Block Corruption - Detection and Resolution

-
Oracle Block Corruption - Detection and Resolution Any kind of corruption in database can  lead to stand still operation of the organization and can cause sever impact to organisation. In this blog , We are going to discuss about Block Corruption of the oracle database. Block Corruption :  Oracle Block Corruption occurs due inconsistent block Header ,Footer ,Checksum or Structure. Depending on the kind of insistency ,We can divide corruption into Physical and Logical corruption. Physical Corruption is due to Bad header, header or footer mismatch ,Invalid Block checksum & misplaced block. Usually this kind of the block corruption are due to external reason and difficult to resolve by oracle utilities alone.  Logical Corruption is due to corrupt or invalid Block structure when block checksum is valid. This kind of the Corruption can be resolved by the Oracle Utilities. Detection of Block Corruption Whenever a corrupt block is read Oracle reports an error in the alert l...
Read more

Add or Remove a node in MySQL Innodb Cluster

-
Add or Remove a node in MySQL Innodb Cluster In any database Cluster Solution ,it's regular activity to add or remove node from the cluster. In this blog , We will discuss about addition and removal of the cluster node from the MySQL Innodb cluster. Remove a node from the MySQL Innodb cluster . 1) Connect to primary node and check status. mysqlsh --uri clusteradmin@mysqlhost01:3306 MySQL  mysqlhost01:3306 ssl  JS > cluster.status() {     "clusterName": "mysqlcluster",     "defaultReplicaSet": {         "name": "default",         "primary": "mysqlhost01:3306",         "ssl": "REQUIRED",         "status": "OK",         "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",         "topology": {     ...
Read more