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.

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

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

4

Click on the Administration Server port link (9011)

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

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

6

Expand the menu on the top left corner.

Click on Configuration

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

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

8

Create the Credentials

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

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

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

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

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

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

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

13

Create a new task to Auto Start all the extract processes

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

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

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

15

Create an Integrated Extract

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

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

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

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

18

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

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

19

Click on Create

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

20

Start the Integrated Extract

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

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

22

Create a Distribution Server Path

Click on the Distribution Server Port (9012)

Click on the ‘+’ icon

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

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

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

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

25

Click on Create and Run

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

26

Create the Replicat (Classic non-Integrated)

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

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

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

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

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

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

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

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

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

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.

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

34

Click on the Statistics tab.

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

35

On the Distribution Server home page, note the Path statistics

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

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

37

Check the Replicat statistics

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

38

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

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

39

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

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

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

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

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

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

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 -------------------------------- ---------- ---------- ------

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

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

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

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

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

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

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

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

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