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.