http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
– Oracle GoldenGate Monitor 12.2.1.2.0 (425 MB)
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.
https://XXX:7803/em/public_lib_download/emcli/kit/emcliadvancedkit.jar
[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
./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
setup->Extensiblity->plugin->Middleware
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
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.
How To Enable Monitoring For GoldenGate 12.3.x Targets Using Oracle Enterprise Manager 13c R2+? (Doc ID 2314622.1)
[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.
[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.
agent.type.enabled=OEM
jagent.host=xxx
jagent.username=oracle
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
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
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”
Now you can check GG target status using the navigation Targets->Goldengate
It’s Very informative. Thanks for sharing your knowledge.
Good Doc!