Configuring Oracle GoldenGate

This topic discusses how to configure Oracle GoldenGate version 11.2.0

See the first part here for installatin of GoldenGate.

Below is the checklist that need to be met before configuring GoldenGate.

1. Network connectivity
2. Goldengate home  = /home/oracle/oracle_goldengate
3. source db server name , ip = voice, 192.168.1.7
4. source db hardware = intel
5. source os = linux 5.8
6. source db instruction length : 32 bit
7. source db name = voice
8. db version = 11.2.0.1.0
9. db in archive log mode : yes
10. supplemental logging enabled : yes 
11. # of extract process = 1
12. name of extract process = extract1
13. Local trail file = yes
14. size of trail file : 10mb
15. schema/table to be replicated : db_objects
16. kind of replication  : one-day
17. use data pump : yes
18. list the server data pump will run : source db server
19. data pump process name : ggdpump 
20. need ddl replciation : no
21. col mapping required : no
22. data transformation required : no
23. port # to be used between data pump and replicat process : 5555
24. how to instatiate golden gate target database : ---
25. schema objcts lack primary key ? no
26. any high-usage table that benefits from its own extract process ? no
27. if parallelism, any extract/replicat, any table with foreign keys? no
28. any triggers to be delt with in schemas to be replciated ? no
29. any cascading delete constraints that needs to be disabled ? no
30. target db server and ip ? oraten, 192.168.1.13
31. target db hardware : intel
32. database os and os version : linux 5.8
33. target db instruction length : 32bit
34. target db name : voice_gg
35. # or replicat process : 1
36. target replicate process name : replicat1
37.   schame replicating to : prajeeth_gg
38. method to user instantiation of target db : goldengate

There should be sufficient UNDO. So, increase the UNDO RETENTION to a desired value.

SQL> sho parameter undo_retention

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_retention                       integer     900
SQL> alter system set undo_retention = 1800;

System altered.
SQL>

Let us assume, we are interested in replicating SCOTT's tables from server1 to SCOTT's schema on server2.

	 Source Details
	 Scheam : scott
	 DB : db1
	 Server : server1
	 
	 Target Details
	 Scheam : scott
	 DB : db2
	 Server : server2
	 

Let us call extract process EXTPR1 and call replicat process REPPR1.

Assume, we are interested in two-way replication. This means that we need to configure both EXTRACT and REPLICAT on both the sides.

We need to create parameter for the following processes

All parameters are created in dirprm directory, under GoldenGate Home

Let us create the parameter for Manager

Open file mgr.prm and add the below parameters

PORT 7809
PURGEOLDEXTRACTS, USECHECKPOINTS
Comments