The Manager process must be running on both Source and target systems. The Manager process starts Oracle GoldenGate processes, performs trail management, and starts dynamic processes.Oracle GoldenGate Installation has one manager process which supports multiple Extract and Replicat processes. We can simply say. without starting the manager we can’t start any of the golden gate processs like extract, datapump, replicate
All the below manager setup need to be done on both source and target system.
Go to golden gate directory and create the manager param file.
$ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21 Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. GGSCI (source) 2>EDIT PARAMS MGR PORT 7809 USERID GGATE, PASSWORD ggate#xerox2013 DYNAMICPORTLIST 7810-7820, 7830 PURGEOLDEXTRACTS /u02/oradata/gg/dirdat/*, USECHECKPOINTS, MINKEEPDAYS 1 AUTOSTART ER * AUTORESTART ER *, RETRIES 4, WAITMINUTES 4
PORT: parameter defines on which port the manager process will run on the local system. Default port is 7809. PORT is the only required Manager parameter.GGSCI uses this port to request Manager to start processes.
DYNAMICPORTLIST : is used to specify 256 unreserved, unrestricted ports for dynamic TCP/IP communications between the source and target systems. The Collector, Extract, Replicat will use these ports. Collector port will be started on 7840 if this parameter is not specified and if 7840 is not available then Manager Increments by and starts it on the available port.
AUTOSTART: is used to start the Extract & Replicat processes when manager starts.
Syntax: AUTOSTART {ER | EXTRACT | REPLICAT} {group name | wildcard}
AUTORESTART is used to start the Extract & Replicat processes after abnormal termination.
AUTORESTART {ER | EXTRACT | REPLICAT} {group name | wildcard}
[, RETRIES <max retries>]
[, WAITMINUTES <wait minutes>]
[, RESETMINUTES <reset minutes>]
PURGEOLDEXTRACTS: is a Trail Maintenance parameter. This parameter is used to purge trail files when Oracle GoldenGate has finished processing them. No purging is performed without this parameter, and this may lead to the consumption of significant disk space.
This parameter is recommended to use in the Manager Parameter file rather than using it in Extract or Replicat parameter files because you can manage trail files in a centralized fashion when multiple processes are configured.
When PURGEOLDEXTRACT is used with USECHECKPOINTS clause, it will ensure that until all processes have finished using the datacontained in the trail files, they will not be deleted
If using Oracle GoldenGate DDL support, specify the Manager user and password with the
USERID parameter.
Start the manager process:
$ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21 Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved. GGSCI (source) 1>start mgr Manager started.
