Step-by-Step Guide to Configure Oracle GoldenGate Plug-in for Enterprise Manager 13cR5
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
We will set up the Oracle GoldenGate Plug-in for Enterprise
Manager 13cR5.
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
Post a Comment