Tuesday, July 20, 2010

Installing Oracle GoldenGate on Windows (Normal and Clustered)

Installing Oracle GoldenGate on Windows (Normal and Clustered)
Step 1.
To specify Oracle variables on Windows systems
On the desktop or Start menu (depending on the Windows version), right-click My
Computer, and then select Properties.
In Properties, click the Advanced tab.
Click Environment Variables.
Under System Variables, click New.
For Variable Name, type ORACLE_HOME.
For Variable Value, type the path to the Oracle binaries.
Click OK.
Click New again.
For Variable Name, type ORACLE_SID.
For Variable Value, type the instance name.
Click OK.

Step 2.
Unzip the GoldenGate software into a folder on your drive.

Step 3:
Download the Visual C++ Redistributable Packege from below link:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9b2da534-3e03-4391-8a4d-074b9f2bc1bf&displaylang=en

Step 4:
Go the GoldenGate directory through command prompt and type:
GGSCI
It will bring the GoldenGate prompt, In the GoldenGate prompt type:
CREATE SUBDIRS
EXIT
Again type GGSCI and in there type:
EDIT PARAMS MGR
It should open a text editor, in the text editor type
PORT 7809
And save the file.
Note: you can gave any available port.
Step 5.
Type exit from the GGSCI prompt and type following command to register manager as a window service:
Install ADDSERVICE
In the GGSCI prompt type START MANAGER to start manager and STOP MANAGER to stop manager.
After that type
Install ADDEVENTS
Install addevents Adds Oracle GoldenGate events to the Windows Event Manager. By default, Oracle GoldenGate errors are generic. To produce more specific error content, copy the following files from the Oracle GoldenGate installation directory to the SYSTEM32 directory.
category.dll
ggsmsg.dll

Adding Oracle GoldenGate as a Windows cluster resource

* In the Cluster Administrator, select File>New>Resource.
* In the New Resource dialog box, provide a descriptive name for the Oracle GoldenGate
Manager (need not be its actual name). For Resource Type, select Generic Service. For Group,
select the group that contains the database instance to which Oracle GoldenGate will connect
* Click Next.
* In the Possible Owners dialog box, select the nodes on which Oracle GoldenGate will run.
* Click Next.
* In the GGS Manager Service Properties dialog box, click the Dependencies tab, and add the
following to the Resource dependencies list:
The database resource group
The disk resource containing the Oracle GoldenGate directory
The disk resource containing the database transaction log files
The disk resource containing the database transaction log backup files
*Click Apply, then OK.
In the Generic Service Parameters dialog box, type either the default Manager service name
of GGSMGR or, if applicable, the custom name specified in the GLOBALS file.
*Click Next.
*Click Finish to exit the wizard.
In the Cluster Administrator tree, right-click the Manager resource and select Properties.
* Click the Advanced tab, and deselect Affect the Group. This is a recommendation, but you
can configure it as needed for your environment.
* Click Apply.
* Bring the cluster resource online to verify that it was installed correctly.
* Take the resource offline again.
* Move the group to the next node in the cluster. When the group has been successfully
moved to the second node, the Manager resource should still be offline.
* Log onto the second node.
* Install Oracle GoldenGate Manager as a service on this node by running the install
program as you did on the previous node. If you created a custom name for Manager in
the GLOBALS file, that name will be used.
* Bring the resource online to verify that it is running correctly on this node.
* Repeat from step 16 for each additional node in the cluster.

1 comment:

  1. How do you configure extract and replicate to shutdown gracefully during the rollover ?

    ReplyDelete