Step-by-Step Guide to Configure Oracle GoldenGate Plug-in for Enterprise Manager 13cR5


Oracle GoldenGate Enterprise Manager Plug-in helps monitor and manage Goldengate processes through Oracle Enterprise Manager Cloud Control.

Environment details:

Host: srvdb01.localdomain

Operating System: OEL 8.8

OEM Version: 13.5.0.0

OEM Home: /u01/app/oracle/em13c/oraclehome

Database Version: 19.23.0.0.0

Database Home: /u01/app/oracle/product/19.0.0/dbhome_1

Goldengate Version: 21.3.0.0.0

Goldengate Home: /u01/app/oracle/product/21.3.0/ogg_1

Goldengate Agent Home: /u01/app/oracle/oggmon_agent122

 All components, including Oracle Enterprise Manager 13.5, Oracle Database 19c, Oracle Goldengate 21.3 and Goldengate Monitor Agent 12.2 are configured on the same host srvdb01.localdomain running on OEL 8.8.


We will set up the Oracle GoldenGate Plug-in for Enterprise Manager 13cR5.

1. Download the Oracle Goldengate Plug-in for OEM 13.5 from edelivery.oracle.com.

https://www.oracle.com/middleware/technologies/goldengate-downloads.html




2. Copy the Oracle Goldengate Plug-in to the OMS server and unzip under /tmp.

[oracle@dbsrv01 ~]$ cd /tmp

[oracle@dbsrv01 tmp]$ unzip -qa V1031410-01.zip

[oracle@dbsrv01 tmp]$ ls -ltr 13.5.2.0.0_oracle.fmw.gg_2000_0.opar

-rwxr-xr-x. 1 oracle oinstall 23926697 Oct  4  2022 13.5.2.0.0_oracle.fmw.gg_2000_0.opar

 

3. Run emcli import_update with the Goldengate Plug-in file to import it into Oracle Enterprise Manager for deployment.

[oracle@dbsrv01]$ $OMS_HOME/bin/emcli login -username=sysman -password=master08

Login successful

[oracle@dbsrv01]$ $OMS_HOME/bin/emcli sync

Synchronized successfully

[oracle@dbsrv01 ~]$ $OMS_HOME/bin/emcli import_update -file=/tmp/13.5.2.0.0_oracle.fmw.gg_2000_0.opar -omslocal

Processing update: Plug-in - GoldenGate Plug-in now supports monitoring of Oracle GoldenGate Microservices, in addition to the Oracle GoldenGate Classic

Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.


4.  Backup the OMS configuration.

[oracle@dbsrv01 ~]$ $OMS_HOME/bin/emctl exportconfig oms -sysman_pwd master08

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved.

ExportConfig started...

Backup directory is /u01/app/oracle/em13c/gc_inst/em/EMGC_OMS1/sysman/backup

Machine is Admin Server host. Performing Admin Server backup...

Exporting emoms properties...

Exporting secure properties...

Export has determined that the OMS is not fronted

by an SLB. The local hostname was NOT exported.

The exported data can be imported on any host but

resecure of all agents will be required. Please

see the EM Advanced Configuration Guide for more

details.

 

Exporting configuration for pluggable modules...

Preparing archive file...

Backup has been written to file: /u01/app/oracle/em13c/gc_inst/em/EMGC_OMS1/sysman/backup/opf_ADMIN_20241113_195151.bka

 

The export file contains sensitive data.

 You must keep it secure.

 

ExportConfig completed successfully!

 

5. Deploy the Oracle Goldengate Plug-in to the OMS Management server.

[oracle@dbsrv01 ~]$ $OMS_HOME/bin/emcli deploy_plugin_on_server -plugin="oracle.fmw.gg" -sys_password=sys -repo_backup_taken

Performing pre-requisites check... This will take a while.

Prerequisites check succeeded

Deployment of plug-in on the management servers is in progress

Use "emcli get_plugin_deployment_status -plugin=oracle.fmw.gg" to track the plug-in deployment status.

 

Note: Deployment of plug-in on the Management Server will require downtime.

      All currently connected users will be automatically disconnected from the Enterprise Manager.

      During downtime, users will not be able to connect to Enterprise Manager, and

      Enterprise Manager will not be able to monitor any targets.

      During downtime, use "emctl status oms -details" to track the deployment status during downtime.

  

[oracle@dbsrv01 ~]$ $OMS_HOME/bin/emctl status oms

Oracle Enterprise Manager Cloud Control 13c Release 5

Copyright (c) 1996, 2021 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.5.2.0.0

ID:             : oracle.fmw.gg

----------------------------------------

 

Use 'emctl status oms -details' for details.

JVMD Engine is Down


6. Deploy the Oracle Goldengate Plug-in to the OMS Management agent.

[oracle@dbsrv01 ~]$ $OMS_HOME/bin/emcli deploy_plugin_on_agent -agent_names="dbsrv01.localdomain:3872" -plugin="oracle.fmw.gg"

Agent side plug-in deployment is in progress

Use "emcli get_plugin_deployment_status -plugin=oracle.fmw.gg" to track the plug-in deployment status.

 

[oracle@dbsrv01 ~]$ $OMS_HOME/bin/emcli list_plugins_on_agent -agent_names="dbsrv01.localdomain:3872"

The Agent URL is https://dbsrv01.localdomain:3872/emd/main/ -

Plug-in Name                                 Plugin-id                     Version [revision]

Oracle Home                                  oracle.sysman.oh              13.5.0.0.0

Oracle Database                              oracle.sysman.db              13.5.1.0.0

Oracle GoldenGate                            oracle.fmw.gg                 13.5.2.0.0



7. Download Oracle Goldengate Monitor Agent 12.2.1.2.0, copy it to the server where Goldengate is running, and unzip under /tmp.

https://www.oracle.com/middleware/technologies/goldengate-downloads.html




[oracle@dbsrv01 ~]$ cd /tmp

[oracle@dbsrv01 tmp]$ unzip -qa fmw_12.2.1.2.0_ogg_Disk1_1of1.zip

[oracle@dbsrv01 tmp]$ ls -ltr fmw_12.2.1.2.0_ogg.jar

-r-xr-xr-x. 1 oracle oinstall 446021430 Oct 12  2016 fmw_12.2.1.2.0_ogg.jar


8. Prepare the agent response file with below parameter values.

 

[oracle@dbsrv01 tmp]$ vi agent.rsp

[ENGINE]

#DO NOT CHANGE THIS.

Response File Version=1.0.0.0.0

[GENERIC]

#The oracle home location. This can be an existing Oracle Home or a new Oracle Home

ORACLE_HOME=/u01/app/oracle/oggmon_agent122

#Set this variable value to the Installation Type selected.

#e.g.

#Complete

#GoldenGate Veridata Web Server Installation

#GoldenGate Veridata Agent Installation

#GoldenGate Veridata Web Server and Agent Installation

#GoldenGate Monitor Web Server Installation

#GoldenGate Monitor Agent Installation

#GoldenGate Monitor Web Server and Agent Installation.

INSTALL_TYPE=GoldenGate Monitor Agent Installation


9. Verify JRE 1.8 installed and configure Goldengate Monitor Agent on the server where Goldengate is running.

 

[oracle@dbsrv01 tmp]$ java -version

java version "1.8.0_202"

Java(TM) SE Runtime Environment (build 1.8.0_202-b08)

Java HotSpot(TM) 64-Bit Server VM (build 25.202-b08, mixed mode)

 

[oracle@dbsrv01 tmp]$ java -jar /tmp/fmw_12.2.1.2.0_ogg.jar -silent -responseFile /tmp/agent.rsp

Launcher log file is /tmp/OraInstall2024-11-15_07-19-42PM/launcher2024-11-15_07-19-42PM.log.

Extracting the installer . . . . . . Done

Checking if CPU speed is above 300 MHz.   Actual 2419.196 MHz    Passed

Checking swap space: must be greater than 512 MB.   Actual 8191 MB    Passed

Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)

Checking temp space: must be greater than 300 MB.   Actual 10643 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2024-11-15_07-19-42PM

Log: /tmp/OraInstall2024-11-15_07-19-42PM/install2024-11-15_07-19-42PM.log

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

Reading response file..

Skipping Software Updates

Starting check : CertifiedVersions

Expected result: One of oracle-6,oracle-7,redhat-7,redhat-6,SuSE-11,SuSE-12

Actual Result: oracle-8.8

Check complete. The overall result of this check is: Passed

CertifiedVersions Check: Success.

 

Starting check : CheckJDKVersion

Expected result: 1.8.0_101

Actual Result: 1.8.0_202

Check complete. The overall result of this check is: Passed

CheckJDKVersion Check: Success.

 

Validations are enabled for this session.

Verifying data

Copying Files

Percent Complete : 10

Percent Complete : 20

Percent Complete : 30

Percent Complete : 40

Percent Complete : 50

Percent Complete : 60

Percent Complete : 70

Percent Complete : 80

Percent Complete : 90

Percent Complete : 100

 

The installation of Oracle Fusion Middleware 12c GoldenGate Monitor & Veridata 12.2.1.2.0 completed successfully.

Logs successfully copied to /u01/app/oraInventory/logs.


10. Download and Patch Oracle Goldengate Monitor agent home with 31997138. 


[oracle@dbsrv01 tmp]$ unzip -qa p31997138_122120_Generic.zip

[oracle@dbsrv01 tmp]$ cd 31997138/

[oracle@dbsrv01 31997138]$ export ORACLE_HOME=/u01/app/oracle/oggmon_agent122

[oracle@dbsrv01 31997138]$ /u01/app/oracle/oggmon_agent122/OPatch/opatch apply -silent

Oracle Interim Patch Installer version 13.9.1.0.0

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

 

Oracle Home       : /u01/app/oracle/oggmon_agent122

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/oggmon_agent122/oraInst.loc

OPatch version    : 13.9.1.0.0

OUI version       : 13.9.1.0.0

Log file location : /u01/app/oracle/oggmon_agent122/cfgtoollogs/opatch/opatch2024-11-18_10-56-25AM_1.log

  

OPatch detects the Middleware Home as "/u01/app/oracle/oggmon_agent122"

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   31997138

 

Do you want to proceed? [y|n]

Y (auto-answered by -silent)

User Responded with: Y

All checks passed.

 

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/oggmon_agent122')

  

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

Y (auto-answered by -silent)

User Responded with: Y

Backing up files...

Applying interim patch '31997138' to OH '/u01/app/oracle/oggmon_agent122'

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...

Patch 31997138 successfully applied.

Log file location: /u01/app/oracle/oggmon_agent122/cfgtoollogs/opatch/opatch2024-11-18_10-56-25AM_1.log

OPatch succeeded.


11. Create the Oracle Goldengate Monitor Agent Instance.


[oracle@dbsrv01 tmp]$ cd /u01/app/oracle/oggmon_agent122/oggmon/ogg_agent

[oracle@dbsrv01 ogg_agent]$ ./createMonitorAgentInstance.sh

Please enter absolute path of Oracle GoldenGate home directory : /u01/app/oracle/product/21.3.0/ogg_1

Please enter absolute path of OGG Agent instance : /u01/app/oracle/oggmon_agent122/inst_1

Please enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20241115193621.sh) :

Successfully created OGG Agent instance.


12. Configure the Oracle Goldengate Monitor Agent by updating the config.properties.

 

[oracle@dbsrv01 ~]$ cd /u01/app/oracle/oggmon_agent122/inst_1/cfg

[oracle@dbsrv01 cfg]$ cp Config.properties Config.properties.ORIG

[oracle@dbsrv01 cfg]$ vi Config.properties

[oracle@dbsrv01 cfg]$ cat Config.properties |grep -v "#"

 

jagent.host=localhost

jagent.jmx.port=5555

interval.regular=60

interval.quick=30

monitor.host=localhost

monitor.jmx.port=5502

monitor.jmx.username=oggmsjmxusr

jagent.username=oggmajmxusr

reg.retry.interval=10

instance.query.initial.interval=5

incremental.registration.quiet.interval=5

maximum.message.retrieval=500

jagent.rmi.port=5559

agent.type.enabled=OEM

status.polling.interval=5

message.polling.interval=5

reg.retry.times=-1

jagent.backward.compatibility=false

jagent.ssl=false

jagent.keystore.file=jagentKeyStore

jagent.truststore.file=jagentKeyStore

jagent.restful.ws.timeout=15000

jagent.ggsci.timeout=30


13. Create a wallet for the Oracle Goldengate Plug-in (jagent).

 

[oracle@dbsrv01 ~]$ export JAVA_HOME=/usr/java/jdk1.8.0_202-amd64

[oracle@dbsrv01 ~]$ export PATH=$JAVA_HOME/bin:$PATH

[oracle@dbsrv01 ~]$ cd /u01/app/oracle/oggmon_agent122/inst_1/bin/

[oracle@dbsrv01 bin]$ ./pw_agent_util.sh -jagentonly

Please create a password for Java Agent:

Please confirm password for Java Agent:

Nov 16, 2024 11:50:07 AM oracle.security.jps.JpsStartup start

INFO: Jps initializing.

Nov 16, 2024 11:50:09 AM oracle.security.jps.JpsStartup start

INFO: Jps started.

Wallet is created successfully.

 

NOTE: The default "jagent" user is "oggmajmxusr" and the wallet password is what is entered above with the password utility script.


14. Verify $OGG_HOME/dirprm/jagent.prm file contains the full path to /u01/app/oracle/oggmon_agent122/inst_1 (OGG Agent instance).


[oracle@dbsrv01 bin]$ cd /u01/app/oracle/product/21.3.0/ogg_1/dirprm/

[oracle@dbsrv01 dirprm]$ cat jagent.prm

COMMAND java -Dconfig.dir=/u01/app/oracle/oggmon_agent122/inst_1/cfg -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=/u01/app/oracle/oggmon_agent122/inst_1/cfg/logging-config.xml -Doracle.core.ojdl.logging.componentId=JAGENT -jar -Xms512m -Xmx1024m /u01/app/oracle/oggmon_agent122/oggmon/ogg_agent/dirjar/jagent.jar


15. Add ENABLEMONITORING to the GLOBALS file, then stop all Goldengate processes.


[oracle@dbsrv01 ~]$ ggsci

 Oracle GoldenGate Command Interpreter for Oracle

Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO

Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23

Operating system character set identified as UTF-8.

 

Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.

 

GGSCI (dbsrv01.localdomain) 1> INFO ALL

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt 

MANAGER     RUNNING

EXTRACT     RUNNING     EXTR        00:00:00      00:00:04

 

GGSCI (dbsrv01.localdomain) 2> EDIT PARAMS ./GLOBALS

ENABLEMONITORING

 

GGSCI (dbsrv01.localdomain) 3> EXIT

 

[oracle@dbsrv01 ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO

Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23

Operating system character set identified as UTF-8.

 

Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.

 

 GGSCI (dbsrv01.localdomain) 1> INFO ALL

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

JAGENT      STOPPED

PMSRVR      STOPPED

EXTRACT     RUNNING     EXTR        00:00:00      00:00:00

 

GGSCI (dbsrv01.localdomain) 2> STOP *

Sending STOP request to Extract group EXTR ...

Request processed.

 

GGSCI (dbsrv01.localdomain) 3> STOP MGR

Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)?y

 

Sending STOP request to Manager ...

Request processed.

Manager stopped.


GGSCI (dbsrv01.localdomain) 4> EXIT


16. Start the Oracle Goldengate Processes and Monitor Agent.


[oracle@dbsrv01 ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO

Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23

Operating system character set identified as UTF-8.

 

Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved.

 

GGSCI (dbsrv01.localdomain) 1> START PMSRVR

PM Service started.

 

GGSCI (dbsrv01.localdomain) 2> START MGR

Manager started.

  

GGSCI (dbsrv01.localdomain) 3> START *

 

Sending START request to Manager ...

Extract group EXTR starting.


GGSCI (dbsrv01.localdomain) 4> START JAGENT

 

Sending START request to Manager ...

Application GGCMD JAGENT starting.

 

GGSCI (dbsrv01.localdomain) 5> INFO ALL

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

JAGENT      RUNNING

PMSRVR      RUNNING

EXTRACT     RUNNING     EXTR        00:00:00      00:00:08

 

17. Log in to the OEM 13cR5 console and discover the Oracle Goldengate targets.


Go to

Setup -> Add Target -> Configure Auto Discovery

 

In Setup Discovery page

on the Targets on Hosts tab -> select a target -> click Discovery Modules




In the Discovery Module page

select Oracle Goldengate Classic check box -> Edit Parameters : Oracle Goldengate Classic -> OK
















18. Promote the Oracle Goldengate targets.

Go to

Setup -> Add Target -> Auto Discovery Results -> select the discovered GoldenGate target -> Promote








19. Check the promoted Oracle Goldengate targets in OEM 13cR5.

Targets -> GoldenGate


















Comments

Popular posts from this blog

Step-by-Step Guide to Configure Oracle GoldenGate Veridata 23c

How to Reposition Extract, Data Pump and Replicat in GoldenGate During Trail File Corruption