Implementing the Golden Gate plug-in monitor for Oracle Cloud Control 13cR2(13.2.0.0.0)

This note describes the procedure of implementing the GoldenGate plug-in for Oracle Cloud Control 13cR2.

These versions are required for installing the plug-in:

• Enterprise Manager Cloud Control 13c Bundle Patch 1 (13.2.0.0.0) and later

• Oracle GoldenGate 12c (12.3.0.1.0) and later

• Oracle GoldenGate Plug-in for EMCC Release 13c

http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

• Download, install and configure Oracle GoldenGate Monitor Agent 12.2.1.2.0

http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
– Oracle GoldenGate Monitor 12.2.1.2.0 (425 MB)

Install Java 1.8 (or later) JDK on the servers where the GoldenGate instances will be running.

 Please ftp jdk-8u151-linux-x64.tar.gz in binary mode from your download location to /home/oracle directory of the server

cd /home/oracle

[oracle@xxx ~]$ tar xvf jdk-8u151-linux-x64.tar.gz

Set the JAVA_HOME variable to the location of the JDK installation and ensure that the PATH variable includes the $JAVA_HOME/jre/bin/ server directory location.

EMCLI configuration to manually upload GG plugin to cloud control server

For instruction,you may navigate from cloud control url :

Setup->command line interface

https://XXX:7803/em/public_lib_download/emcli/kit/emcliadvancedkit.jar

Login to cloud control application server and perform below steps:

[oracle@xxx u01]# /u01/app/oemcc/middleware/oracle_common/jdk/bin/java -jar /home/oracle/emcliadvancedkit.jar -install_dir=/home/oracle/emcli

Oracle Enterprise Manager 13c Release 1.

Copyright (c) 2012, 2015 Oracle Corporation.  All rights reserved.

 

EM CLI Advanced install completed successfully.

Execute “emcli help sync” from the EM CLI home (the directory where you have installed EM CLI) for further instructions.

[oracle@xxx emcli]$ export JAVA_HOME=/u01/app/oemcc/middleware/oracle_common/jdk

[oracle@xxx emcli]$ export PATH=$JAVA_HOME/bin:$PATH                 [oracle@CDV1PPOCCAPV01 emcli]$ ./emcli login -username=sysman -password=sysm4n4dm1n

Error: No current OMS. Run setup to establish an OMS connection.

./emcli setup -url=https://10.49.3.22:7803/em -username=SYSMAN -trustall

Oracle Enterprise Manager 13c Release 1.

Copyright (c) 1996, 2015 Oracle Corporation and/or its affiliates. All rights reserved.

Enter password

Emcli setup successful

./emcli import_update -file=/home/oracle/13.2.1.0.0_oracle.fmw.gg_2000_0.opar -omslocal

Select Oracle GoldenGate under the Plug-in Name column and click the Download button

After the download is completed, the status will change from Available to Downloaded

setup->Extensiblity->plugin->Middleware

This is step is to install management server

Log in to Enterprise Manager Cloud Control to complete the deployment:

a. Select Setup, Extensibility, Plug-ins to open the Plug-ins page.

b. Expand the Middleware folder.

c. Select Oracle GoldenGate, Deploy on, Management Servers… to start the
deployment process.

d. Enter the Repository SYS password and click Continue.

A series of prerequisite system checks begins. As each system check
completes,

e. Click Next after each system check completes to continue to the next check. Do
this until all of the prerequisite checks are complete.

f. Click Next and then Deploy

The next step is to deploy the management agent Plug-in on both the nodes of the RAC cluster where the GoldenGate instances are going to be running.

1. Select Setup, Extensibility, Plug-ins to open the Plug-ins page.

2. Expand the Middleware folder.

3. Select Oracle GoldenGate, Deploy on, Management Agent… to start the
deployment process.

4.Select the required version of plug-in, then click Continue.

5. Select all the EM Agents where you want to install plug-in.
6. Click Continue then click Deploy.

Once the Enterprise Manager Plug-In for Oracle GoldenGate is deployed, an Oracle
GoldenGate item appears under Targets in Enterprise Manager Cloud Control.

Installation of Golden gate monitoring agent in the server where GG is installed

 How to install/configure Oracle GoldenGate Monitor Agent 12.2.1.x with GoldenGate “core”? [VIDEO] (Doc ID 2171015.1)                                                                                               

 [oracle@xxx ~]$ export JAVA_HOME=/home/oracle/jdk1.8.0_151/

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

[oracle@xxx ~]$ java -version

java version “1.8.0_151”

Java(TM) SE Runtime Environment (build 1.8.0_151-b12)

Java HotSpot(TM) 64-Bit Server VM (build 25.151-b12, mixed mode)

This step requires display to be open so use Mobaxterm.

[oracle@xxx ogg_home]$ java -jar fmw_12.2.1.2.0_ogg.jar

Launcher log file is /tmp/OraInstall2017-12-20_01-03-55AM/launcher2017-12-20_01-03-55AM.log.

Extracting the installer . . . . . Done

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

Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed

Checking swap space: must be greater than 512 MB.   Actual 17407 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 6675 MB    Passed

Patch 26982776: Oracle GoldenGate Monitor 12.2.1.2.171115 (PS2 BP3) (Cumulative) Install

How To Upgrade Existing Oracle GoldenGate Monitor Agent 12.1.3.x to version 12.1.3.0.4? [VIDEO] (Doc ID 2024198.1)

export ORACLE_HOME=/u01/app/oracle/ogg_home/oggmon

export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@xxx oggmon]$ opatch lsinv

Oracle Interim Patch Installer version 13.9.1.0.0

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

 

 

Oracle Home       : /u01/app/oracle/ogg_home/oggmon

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/ogg_home/oggmon/oraInst.loc

OPatch version    : 13.9.1.0.0

OUI version       : 13.9.1.0.0

Log file location : /u01/app/oracle/ogg_home/oggmon/cfgtoollogs/opatch/opatch2017-12-20_01-38-19AM_1.log

OPatch detects the Middleware Home as “/u01/app/oracle/ogg_home/oggmon”

Lsinventory Output file location : /u01/app/oracle/ogg_home/oggmon/cfgtoollogs/opatch/lsinv/lsinventory2017-12-20_01-38-19AM.txt

——————————————————————————–

Local Machine Information::

Hostname:XXX

ARU platform id: 226

ARU platform description:: Linux x86-64

Interim patches (6) :

Patch  19030178     : applied on Wed Dec 20 01:12:44 CLST 2017

Unique Patch ID:  19234068

Patch description:  “One-off”

Created on 4 Aug 2015, 05:40:22 hrs UTC

Bugs fixed:

19030178

Patch  19154304     : applied on Wed Dec 20 01:12:12 CLST 2017

Unique Patch ID:  19278518

Patch description:  “One-off”

Created on 25 Aug 2015, 07:10:13 hrs UTC

Bugs fixed:

19154304

 

Patch  19632480     : applied on Wed Dec 20 01:11:41 CLST 2017

Unique Patch ID:  19278519

Patch description:  “One-off”

Created on 25 Aug 2015, 07:19:43 hrs UTC

Bugs fixed:

19632480

 

Patch  19795066     : applied on Wed Dec 20 01:11:12 CLST 2017

Unique Patch ID:  19149348

Patch description:  “One-off”

Created on 16 Jul 2015, 15:51:43 hrs UTC

Bugs fixed:

19795066

 

Patch  21663638     : applied on Wed Dec 20 01:10:42 CLST 2017

Unique Patch ID:  20477024

Patch description:  “One-off”

Created on 31 Aug 2016, 21:01:13 hrs UTC

Bugs fixed:

21663638

 

Patch  22754279     : applied on Wed Dec 20 01:10:12 CLST 2017

Unique Patch ID:  20383951

Patch description:  “One-off”

Created on 9 Jul 2016, 00:36:58 hrs UTC

Bugs fixed:

22754279

——————————————————————————-

OPatch succeeded.

[oracle@xxx ~]$ cd 26982776

[oracle@xxx 26982776]$ opatch apply

Oracle Interim Patch Installer version 13.9.1.0.0

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

Oracle Home       : /u01/app/oracle/ogg_home/oggmon

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/ogg_home/oggmon/oraInst.loc

OPatch version    : 13.9.1.0.0

OUI version       : 13.9.1.0.0

Log file location : /u01/app/oracle/ogg_home/oggmon/cfgtoollogs/opatch/opatch2017-12-20_01-40-23AM_1.log

OPatch detects the Middleware Home as “/u01/app/oracle/ogg_home/oggmon”

Verifying environment and performing prerequisite checks…

OPatch continues with these patches:   26982776

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 = ‘/u01/app/oracle/ogg_home/oggmon’)

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

y

User Responded with: Y

Backing up files…

Applying interim patch ‘26982776’ to OH ‘/u01/app/oracle/ogg_home/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…

Patch 26982776 successfully applied.

Log file location: /u01/app/oracle/ogg_home/oggmon/cfgtoollogs/opatch/opatch2017-12-20_01-40-23AM_1.log

OPatch succeeded.

Enable monitoring of GG from agent

How To Enable Monitoring For GoldenGate 12.3.x Targets Using Oracle Enterprise Manager 13c R2+? (Doc ID 2314622.1)

1.Create instance

 cd /u01/app/oracle/ogg_home/oggmon/oggmon/ogg_agent

[oracle@XXX ogg_agent]$ export JAVA_HOME=/home/oracle/jdk1.8.0_151/

[oracle@XXX ogg_agent]$ export PATH=$JAVA_HOME/bin:$PATH

 

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

Please enter absolute path of Oracle GoldenGate home directory : /u01/app/oracle/ogg_home

Please enter absolute path of OGG Agent instance : /u01/app/oracle/ogg_home/instance1

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

Successfully created OGG Agent instance.

2.Create the Oracle Wallet

Add the password that the Oracle Management Agent will use to connect to the Oracle GoldenGate agent .

Navigate to the Oracle GoldenGate agent instance directory and run the pw_agent_util.sh script

[oracle@XXXogg_agent]$ cd /u01/app/oracle/ogg_home/instance1

[oracle@XXX instance1]$ ls -ltr

total 32

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 dirprm

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 backup

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 dirwlt

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 dircrt

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 dirchk

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 cfg

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 logs

drwxr-xr-x. 2 oracle oinstall 4096 Dec 20 01:46 bin

[oracle@XXX instance1]$ rm -rf dirwlt

[oracle@XXX instance1]$ cd bin

[oracle@XXX bin]$ ls -ltr

total 12

-rwxr–r–. 1 oracle oinstall 1242 Dec 20 01:46 pw_agent_util.sh

-rwxr–r–. 1 oracle oinstall  433 Dec 20 01:46 displayMonitorAgentVersion.sh

-rwxr–r–. 1 oracle oinstall  379 Dec 20 01:46 startMonitorAgentInstance_20171220014616.sh

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

Please create a password for Java Agent:

Please confirm password for Java Agent:

Dec 20, 2017 1:48:56 AM oracle.security.jps.JpsStartup start

INFO: Jps initializing.

Dec 20, 2017 1:48:57 AM oracle.security.jps.JpsStartup start

INFO: Jps started.

Wallet is created successfully.

3.Configure the GoldenGate instance for OEM 13cR2

Navigate to the Oracle GoldenGate installation directory(/u01/app/oracle/ogg_home/instance1)

Edit the \cfg\Config.properties file.

In our case we have changed these values:

agent.type.enabled=OEM

jagent.host=xxx

jagent.username=oracle

Edit the GLOBALS file and add the parameter ENABLEMONITORING under GG Home

Create the Datastore  GGSCI (kens-racnode1) 1> CREATE DATASTORE

NOTE:
As indicated in Doc ID 2171015.1,

ALL “datastore” commands are deprecated in Oracle GoldenGate 12.3.x and above.

If using GoldenGate 12.3.x and above then DO NOT execute delete datastore, create datastore commands shown below or you will
receive “command not found” type errors.

GGSCI (xxx1) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

JAGENT      STOPPED

PMSRVR      STOPPED

EXTRACT     RUNNING     DPRAF01     00:00:00      00:00:06

EXTRACT     RUNNING     EXTRAF01    00:00:00      00:00:04

stop *
stop manager

delete datastore <— confirm delete of datastore.  NOT needed for OGG 12.3.x and above
create datastore <—– Use command “create datastore mmap” instead IF GoldenGate is installed on shared disk.  NOT needed for OGG 12.3.x and above

start manager
start *
start jagent  <<———— In GoldenGate 12.3.x and above this command will also start PMSRVR

info all <—– Confirm “jagent” and all other processes are UP and running

GGSCI (xxx) 6> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING

JAGENT      RUNNING

PMSRVR      RUNNING

EXTRACT     RUNNING     DPRAF01     00:00:00      00:00:03

EXTRACT     RUNNING     EXTRAF01    00:00:01      00:00:04

EXTRACT     STOPPED     EXTRAF02    00:00:00      18:28:33

Now we need to discover GG process from cloud control

Login to OEM 13c R2 console and discover/promote the GoldenGate targets

https://xxx:7803/em/login.jsp

Go to
Setup (Gear icon on top toolbar) -> Add Target -> Configure Auto Discovery -> Targets on Host
Select/highlight the “Host” -> click -> Discovery Modules -> Select/Highlight GoldenGateDiscovery
click -> Edit Parameters

Enter
——-
JAgent User Name:oracle
JAgent Password
Jagent Host Name:IP of the server where GG installed

Click OK
Click OK

Select/highlight the “Host” -> click -> Discover Now

After discovery procedure is finished -> click Close
Click -> xx in “Discovered Targets” column

In “Auto Discovery Results” page select the discovered GoldenGate target and click -> Promote.

You can select 1 of the targets associated with the “instance” and when you click “Promote”
it will bring up all the targets of the instance for final “Promote” click.

Once targets are promoted click -> “Close”

The screen shots:-

Now you can check GG target status using the navigation Targets->Goldengate