knowledge is power – share it · web vieworacle goldengate 18c and oracle goldengate cloud...

1

Oracle GoldenGate 18c and GoldenGate Cloud Services Workshop

Hands-on Lab Exercise 15

Creating a GoldenGate 18c Microservices Deployment

Oracle GoldenGate 18c and Oracle GoldenGate Cloud Services Workshop Lab Exercise 15

2

Launch Service Manager

Note: the port 9010 was specified when we installed Service Manager

http://192.168.56.100:9010

Connect as the oggadmin user account which was created as part of the Service Manager deployment installation.


http://192.168.56.100:9010/

3Oracle GoldenGate 18c and Oracle GoldenGate Cloud Services Workshop Lab Exercise 15

4

Click on the Administration Server port link (9011)


6

Expand the menu on the top left corner.

Click on Configuration


8

Create the Credentials


10

Verify that the checkpoint table exists, and that supplemental logging is also enabled for the MYOBJECTS table and also the DEMO schema.

Click on the icon to login to the database. Connect to the PDB1 database


11

In case we have dropped and recreated the MYOBJECTS table in an earlier lab, we will need to enable supplemental logging for the schema or the table again. Here we can see that no tables in the DEMO schema have supplemental logging enabled

Click on the ‘+’ icon to add Trandata


13

Create a new task to Auto Start all the extract processes

Note: this is assuming the process names all start with an ‘E’


15

Create an Integrated Extract

Click on Overview link in navigation menu and then on the ‘+’ icon


18

Note: Edit the parameter file and add the SOURCECATALOG and TABLE parameters


19

Click on Create


20

Start the Integrated Extract


22

Create a Distribution Server Path

Click on the Distribution Server Port (9012)

Click on the ‘+’ icon


23

The source for the path is the Integrated Extract we just created EXTMS1

We will use the conventional Classic GoldenGate transmission method as opposed to using Web Sockets – select ogg.

The target for the Distribution Server Path is the Receiver Server – enter the name of the remote trail and the port number of the Receiver Server


25

Click on Create and Run


26

Create the Replicat (Classic non-Integrated)

Go back to the Admin Server Overview tab in the browser and click on the ‘+’ icon


29

Edit the MAP parameter

Click on Create and Run

We can get more details about the Extract and Replicat by clicking on the Action button


33

Perform DML activity on the source database PDB1

On the source database, insert some records into the MYOBJECTS table and commit the transaction.

SQL> conn demo/oracle@pdb1Connected.

SQL> insert into myobjects select * from all_objects;

68237 rows created.

SQL> commit;

Commit complete.


34

Click on the Statistics tab.


35

On the Distribution Server home page, note the Path statistics


37

Check the Replicat statistics


38

From the Service Manager home page, click on the Performance Metrics Server link


39

Obtain performance metrics for each of the GoldenGate processes by clicking on the process names.


42

Using the Admin Client

[oracle@rac01 bin]$ export OGG_HOME=/acfs_oh/app/goldengate_ms

[oracle@rac01 bin]$ export OGG_CONF_HOME=/acfs_oh/app/goldengate_ms/svcmgr/etc/conf

[oracle@rac01 bin]$ export OGG_VAR_HOME=/acfs_oh/app/goldengate_ms/svcmgr/var

[oracle@rac01 bin]$ cd $OGG_HOME/bin

[oracle@rac01 bin]$ ./adminclient Oracle GoldenGate Administration Client for OracleVersion 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432

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

Linux, x64, 64bit (optimized) on Sep 28 2018 14:02:02Operating system character set identified as UTF-8.

OGG (not connected) 2> connect http://localhost:9010 deployment lab as oggadmin password Welcome1

OGG (http://localhost:9010 lab) 21> info all Program Status Group Lag at Chkpt Time Since Chkpt

ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT RUNNING EXTMS1 00:00:00 00:00:07 REPLICAT RUNNING REPMS1 00:00:00 00:00:01


43

OGG (http://localhost:9010 lab) 23> status deployment labDeployment Status

lab RUNNING

OGG (http://localhost:9010 lab) 24> health deployment lab

Deployment: lab Service: adminsrvr Status: running Started: 2019-02-03T03:25:24.186Z Health: OK Resources: Name Type Status Health -------------------------------- ---------- ---------- ------

Deployment: lab Service: distsrvr Status: running Started: 2019-02-03T03:25:23.964Z Health: OK Resources: Name Type Status Health -------------------------------- ---------- ---------- ------

Deployment: lab Service: recvsrvr Status: running Started: 2019-02-03T03:25:23.628Z Health: OK Resources: Name Type Status Health -------------------------------- ---------- ---------- ------


44

OGG (http://localhost:9010 lab) 31> info distpath all PUMPMS1 running

OGG (http://localhost:9010 lab) 32> info distpath PUMPMS1

Path Name: PUMPMS1 Status: running Source URI: trail://192.168.56.100:9012/services/v2/sources?trail=xx Target URI: ogg://localhost:9013/services/v2/targets?trail=yy

OGG (http://localhost:9010 lab) 33> info distpath PUMPMS1 detail

Path Name: PUMPMS1 Status: running Source: trail://192.168.56.100:9012/services/v2/sources?trail=xx Target: ogg://localhost:9013/services/v2/targets?trail=yy SizeMB: 500 Sequence Length: 9 Encryption Algorithm: None Begin Position: seqno 0 rba 0 AutoRestart: retries 0 EOF Delay: 100 CSecs Critical: no

Process Id: 30555 Thread Id: 140706215618304 Last Started: 2019-02-03T05:32:52.801Z Source Database Name: CDB1


45

Processing Lag: 0 Since Lag Reported: 4

Checkpoints: Input Checkpoint: Current: Name: xx Sequence: 1 Offset: 28783753 Path: /acfs_oh/app/goldengate_ms/deployment/lab/var/lib/data/ Sequence Length: 9 Sequence Length Flip: no Timestamp: 2019-02-03T05:40:59.000Z Starting: Name: xx Sequence: 0 Offset: 0 Path: /acfs_oh/app/goldengate_ms/deployment/lab/var/lib/data/ Sequence Length: 9 Sequence Length Flip: no Timestamp: 0000-01-01T00:00:00.000Z Output Checkpoint: Current: Name: yy Sequence: 1 Offset: 28783825 Path: unknown Sequence Length: 9 Sequence Length Flip: no Timestamp: 2019-02-03T06:04:57.180Z


46

OGG (http://localhost:9010 lab) 34>

Parameter File Location

[oracle@rac01 ogg]$ pwd/acfs_oh/app/goldengate_ms/deployment/lab/etc/conf/ogg

[oracle@rac01 ogg]$ ls -ltotal 16-rw-r----- 1 oracle oinstall 118 Feb 3 09:24 EXTMS1.prm-rw-r----- 1 oracle oinstall 21 Feb 3 08:42 GLOBALS-rw-r----- 1 oracle oinstall 119 Feb 3 13:36 REPMS1.prm-rw-r----- 1 oracle oinstall 111 Feb 3 13:24 REPMS1.prm.bak

Trail File Location

[oracle@rac01 data]$ pwd/acfs_oh/app/goldengate_ms/deployment/lab/var/lib/data

[oracle@rac01 data]$ ls -ltotal 64936-rw-r----- 1 oracle oinstall 1415 Feb 3 13:01 xx000000000-rw-r----- 1 oracle oinstall 28783753 Feb 3 13:41 xx000000001-rw-r----- 1 oracle oinstall 1486 Feb 3 13:32 yy000000000-rw-r----- 1 oracle oinstall 28783825 Feb 3 13:49 yy000000001


47

Report File Location

[oracle@rac01 report]$ pwd/acfs_oh/app/goldengate_ms/deployment/lab/var/lib/report

[oracle@rac01 report]$ ls -lrttotal 116-rw-r----- 1 oracle oinstall 155 Feb 3 09:33 EXTMS12.dsc-rw-r----- 1 oracle oinstall 19721 Feb 3 09:33 EXTMS12.rpt-rw-r----- 1 oracle oinstall 155 Feb 3 11:35 EXTMS11.dsc-rw-r----- 1 oracle oinstall 5130 Feb 3 11:35 EXTMS11.rpt-rw-r----- 1 oracle oinstall 5031 Feb 3 12:55 EXTMS10.rpt-rw-r----- 1 oracle oinstall 155 Feb 3 12:55 EXTMS10.dsc-rw-r----- 1 oracle oinstall 115 Feb 3 13:00 EXTMS1.dsc-rw-r----- 1 oracle oinstall 3698 Feb 3 13:12 REPMS11.rpt-rw-r----- 1 oracle oinstall 213 Feb 3 13:28 REPMS10.dsc-rw-r----- 1 oracle oinstall 10389 Feb 3 13:28 REPMS10.rpt-rw-r----- 1 oracle oinstall 116 Feb 3 13:36 REPMS1.dsc-rw-r----- 1 oracle oinstall 5074 Feb 3 13:43 EXTMS1.rpt-rw-r----- 1 oracle oinstall 4714 Feb 3 13:56 REPMS1.rpt


knowledge is power – share it · web vieworacle goldengate 18c and oracle goldengate cloud...

Documents