CONFIGURING THE MANAGER PROCESS

-
                              CONFIGURING THE MANAGER PROCESS

i)The Oracle GoldenGate Manager performs a number of functions like starting
the other GoldenGate processes, trail log file management and reporting.

ii)The Manager process needs to be configured on both the source as well as target
systems and configuration is carried out via a parameter file just as in the case of
the other GoldenGate processes like Extract and Replicat.


iii)After installation of the software, we launch the GoldenGate Software
Command Interface (GGSCI) and issue the following command to edit the
Manager parameter file
EDIT PARAMS MGR

iv)The only mandatory parameter that we need to specify is the PORT which
defines the port on the local system where the manager process is running. The
default port is 7809 and we can either specify the default port or some other port
provided the port is available and not restricted in any way.

v)Some other recommended optional parameters are AUTOSTART which which
automatically start the Extract and Replicat processes when the Manager starts.

vi)The USERID and PASSWORD parameter and required if you enable
GoldenGate DDL support and this is the Oracle user account that we created for

vii)The Manager process can also clean up trail files from disk when GoldenGate
has finished processing them via the PURGEOLDEXTRACTS parameter. Used
with the USECHECKPOINTS clause, it will ensure that until all processes have
fnished using the data contained in the trail files, they will not be deleted.


[oracle@redhat346 ggs]$ ./ggsci

GGSCI 2> EDIT PARAMS MGR
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /u01/oracle/ggs/dirdat/ex, USECHECKPOINTS
The manager can be stopped and started via the GSSCI commands START
MANAGER and STOP MANAGER .
Information on the status of the Manager can be obtained via the INFO
MANAGER command

GGSCI (devu007) 4> info manager

Comments

Post a Comment

Popular posts from this blog

Oracle Golden Gate FAQ

-
Image
                                                      Oracle Golden Gate FAQ Q. What type of Topology does Goldengate support? GoldenGate supports the following topologies. 1. Unidirectional 2. Bidirectional 3. Peer-to-peer 4. Broadcast 5. Consolidation 6. Cascasding Q. What are the main components of the Goldengate replication? The replication configuration consists of the following processes. 1. Manager 2. Extract 3. Pump 4. Replicate Q. What transaction types does Goldengate support for Replication? Goldengate supports both DML and DDL Replication from the source to target. Q. What are the supplemental logging pre-requisites? The following supplemental logging is required. 1. Database supplemental logging 2. Object level logging Q. Why is Supplemental logging required for Replication? Integrated Capture (IC): 1. In the...
Read more

Oracle Golden gate - Long running transactions while stopping an extract

-
Oracle Golden gate  - Long running transactions while stopping an extract ? Below is how you can find it out and kill if needed. GGSCI (ggnode1) 7>send extract EXRAJ, showtrans duration 20 MIN Sending showtrans request to EXTRACT EXRAJ ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 74058, SCN 1586.3900894393 (6815719025849), RBA 104066064 Redo Thread 2, Redo Log Sequence Number 79546, SCN 1586.3894494112 (6815712625568), RBA 1458358288 ------------------------------------------------------------ XID:                  1630.17.201166 Items:                1        Extract:              EXRAJ    Redo Thread:          1      Start Time:           2013-05-10:21:43:50  SCN:      ...
Read more

FAQ on Oracle Golden gate for unix & windows

-
                                        FAQ on Oracle Golden gate for unix & windows 1.What is the purpose of running   the Reverse utility • To restore a test database to its original state before the test run. Because the Reverse utility only backs out changes, a test database can be restored in a matter of minutes, much more efficiently than a complete database restore, which can take hours. • To reverse errors caused by corrupt data or accidental deletions. For example, if an UPDATE or DELETE command is issued without a WHERE clause, the Reverse utility reverses the operation. 2.What needs to do for using the Reverse utility • Run Extract to extract the before data. • Run the Reverse utility to perform the reversal of the transactions. • Run Replicat to apply the restored data to the target database. 3.How the Reverse utility reverses the fo...
Read more