Loading....

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

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.

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

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.

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

The USERID and PASSWORD parameter and required if you enable GoldenGate DDL support and this is the Oracle user account that we created for the Manager(and Extract/Replicat) as described in the earlier tutorial.

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.

The following is an example of a manager parameter file

[oracle@redhat346 ggs]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 11 on Sep 17 2009 23:51:28

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

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

Manager is running (IP port devu007.7809).

Coming Next – Configuring an Online Extract and Replicat Group …..

Please follow and like us:

Last Update: May 4, 2017  

February 11, 2010 166 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

, , , ,

8 thoughts on “GoldenGate Tutorial 3 – Configuring the Manager process

  1. Fernand

    Hi I’ve been following all the steps but I have a problem with the manager
    When I execute:
    ggsci> start manager

    A very window appears and goes very quick, then I execute:
    ggsci> info manager
    Manager is Down!

    How could I resolved the problem?

    Thanks

    fernand

  2. Gavin Soorma

    Hi – you can get some more details as to why the manager is failing to start – try VIEW REPORT MGR or VIEW GGSEVT – let me know if you can pick anything as to why the manager is not starting from running these commands

  3. Mink

    Hi, If the “view ggsevt” command doesn’t show anything unusual but the manager refuses to start and bind to any port.
    “2011-02-07 14:44:02 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params mgr.
    2011-02-07 14:45:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start manager.”

    And the params-fil for the manager is:
    “port 7809
    userid ggs_owner, password ggs_owner
    purgeoldextracts /opt/goldengate/dirdat/ex, usecheckpoints”

    what can the problem be (using 9.2.0.4)?

  4. asif28487205800

    Very good explanation!!!!!! I wish you add some more . Basic steps to troubleshoot MGR issues.

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?