Home Administration Install Oracle GoldenGate Plug-in on Oracle Enterprise Manager Cloud Control 13c

Install Oracle GoldenGate Plug-in on Oracle Enterprise Manager Cloud Control 13c

In this post, we will install and deploy Oracle GoldenGate Plug-in 13.4.1.0 on Oracle Enterprise Manager Cloud Control 13c Release 4. I have an Active-Active OMS 13c setup that is load-balanced via SLB.

While the plug-in install is an online operation, the plug-in deployment on OMS is not an online operation. Both OMS will go down when deploying the plugin to OMS. However, plug-in deployment to Agent is an online operation.

Backup

As a first step, backup your existing OEM setup. That includes agent, OMS, and repository database.

Stop services

------------------------------------------------------------------------------------
# Stop Agent
------------------------------------------------------------------------------------
> . oraenv
ORACLE_SID = [oracle] ? AGENT
> emctl stop agent


------------------------------------------------------------------------------------
# Stop OMS
------------------------------------------------------------------------------------
> . oraenv
ORACLE_SID = [AGENT] ? OMS
> emctl stop oms

# Stop Agent and OMS on node 2 if you have second OMS

Backup

------------------------------------------------------------------------------------
# Backup OMS 
------------------------------------------------------------------------------------
> cd /u00/software/em13c
> ls -ltr
total 12
drwxr-x---.  5 oracle oinstall 4096 Apr  9 21:07 gc_inst
drwxr-xr-x. 71 oracle oinstall 8192 May  7 19:14 oraclehome
>
> tar -cvpf /backup/oms1.tar ./


------------------------------------------------------------------------------------
# Backup Agent
------------------------------------------------------------------------------------
> cd /u01/app/oracle/agent/em13c
> ls -ltr
total 8
-rw-r--r--.  1 oracle oinstall  493 Mar 12 19:28 agentInstall.rsp
drwxr-xr-x.  8 oracle oinstall   98 May  7 18:13 agent_inst
drwxr-xr-x. 29 oracle oinstall 4096 May  7 18:59 agent_13.4.0.0.0
>
> tar -cvpf /backup/agent1.tar ./


------------------------------------------------------------------------------------
# Backup OMS config
------------------------------------------------------------------------------------
> emctl exportconfig oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
ExportConfig started...
Backup directory is /u00/software/em13c/gc_inst/em/EMGC_OMS1/sysman/backup
Machine is Admin Server host. Performing Admin Server backup...
Exporting emoms properties...
Exporting secure properties...
Exporting configuration for pluggable modules...
Preparing archive file...
Backup has been written to file: /u00/software/em13c/gc_inst/em/EMGC_OMS1/sysman/backup/opf_ADMIN_20200507_190910.bka


------------------------------------------------------------------------------------
# Backup Repository Database
------------------------------------------------------------------------------------
> rman target / catalog rman@rcat

Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 7 21:15:07 2020
Version 19.6.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: XXXX (DBID=XXXXXXX)
recovery catalog database Password:
connected to recovery catalog database

RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE TAG = 'oms_pre_gg_plugin_deploy';

Start OMS and then Agent.

> emctl start oms
> emctl start agent

Download GoldenGate Plug-In

If you have not already obtained the software, download the GoldenGate 13.4.1 plug-in from the Oracle GoldenGate Downloads page. The plug-in you are looking for is under the Management Pack for Oracle GoldenGate section.

Copy the downloaded plug-in to the OMS server.

Import

Import the plug-in to OMS. You only need to do this on one OMS if you have a multi-OMS setup.

------------------------------------------------------------------------------------
# Unzip the staged file
------------------------------------------------------------------------------------
> cd /tmp
> unzip OGG-EM-Plugin-13.4.1.0.0.zip
> ls -ltr
total 29268
-rw-r--r--. 1 oracle oinstall 14728632 Mar  3 18:13 13.4.1.0.0_oracle.fmw.gg_2000_0.opar
-rw-r--r--. 1 oracle oinstall   197982 Mar 10 10:24 OGG-EM-Plugin-13.4.1.0.0-ReleaseNotes.pdf
-rw-r--r--. 1 oracle oinstall 14903278 May  7 18:37 OGG-EM-Plugin-13.4.1.0.0.zip


------------------------------------------------------------------------------------
# Login via emcli
------------------------------------------------------------------------------------
> emcli login -username=sysman
Enter password :

Login successful


------------------------------------------------------------------------------------
# Import
------------------------------------------------------------------------------------
> emcli import_update -file="/tmp/13.4.1.0.0_oracle.fmw.gg_2000_0.opar" -omslocal
Processing update: Plug-in - GoldenGate Plug-in now supports monitoring of GoldenGate Microservices Architecture, in addition to the GoldenGate Classic Architecture
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.

The plug-in has been imported into OMS. In OEM 13c console, go to Setup -> Extensibility -> Self Update -> Scroll down the list in the table and select Plug-in. It should lead you to this page and you should be able to see the Oracle GoldenGate Plug-in in the list.

Deploy Plug-in

Click on the Plug-in button on the Self Update page to navigate to the Plug-in management page. You can also reach here via Setup -> Extensibility -> Plug-ins menu.

Select Deploy On button and choose Management Servers. Follow the screen to deploy the plug-in to OMS. If you have an active-active OMS setup, the plugin gets deployed to both OMS in one shot.

Note: Plug-in deployment on OMS is not an online operation. Both OMS will go down when deploying the plugin.

You can check the status of the deployment using the below command.

> . oraenv
ORACLE_SID = [] ? OMS

> emctl status oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation.  All rights reserved.
WebTier is Up
Oracle Management Server is Down

This is due to the following plug-ins being deployed on the management server or undeployed from it:
----------------------------------------
Plugin name:    : Oracle GoldenGate
Version:        : 13.4.1.0.0
ID:             : oracle.fmw.gg
----------------------------------------

Use 'emctl status oms -details' for details.
JVMD Engine is Down
BI Publisher Server is Up

Once the GoldenGate Plug-In is deployed to OMS, the process will start the OMS automatically.

Use the Plug-In Management page (screenshot above) to deploy the plug-in to Management Agents. The process is the same. However, there is no downtime for deploying plug-in to Management Agents. You can check the status of the deployment via OEM GUI itself (Plug-Ins -> Deployment Activities.

If you are logged into OMS via emcli, you can use the below command to check the status.

> emcli get_plugin_deployment_status
Displaying status for the latest deployment activity(deployment ID 35)
Plug-in Deployment/Undeployment Status

Destination          : Management Agent - hostname:port
Plug-in Name         : Oracle GoldenGate
Version              : 13.4.1.0.0
ID                   : oracle.fmw.gg
Content              : Plug-in
Action               : Deployment
Status               : Success
Steps Info:
---------------------------------------- ------------------------- ------------------------- ----------
Step                                     Start Time                End Time                  Status
---------------------------------------- ------------------------- ------------------------- ----------
Submit job for deployment                5/7/20 7:37:36 PM GMT     5/7/20 7:37:36 PM GMT     Success

Initialize                               5/7/20 7:37:40 PM GMT     5/7/20 7:37:45 PM GMT     Success
...
...

List Plug-ins

Use the below commands on OMS when logged in via emcli to check the status of the plug-ins that are deployed.

> emcli list_plugins_on_server
OMS name is oms2host.domainname:4889_Management_Service
Plug-in Name                                 Plugin-id                     Version [revision]

Oracle GoldenGate                            oracle.fmw.gg                 13.4.1.0.0
Oracle Cloud Framework                       oracle.sysman.cfw             13.4.1.0.0
Oracle Database                              oracle.sysman.db              13.4.1.0.0
Oracle Fusion Middleware                     oracle.sysman.emas            13.4.1.0.0
Systems Infrastructure                       oracle.sysman.si              13.4.1.0.0
Oracle Exadata                               oracle.sysman.xa              13.4.1.0.0

OMS name is oms1host.domainname:4889_Management_Service
Plug-in Name                                 Plugin-id                     Version [revision]

Oracle GoldenGate                            oracle.fmw.gg                 13.4.1.0.0
Oracle Cloud Framework                       oracle.sysman.cfw             13.4.1.0.0
Oracle Database                              oracle.sysman.db              13.4.1.0.0
Oracle Fusion Middleware                     oracle.sysman.emas            13.4.1.0.0
Systems Infrastructure                       oracle.sysman.si              13.4.1.0.0
Oracle Exadata                               oracle.sysman.xa              13.4.1.0.0
> emcli list_plugins_on_agent
The Agent URL is https://hostname.domainname.com:1832/emd/main/ -
Plug-in Name                                 Plugin-id                     Version [revision]

Oracle Home                                  oracle.sysman.oh              13.4.0.0.0
Oracle Database                              oracle.sysman.db              13.4.1.0.0
Oracle GoldenGate                            oracle.fmw.gg                 13.4.1.0.0
Systems Infrastructure                       oracle.sysman.si              13.4.1.0.0
Oracle Exadata                               oracle.sysman.xa              13.4.1.0.0

Hope this helps! If it did, leave us a comment or feedback and tell us your experience.

References

Enterprise Manager Oracle GoldenGate System Monitoring Plug-in Installation Guide

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest posts

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM...

DBCA fails with ORA-27125 on 19c

Issue I recently encountered an issue where DBCA failed with ORA-27125 when creating a...

How to rename a PDB in 19c

Let's look at how to rename a PDB in 19c. The steps are the same as 12c....

How to change the ethernet switch password on Exadata

Let's look at how to log in and change the ethernet switch (adm) password on an Exadata...

You might also likeRELATED
Recommended to you