Oracle GoldenGate - Installation on Windows - Part 4

Setting up GoldenGate Manager Process

Having completed the database user creation, we can now move on to define a GoldenGate Manager process, which is vital for a variety of tasks like reporting.

10) It is also very important to setup a GoldenGate Manager process which is used for a variety of purposes like reporting and so on. At this stage, if I execute the "info manager" command in GGSCI, I get the following output



C:\GoldenGate>GGSCI

Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Windows (optimized), Oracle 10 on Sep 18 2009 15:54:55

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



GGSCI (Home) 1> info manager

Manager is DOWN!


GGSCI (Home) 2>

We will now setup the manager in Windows. Issue the command "EDIT PARAMS MGR". If this is the first time you are doing this, you may get the following prompt from Windows

Cannot find the C:\GoldenGate\dirprm\mgr.prm file.

Do you want to create a new file?

Respond with Yes. You have to specify the USERID, port and login information in the manager parameter file. This is provided below [ save the file after this ]

PORT 9500
USERID ggate,PASSWORD ggate
PURGEOLDEXTRACTS C:\purge,USECHECKPOINTS


10) Now, issue the START MANAGER command from GGSCI, a new window will open up [ If windows firewall is enabled, it will request for a unblock to allow communication on the defined port. Grant the required access in this case ]. A log of the manager process is given below

***********************************************************************
                 Oracle GoldenGate Manager for Oracle
                      Version 10.4.0.19 Build 002
        Windows (optimized), Oracle 10 on Sep 18 2009 15:53:58

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


                    Starting at <date time>
***********************************************************************

Operating System Version:
Microsoft Windows Vista Home Premium Edition, on x86
Version 6.0 (Build 6002: Service Pack 2)

Process id: 5912

Parameters...

PORT 9500
USERID ggate,PASSWORD ggate
PURGEOLDEXTRACTS C:\purge,USECHECKPOINTS


***********************************************************************
**                     Run Time Messages                             **
***********************************************************************


<datetime> GGS INFO        330  Manager started (port 9500).



GGSCI would respond to the START MANAGER command with the following information


C:\GoldenGate>GGSCI

Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Windows (optimized), Oracle 10 on Sep 18 2009 15:54:55

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



GGSCI (Home) 1> info manager

Manager is DOWN!


GGSCI (Home) 2> start manager

Manager started.


GGSCI (Home) 3>


When you issue 'info manager' at this stage, you would get the following response

'Manager is running. (IP Port Home:9500)', You can use the STOP MANAGER command to stop the manager at any time. When you issue STOP MANAGER, you will get the following prompt


GGSCI (Home) 4> stop manager
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y=> response to be provided by the user

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.



That completes the guide of GoldenGate installation.We are now ready to move on with the next step in GoldenGate. Extracting data from logs and tables.

10 comments:

  1. thanks for your excellent post on goldengate installation on windows machine.

    Can you please post or share how to Extract/replicate data from one oracle database to another with sample example. Alos looking to replicate partial table data. It will be great if you can share this.

    ReplyDelete
  2. Hello,
    we meet a problem in our first golden gate installation. The Extract data pump Process (named ODIT1P) Abends after starting, with the following error message on log file:

    2010-05-12 15:26:42 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-12 15:26:44 GGS ERROR 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l’hôte distant.); retries exceeded.
    2010-05-12 15:26:44 GGS ERROR 190 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: PROCESS ABENDING.

    what do we do to bypass this issue please

    ReplyDelete
  3. @Abdelhamid

    Can you post your extract code and the contents inside the log file?

    ReplyDelete
  4. @yellowRose
    I built my configuration in a localhost (source, staging, and target)

    My primary extract groupe's code is:
    extract ODISC
    userid system, password system
    exttrail C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc
    TABLE GG_TEST_SRC.CUSTOMERS;

    My data pump extract's code is:
    extract ODIT1P
    userid system, password system
    rmthost localhost, mgrport 7910
    rmttrail C:\GoldenGate\GoldenGate_Stg/dirdat/ODIT1op/op
    TABLE GG_TEST_SRC.CUSTOMERS;

    My replicat groupe's code is:
    replicat ODIT1A1
    userid system, password system
    discardfile C:\GoldenGate\GoldenGate_Stg/dirrpt/ODIT1.dsc, purge
    sourcedefs C:\GoldenGate\GoldenGate_Stg/dirdef/ODISC.def
    map GG_TEST_SRC.CUSTOMERS, TARGET GG_TEST_STG.CUSTOMERS, KEYCOLS (ID);
    map GG_TEST_SRC.CUSTOMERS, target GG_TEST_STG.J$CUSTOMERS, KEYCOLS (ID, WINDOW_ID), INSERTALLRECORDS, OVERRIDEDUPS,
    COLMAP (
    ID = ID,

    WINDOW_ID = @STRCAT(@GETENV("RECORD", "FILESEQNO"), @STRNUM(@GETENV("RECORD", "FILERBA"), RIGHTZERO, 10))
    );

    ReplyDelete
  5. @YellowRose

    A contents inside a log file part 1 are:
    Sourc log is:
    2010-05-14 10:21:44 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start mgr.
    2010-05-14 10:22:01 GGS INFO 330 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7909).
    2010-05-14 10:24:05 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start ODISC.
    2010-05-14 10:24:05 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.27.68 (START EXTRACT ODISC ).
    2010-05-14 10:24:05 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT ODISC starting.
    2010-05-14 10:24:23 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODISC.prm: EXTRACT ODISC starting.
    2010-05-14 10:24:24 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start ODIT1P.
    2010-05-14 10:24:25 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.27.68 (START EXTRACT ODIT1P ).
    2010-05-14 10:24:25 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT ODIT1P starting.
    2010-05-14 10:24:44 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: EXTRACT ODIT1P starting.
    2010-05-14 10:24:44 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: EXTRACT ODIT1P started.
    2010-05-14 10:24:46 GGS WARNING Z1-078 Oracle GoldenGate Capture for Oracle, ODISC.prm: No valid default archive log destination directory found for thread 1.
    2010-05-14 10:24:49 GGS INFO 310 Oracle GoldenGate Capture for Oracle, ODISC.prm: EXTRACT ODISC started.
    2010-05-14 10:24:49 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ODISC.prm: Recovery initialization completed for target file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc000007, at RBA 1035.
    2010-05-14 10:24:49 GGS INFO Z0-05M Oracle GoldenGate Capture for Oracle, ODISC.prm: Output file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc is using format RELEASE 10.4.
    2010-05-14 10:24:49 GGS INFO 224 Oracle GoldenGate Capture for Oracle, ODISC.prm: Rolling over remote file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc000007.
    2010-05-14 10:24:49 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ODISC.prm: Recovery completed for target file C:\GoldenGate\GoldenGate_Src/dirdat/ODISoc/oc000008, at RBA 1035.
    2010-05-14 10:24:49 GGS INFO 112 Oracle GoldenGate Capture for Oracle, ODISC.prm: Recovery completed for all targets.
    2010-05-14 10:24:50 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:24:51 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:24:52 GGS INFO 220 Oracle GoldenGate Capture for Oracle, ODISC.prm: Found crash recovery marker from thread #1 on sequence 7 at RBA 1040. Aborting uncommitted transactions.
    2010-05-14 10:24:56 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).

    ReplyDelete
  6. @Yellow rose
    My replicat logfile :

    2010-05-14 10:22:42 GGS INFO 399 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (USER-71GFK3J): start mgr.
    2010-05-14 10:22:59 GGS INFO 330 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7910).
    2010-05-14 10:24:45 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
    2010-05-14 10:24:45 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7842).
    2010-05-14 10:25:03 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
    2010-05-14 10:25:03 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7843).
    2010-05-14 10:25:22 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
    2010-05-14 10:25:22 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7844).
    2010-05-14 10:25:40 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
    2010-05-14 10:25:40 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7845).
    2010-05-14 10:25:58 GGS INFO 301 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host 127.0.0.1 (START SERVER CPU -1 PRI -1 PARAMS ).
    2010-05-14 10:25:58 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7846).

    ReplyDelete
  7. A contents inside a log file part 2 are:
    2010-05-14 10:24:57 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:25:08 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:25:09 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:25:14 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:25:15 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:25:27 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:25:28 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:25:33 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:25:34 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:25:45 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:25:46 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:25:52 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:25:53 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:26:03 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:26:04 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.).
    2010-05-14 10:26:09 GGS INFO 406 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: Socket buffer size set to 27985 (flush size 27985).
    2010-05-14 10:26:10 GGS ERROR 150 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: TCP/IP error 10054 (Une connexion existante a dû être fermée par l'hôte distant.); retries exceeded.
    2010-05-14 10:26:10 GGS ERROR 190 Oracle GoldenGate Capture for Oracle, ODIT1P.prm: PROCESS ABENDING.

    ReplyDelete
  8. Hello

    I followed all the previous steps, the enviroment variables, the conection to the database, the creattion of directories using gssci, all seams ok.
    But I am trying to make the manager start and still with the same problem
    When I execute

    ggsci> start manager
    manager started

    ggscia> info manager
    Manager is DOWN!

    Can anyone help me to find the problem? I will appreciate.

    Thanks

    ReplyDelete
  9. Great site. A lot of useful information here. I’m sending it to some friends!

    ReplyDelete
  10. I have a question about Flashback Data Archive tables in Goldengate replication. Are these tables usually excluded in an extract like "TABLEEXCLUDE .SYS_FBA_*"?
    What is the approach for replicating and initial load of Flash Back Data Archive tables?
    Here is my problem. I exported a user schema using Oracle DataPump, imported into destination database. GoldenGate abended saying some tables dont exist on dest. I checked tables and there were about 200 tables that were not exported because they are FBDA tables and DataPump just ignores them. So, I recreated them on source with scripts.
    So, how is this done? Source and destination have their own FBDA and these tables should not be neither recreated with scripts on dest or replicated? Or they have to be replicated with contents?

    ReplyDelete