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

How to clone Pluggable Database from one container to different Container Database

-
Image
How to clone Pluggable Database from one container to different Container Database Cloning and Refresh are day-to-day activity which DBA perform on regular basic. In today blog , We will discuss about Cloning of the pluggable database from one container database to different container database. Oracle offers to unplug a PDB from one CDB and then plug into a different CDB. This will be another additional feature of PDB to give the highest availability and scalability the database systems may need in a cloud infrastructure environment.  1)We have two container database cseeddb(Source Container DB) and ctestdb1 (target container DB). NOTE: We have created container DB ctestdb1 and it does not have any PDB(Pluggable DB). 2)Verify you are in the correct container database root namespace(CDB). NOTE: We are on first container (cseeddb) database where we have clonedb pluggable database which we will move in to another empty container ctestdb1. SQL> set echo on SQL> SET LINESIZE 20...
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