Sunday, January 27, 2019

Goldengate Performance Metric Server OGG 12.3



The Performance Metrics Server (PMSRVR) introduced in OGG 12.3 version and uses the metrics service to collect and store instance deployment performance results

We can use Performance Metrics Server in both CLASSIC and MICROSERVICES Architecture modes

When PMSRVR is started for the first time, the sequence of commands must be:

START PMSRVR
START MANAGER
START *
START JAGENT

Command                                          Description 

INFO PMSRVR                        Returns information about the PMSRVR. 
START PMSRVR                    Starts the PMSRVR. 
STATUS PMSRVR                  Returns the state of the PMSRVR. 
STOP PMSRVR                      Stops the PMSRVR.
START PMSRVR                    Starts the PMSRVR.


GGSCI (prod01.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT       RUNNING
PMSRVR    STOPPED
EXTRACT    RUNNING     EXTPSTDB    00:00:00      00:00:00
EXTRACT    RUNNING     PMPUPDB    00:00:00      00:00:01
REPLICAT    RUNNING     REPTGDB      00:00:00      00:00:05

GGSCI (prod01.domain.com) 4> start pmsrvr
PMSRVR started

GGSCI (prod01.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT       RUNNING
PMSRVR    RUNNING
EXTRACT    RUNNING     EXTPSTDB    00:00:00      00:00:00
EXTRACT    RUNNING     PMPUPDB    00:00:00      00:00:00
REPLICAT    RUNNING     REPTGDB      00:00:00      00:00:01


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 if you do so you will
receive "command not found" type errors.


"start pmsrvr" will create and manage $OGG_HOME/dirbdb

Enable monitoring options are changed

ENABLEMONITORING [ UDP ]
ENABLEMONITORING [ UDP ] [ UDPPORT portnumber ] [ HTTPPORT portnumber ]

default port is 9004



Sunday, January 20, 2019

Oracle Goldengate 18.1 Install


Oracle released 18.1.0 in Oct 2018 and here i'll explaining on how to do new install of this release and i see no difference from 12c version and its same and very simple.

Before you install/Upgrade oracle goldengate to 18.1 you need to check the compatibility for your environment, you can check the compatible matrix below in oracle page

Also, According to oracle if you have multiple RDBMS versions like Oracle Database 11.2 and 12.1, you must have separate Oracle GoldenGate installations for each one.

The Classic Extract (capture) is deprecated as of Oracle GoldenGate 18c (18.1.0). This means that there will be no further enhancements to the Classic Capture (Extract) process.  

Download New 18c (18.1) goldengate version from oracle, here I'm NOT using Microservices Architecture





Download traditional one (highlighted) and copy to some location on server

mkdir -p /goldengate/ggsw/18.1_soft
devhost01:NOTSET:/goldengate/ggsw/18.1_soft $ ll
total 383516
-rw-r--r-- 1 oracle dba 392717701 Jan 15 17:01 181000_fbo_ggs_Linux_x64_shiphome.zip
devhost01:NOTSET:/goldengate/ggsw/18.1_soft $ unzip 181000_fbo_ggs_Linux_x64_shiphome.zip

devhost01:NOTSET:/goldengate/ggsw/18.1_soft $  ls -lrth
total 375M
drwxr-xr-x 3 oracle dba 4.0K Sep 29 14:13 fbo_ggs_Linux_x64_shiphome
-rw-r--r-- 1 oracle dba 196K Oct 10 11:22 OGG_WinUnix_Rel_Notes_18.1.0.0.0.pdf
-rw-r--r-- 1 oracle dba 1.4K Oct 10 11:28 OGG-18.1.0.0-README.txt
-rw-r--r-- 1 oracle dba 375M Jan 15 17:01 181000_fbo_ggs_Linux_x64_shiphome.zip


devhost01:NOTSET:/goldengate/ggsw/18.1_soft/fbo_ggs_Linux_x64_shiphome/Disk1 $ ls -lrth
total 16K
drwxr-xr-x  4 oracle dba 4.0K Sep 29 14:12 install
drwxr-xr-x 11 oracle dba 4.0K Sep 29 14:13 stage
-rwxr-xr-x  1 oracle dba  918 Sep 29 14:13 runInstaller
drwxrwxr-x  2 oracle dba 4.0K Sep 29 14:13 response
devhost01:NOTSET:/goldengate/ggsw/18.1_soft/fbo_ggs_Linux_x64_shiphome/Disk1 $ export DISPLAY=localhost:0.0
devhost01:NOTSET:/goldengate/ggsw/18.1_soft/fbo_ggs_Linux_x64_shiphome/Disk1 $ ./runInstaller


Once GUI is opened you can follow the steps as required for your environment by clicking "Next"

Oracle Goldengate 12c Installation can be found here : Goldengate12c_install




Wednesday, January 2, 2019

OEM unable to discover Goldengate targets



OEM Version : 13.2 
OGG Version     : 12.2

My OEM has goldengate plugin already installed and the Jagent is installed on the Sserver where my Goldenagte processes are running and When trying to discover Goldengate Targets from 13c OEM its not able to discover and below are the messages i see in the Goldengate monitoring agent instance log

JAGENT_INSTANCE_HOME/logs $ tail -20f ogg_agent.log

[2019-01-02T13:11:51.868-05:00] [JAGENT] [ERROR] [OGGMON-20603] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: quickUpdates] [ecid: 0000MWFh2__1j^^5xV9DiW1SBFfa000004,0] RESTful Web Service with name mpoints has become unresponsive
[2019-01-02T13:11:53.578-05:00] [JAGENT] [ERROR] [OGGMON-20610] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: MessageCollector] [ecid: 0000MWFh1Nk1j^^5xV9DiW1SBFfa000001,0] Could not connect to Message Web Service. Query String: messages/last
[2019-01-02T13:11:53.578-05:00] [JAGENT] [ERROR] [OGGMON-20603] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: MessageCollector] [ecid: 0000MWFh1Nk1j^^5xV9DiW1SBFfa000001,0] RESTful Web Service with name messages/last has become unresponsive
[2019-01-02T13:11:53.595-05:00] [JAGENT] [ERROR] [OGGMON-20610] [com.goldengate.monitor.jagent.comm.ws.ManagerService] [tid: MessageCollector] [ecid: 0000MWFh1Nk1j^^5xV9DiW1SBFfa000001,0] Could not connect to Message Web Service. Query String: messages/last

FIX:

GGSCI (prod01.domain.com) 1> info datastore
2019-01-02T18:11:00Z  WARNING OGG-06307  Datastore does not exist.

GGSCI (prod01.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT       RUNNING
EXTRACT    RUNNING     EXTPSTDB    00:00:00      00:00:00
EXTRACT    RUNNING     PMPUPDB    00:00:00      00:00:01
REPLICAT    RUNNING     REPTGDB      00:00:00      00:00:05

Stop all GG processes including mgr and jagent

Stop *
Stop mgr
Stop jagent

GGSCI (prod01.domain.com) 6> create datastore
Profile 'Trace' added.
2019-01-02T18:12:26Z  INFO    OGG-06489  Datastore created

Start mgr
Start jagent
Start *

GGSCI (prod01.domain.com) 1> info datastore
2019-01-02T18:20:08Z  INFO    OGG-06309  Datastore uses shared memory (SHM) environment files with a starting ID of 0x00000b00.


Now go to OEM and do the discovery again by adding GG discovery module parameters


Also Refer:
Not Able To Discover The Goldengate Targets On OEM12c (Doc ID 2277992.1)


Tuesday, January 1, 2019

Happy New Year 2019


Hello everyone i wish you all a wonderful Happy New Year 2019

As always i'll keep Blogging my Tech Experiences/Challenges to help myself and Visitors, Thank you all wish you Success and Good Luck, Cheers !!!
Auto Scroll Stop Scroll