Management Pack for Oracle GoldenGate (Oracle GoldenGate Director)

When you download management pack for oracle goldengate, you have two files, director server and director client.
Here is the brief information on each of them.

Oracle GoldenGate Director is a multi-tiered client-server application that enables the configuration and management of Oracle GoldenGate instances from a remote client.

Oracle GoldenGate instances
Each instance of an Oracle GoldenGate Manger process is identified within Oracle GoldenGate Director by the fully qualified domain name of the host, the port on which Manager is listening, and a user-defined data source name.
Because a Manager process is associated with a database, this combination is identified as a data source within the Oracle GoldenGate Director Client application.

Oracle GoldenGate Director Server
Oracle GoldenGate Director Server coordinates the management of Oracle GoldenGate instances. Oracle GoldenGate Director Server is installed as an Oracle Weblogic Server domain.
Oracle GoldenGate Director Server is composed of the following applications:
● The Oracle GoldenGate Director Server application, a collection of services that controls security, host information services, object modeling, diagramming,
consolidated event logging, and alert services.
● The Monitor Agent, a client to the Oracle GoldenGate hosts that establishes a dedicated session of GGSCI (GoldenGate Software Command Interface).
The connection is used to obtain process status and event information.

Oracle GoldenGate Director database
Oracle GoldenGate Director Server uses a database as a central repository to store information about users and groups, graphical diagrams created by users, consolidated events, and other information.
A user can log into any Oracle GoldenGate Director Client on any system and retrieve his or her own stored view of the network.

Oracle GoldenGate Director Client
Oracle GoldenGate Director Client is a client application of Oracle GoldenGate Director Server that provides a graphical user interface (GUI) for managing Oracle GoldenGate instances.
The client runs on any platform that supports Java and enables drag-and-drop manipulation, menus and toolbars, and other functionality expected of a desktop application.

Oracle GoldenGate Director Web
Oracle GoldenGate Director Web is a web application that is hosted within Oracle GoldenGate Director Server. It allows remote, browser-based monitoring and control of
Oracle GoldenGate instances without the need to install software on the client system.

Oracle GoldenGate Director Administrator
Oracle GoldenGate Director Administrator is a client of Oracle GoldenGate Director Server and is used for configuring Oracle GoldenGate Director Server itself. You can use it to add
or remove Oracle GoldenGate instances and users, and to manage the overall Oracle GoldenGate Director configuration.

So, in all, these components are all for user convinience and management pack is nothing but the combination of all above director tools which helps user to monitor and manage the goldengate.

You can refer to the admin guide for management pack on how and where to install the server and related client tools and to check how they are linked to each other.

Oracle GoldenGate 11g Installation on IBM AIX 6x (RAC and Single Instance)

Oracle GoldenGate 11g Installation on IBM AIX 6x

Supported Platforms:

Databases:

Oracle 9.2 (DML and DDL support)

Oracle 10.1 and 10.2 (DML and DDL support)

Oracle 11g (DML and DDL support)

Pre-requisites:

The Oracle GoldenGate GGSCI command interface fully supports up to 300 concurrent Extract and Replicat processes per instance of Oracle GoldenGate. Each Extract and Replicat process needs approximately 25-55 MB of memory, or more depending on the size of the transactions and the number of concurrent transactions.

Disk requirements

Assign the following free disk space:

50-150 MB, depending on the database and platform. This includes space for the compressed download file and space for the uncompressed files. You can delete the download file after the installation is complete.

To install Oracle GoldenGate into a cluster environment, install the Oracle GoldenGate binaries and files on a shared file system that is available to all cluster nodes.

Additional disk space on any system that hosts Oracle GoldenGate trails, which are files that contain the working data. The space that is consumed by the trails varies, depending on the volume of data that will be processed. A good starting point is 1 GB. Use the following formula to calculate the required disk space.

[log volume in one hour] x [number of hours downtime] x .4 = trail disk space

Oracle RAC requirements

To install Oracle GoldenGate in an Oracle Real Application Cluster (RAC) environment, install Oracle GoldenGate on the shared drive(s) that are accessed by the RAC nodes. This allows you to start the Oracle GoldenGate processes from any of the nodes. If the node where they are running fails, you can start them on another node without modifying parameter files, because the processing checkpoints are preserved in the installation directory.

All nodes in the RAC cluster must have synchronized system clocks. These clocks must be synchronized with the clock on the system where Extract is executed. Oracle GoldenGate compares the time of the local system to the commit timestamps to make critical decisions.

TCP/IP

Configure the system to use TCP/IP services, including DNS. A range of ports for local Oracle GoldenGate communications: can be the default range starting at port 7840 or a customized range of up to 256 other ports.

Configure your firewalls to accept connections through the Oracle GoldenGate ports.

Operating system privileges

To install on IBM AIX or any UNIX system, the user installing Oracle GoldenGate must have read and write privileges on the Oracle GoldenGate installation directory. On AIX or UNIX systems, that user must be a member of the group that owns the Oracle instance.

Database user

Create a database user that is dedicated to Oracle GoldenGate. It can be the same user for all of the Oracle GoldenGate processes that must connect to a database.

Oracle recycle bin

Because of a known issue in Oracle 10g, the Oracle recycle bin must be turned off to support Oracle GoldenGate DDL replication. If the recycle bin is enabled, the Oracle GoldenGate DDL trigger session receives implicit recycle bin DDL operations that cause the trigger to fail.

Installation Steps:

Setting Environment Variables:

Make certain that the ORACLE_HOME and ORACLE_SID system environment variables are set to the correct Oracle instance. The Oracle GoldenGate processes refer to them when connecting to the database.

PATH=<absolute path of installation directory>:$PATH

export PATH

Note : On  IBM AIX the shared libraries vairiable would be   LIBPATH so, 
LIBPATH = <absolute path of installation directory>

Export  LIBPATH

Installing into a UNIX or Linux cluster

To install Oracle GoldenGate into a cluster environment, install the Oracle GoldenGate binaries and files on a file system that is available to all cluster nodes, according to the directions that follow.

After installing Oracle GoldenGate, configure the Manager process within the cluster application, as directed by the cluster documentation, so that Oracle GoldenGate will fail over properly with the other applications.

Installing the Oracle GoldenGate files

Extract the Oracle Oracle GoldenGate mediapack.zip file to the AIX or unix system and directory where you want Oracle GoldenGate to be installed.

Run the command shell and change directories to the new Oracle GoldenGate directory.

From the Oracle GoldenGate directory, run the GGSCI program.

GGSCI

In GGSCI, issue the following command to create the Oracle GoldenGate working directories.

CREATE SUBDIRS

Issue the following command to exit GGSCI.

EXIT

Oracle GoldenGate parameters settings for RAC

On AIX and Solaris machines, use the Extract parameter THREADOPTIONS with the BINDCPU option. This parameter handles thread-safety issues related to memory that is updated by different processors.

Oracle GoldenGate queues data in memory before sending it to the target system. The INQUEUESIZE and OUTQUEUESIZE options of the THREADOPTIONS parameter determine how much data to queue. If needed, you can increase the performance of Extract on Oracle RAC by tuning these parameters.

Special procedures on RAC

If the primary database instance against which Oracle GoldenGate is running stops or fails for any reason, Extract will abend. To resume processing, you can restart the instance, or you can mount the Oracle GoldenGate binaries to another node where the database is running and then restart the Oracle GoldenGate processes. Stop the Manager process on the original node before starting Oracle GoldenGate processes from another node.

Any time the number of redo threads changes, the Extract group must be dropped and re-created.

Applying database patches and upgrades when DDL support is enabled

Database patches and upgrades usually invalidate the Oracle GoldenGate DDL trigger and other Oracle GoldenGate DDL objects. Before applying a database patch, do the following.

Disable the Oracle GoldenGate DDL trigger by running the following script.

@ddl_disable

Apply the patch.

Enable the DDL trigger by running the following script.

@ddl_enable

Oracle Golden Gate supported data types

Oracle GoldenGate Supported data types
Numeric data types
● NUMBER up to the maximum size permitted by Oracle
● BINARY FLOAT
● BINARY DOUBLE
Character data types
● CHAR
● VARCHAR2
● LONG
● NCHAR
● NVARCHAR2
Multi-byte character types
● NCHAR and NVARCHAR2 multi-byte character data types
● Multi-byte data stored in CHAR and VARCHAR2 columns
Binary data types
● RAW
● LONG RAW
Date and timestamp data types
● DATE
● TIMESTAMP (see non-supported data types for exclusions)
Large object data types
● CLOB
● NCLOB
● BLOB
XML data types
● XMLType is supported.
User defined types
Oracle GoldenGate supports user defined types (UDT) when the source and target objects
have the same structure. The schema names can be different.
Other supported data types
● ROWID
● VARRAY
● INTERVAL DAY and INTERVAL YEAR if the size of the target column is equal to, or greater than,
that of the source.

Golden Gate Non-supported data types

Golden Gate Non-supported data types

● ORDDICOM

● ANYDATA

● ANYDATASET

● ANYTYPE

● BFILE

● MLSLABEL

● TIMEZONE_ABBR

● TIMEZONE_REGION

● URITYPE

● UROWID

Oracle Golden Gate Questions and Answers

Golden Gate Questions and Answers

1)

Is GoldenGate certified for Oracle E-business Suite Release 12. The metalink note 1112325.1t suggest that it can be used for EBS reporting . Is it a certified combination.

2)

There is a feature called Syncfile in Goldengate. Can this be used for E-business suite file synching (binaries file synching to Disaster Recovery site) ? The below URL gives a hint about it.

www.oracle.com/goldengate/goldengate-faq.pdf

3) So many people use Data Guard,  It seems GG can also do the same thing. It can read from the redologs and apply them. Shouldn’t we use GG instead of DataGuard. What are the pros and cons of both.

4) GG versus Oracle Advanced Replication?

5) Is the GG mainly a data replication solution and doesn’t offer any file synchronization ? What about SynFile feature.

6) Are we saying GG is mainly data replication solution and doesn’t offer any file synchronization ?

7) GG and DataGuard are licensed together .Can you shed some light on it.

8) GG can help upgrading the database from 9i to 11g . How is that possible ?

Oracle Answers.

Question 1:

Is GoldenGate certified for Oracle E-business Suite Release 12. The metalink note 1112325.1t suggest that it can be used for EBS reporting . Is it a certified combination.

Answer:

The Knowledge document Doc ID 1112325.1 describes using Oracle GoldenGate with Oracle E-Business Suite Release 12.1.1 for operational reporting, in which selected tables are replicated from the primary Oracle E-Business Suite database to a secondary (duplicate) instance. This enables read-intensive, custom reports to be run without using resources on the primary Oracle E-Business Suite database. So as of now only selected tables are replicated from the primary Oracle E-Business Suite database to a secondary (duplicate) instance using Oracle GoldenGate for operational reporting only.

Please Note Important: It is highly recommended that organizations planning to implement Oracle GoldenGate to achieve Operational Reporting using Oracle E-Business as a source, have technical specialists with prior training and experience using Oracle GoldenGate. Organizations lacking sufficient skills within the team, should contact Oracle Consulting Services for assistance before attempting this type of solution.

Supported User Data Tables and limitations:

-----------------------------------------------------

a.Approximately 21000 Oracle E-Business Suite tables are supported by Oracle GoldenGate.

b.Tables without a primary key or unique index are fully supported by Oracle GoldenGate, but could add extra volume to redo log generation as all columns must be supplementally logged.

c.Fewer than twenty Oracle E-Business Suite tables are not supported by Oracle GoldenGate; this is because they contain data types ANYDATA and UROWID.

Current restrictions mean that Oracle GoldenGate may not always capture 100 percent of changed data created by Oracle E-Business Suite. The issues range from data types not supported by Oracle GoldenGate 10.4, through to data issues such as ANYDATA or UROWID columns that may require addition of business logic to transform the data into a usable form on the target system.

Please refer to the KM Doc ID 1112325.1 for more information.

Question 2:

There is a feature called Syncfile in Goldengate. Can this be used for E-business suite file synching (binaries file synching to Disaster Recovery site) ?

Answer:

NO, Syncfile commands in OGG cannot be used with Oracle Database as it is only used with Nonstop Tandem Environments.

FYI, Syncfile utility is mainly used to duplicate entire files on a scheduled basis in NonStop systems.By default, Syncfile uses the NonStop FUP DUP utility to perform file duplication

Question 3:

3) So many people user Data Guard,  It seems GG can also do the same thing. It can read from the redologs and apply them. Should'nt we use GG instead of DataGuard. What are the pros and cons of both.

Answer:

Oracle Data Guard and Oracle Active Data Guard:

---------------------------------------------------------

Oracle Active Data Guard, which is built on the infrastructure of Oracle Data Guard, allows a physical standby database to be open read-only while changes are applied to it from the primary database. This enables read-only applications to utilize the physical standby with minimal latency between the data on the standby database and that on the primary database, even while processing very high transaction volumes at the primary database.

An Oracle Active Data Guard standby database is used for automatic repair of data corruptions detected by the primary database, transparent to the application. In the event of an unplanned outage on the primary database, high availability is maintained by quickly failing over to the standby database. An Active Data Guard standby database can also be used to off-load fast incremental backups from the primary database given that it is a block-for-block physical replica of the primary.

Oracle Active Data Guard enables read-only reporting on the physical standby with minimal latency between reporting and production data. Oracle Active Data Guard also allows backup operations to be off-loaded to the standby database using fast incremental backups. Oracle Active Data Guard provides the additional benefit of high availability and disaster protection by quickly failing over to the standby database in the event of a planned or an unplanned outage at the production site. Active Data Guard only supports Oracle Database Enterprise Edition.

Oracle Data Guard provides disaster recovery (DR) and data availability for the Oracle Database, enabling very fast failover to a standby database in the event of a failure in the primary database. Oracle Active Data Guard extends the physical standby database to be open for read-only traffic, and also for fast incremental backups. This allows

customers to better leverage their existing DR investment and increase the performance of the production database by offloading query and backup processing to (up to 30) physical standby databases.

Oracle Active Data Guard also provides transparent data protection by automatically repairing corrupted data blocks on the primary database using the valid data blocks from the physical standby database, and vice versa.

Oracle Data Guard and Oracle Active Data Guard are exclusively for Oracle to Oracle replication, where the database schemas are identical and the computing platforms have the similar architecture. Because replication is at the physical block level, and no data or schema transformations take place, this is the fastest replication possible. Oracle Data Guard with the Oracle Active Data Guard option continues to be the strategicdisaster recovery and data availability solution for Oracle databases.

Oracle GoldenGate:

--------------------------

Oracle GoldenGate delivers an enterprise-wide solution for heterogeneous real time data access and delivery needs. Oracle GoldenGate works across different databases, platforms and schemas, and supports active-active configurations. By reading database logs, Oracle GoldenGate avoids any impact to the source database and ensures reliable, transactionally consistent delivery of database transactions across wide area or local networks. With its flexible, modular architecture, Oracle GoldenGate solves a wide range of high availability challenges, including active-active deployments, multi-master deployments, data distribution for infrastructure cost reduction and high availability, and zero downtime migrations and upgrades. Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases, with proven success in a wide range of demanding industries and mission critical use cases.

Oracle GoldenGate is a log-based, real-time change data capture (CDC) software platform that moves high volumes of transactional data between databases with very low latency, and allows logical data replication. A typical environment includes a capture, pump and delivery process.You can replicate all or a portion of your data, and you can filter or transform the data within any of these processes not only for heterogeneous environments but also different database schemas.Oracle GoldenGate is also an excellent product for minimizing downtime during planned maintenance, including application and database upgrades, in addition to platform migrations.

With GoldenGate for Oracle, you can replicate DML and DDL operations.You can move data between similar or dissimilar supported Oracle versions, or you can move data between an Oracle database and a database of another type. GoldenGate supports the filtering, mapping, and transformation of data.

GoldenGate supports both Oracle Database Standard Edition and Oracle Database Enterprise Edition. For replication involving a heterogeneous mix of Oracle and non-Oracle databases, GoldenGate should be the obvious choice.

Summary:

----------------

1.If your business requirement is a simple, high-performance, drop-in solution for disaster recovery (DR), data protection and high availability (HA) for the entire Oracle database, Oracle Active Data Guard should be the recommended solution.

***Disaster Recovery (DR) / Data Protection / High Availability (HA) - Use Active Data Guard

a.It is a high-performance, simple, drop-in solution for HA and DR.

b.It maximizes DR investment by utilizing physical standbys for queries and backups.

c.It works for all apps and data types, including packaged apps that can’t be changed.

d.It is fully integrated with all other Oracle database HA capabilities – e.g. RAC, Flashback, Client Failover, Automatic Block Repair, Lost Write Protection, etc.

e.It provides basic capabilities to reduce planned downtime for technology refresh, select migrations, and upgrades of Oracle Database software.

2.If your business requirement is to set up a data distribution / data synchronization solution through this Oracle-Oracle replication configuration, or a more flexible multi-master HA solution, Oracle GoldenGate should be the recommended solution.

***flexible HA, active-active, schema & platform changes, HA/DR for non-Oracle databases - Use Oracle GoldenGate

a.It supports heterogeneous platforms & databases, transformations, subset replication, active-active deployments, etc.

b.It supports a wide variety of minimal and zero downtime planned maintenance activities.

Note: Active-active configurations usually require data conflicts to be avoided or at least managed by the application, so active-active architecture for real-time replication is more suitable for custom applications. With respect to planned migrations, GoldenGate’s certification on Oracle Siebel CRM supports an active-active configuration to provide zero downtime upgrades and migrations.

3.If your business requirement is Information Distribution & Consolidation, Application Upgrades & Changes

***Use GoldenGate – supports heterogeneous platforms & databases, transformations, subset replication, active-active deployments, hub & spoke, multi-master, bi-directional configurations, etc.

4.Dual Use of both Oracle GoldenGate and Oracle Active Data Guard in your production environment:

Oracle GoldenGate and Oracle Active Data Guard when used together offer a unique data protection and information distribution solution not offered by any other product. Given the fact that they are licensed together, Oracle recommends that both solutions are deployed together whenever appropriate.

For example, a centralized global manufacturing database may be protected using an Active Data Guard physical standby, set up with Data Guard Fast-Start Fail-over with synchronous redo transport, ensuring zero data loss and integrated fail-over of applications in the event of an outage at the primary data center.

At the same time, using Oracle GoldenGate, it is possible to set up bi-directional replication from this central database to smaller regional databases supporting local manufacturing operations. These may be non-Oracle databases, and they could also be configured in a hardware and OS platform that is different from that of the central database. Enabling such a fully active, globally distributed and highly available configuration is one of the unique value propositions of implementing Oracle GoldenGate together with Oracle Active Data Guard.Oracle GoldenGate can also help upgrade customers on older database versions such as Oracle9i to Oracle Database 11g without impacting their operations, and after the upgrade those customers can start benefiting from Active Data Guard’s advanced HA capabilities.

You can more information on this at below link

http://www.oracle.com/technology/products/goldengate/htdocs/statement-of-direction-gg.pdf

Question 5:

4) GG versus Oracle Advanced Replication.

Advanced replication supports various configurations of updateble-snapshot, multi-master and update anywhere replication whereas Oracle GoldenGate delivers an enterprise-wide solution for heterogeneous real time data access and delivery needs.

Oracle GoldenGate works across different databases, platforms and schemas, and supports active-active configurations. By reading database logs, Oracle GoldenGate avoids any impact to the source database and ensures reliable, transactionally consistent delivery of database transactions across wide area or local networks. With its flexible, modular architecture, Oracle GoldenGate solves a wide range of high availability challenges, including active-active deployments, multi-master deployments, data distribution for infrastructure cost reduction and high availability, and zero downtime migrations and upgrades. Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases.

So ti is advisable to use Oracle GoldenGate as it supports replication to heterogeneous environments and avoids any impact to the source database.

For more information please refer to the technical documentation that can be found at:

a.GoldenGate documentation library - http://download.oracle.com/docs/cd/E15881_01/index.htm

b.You can download all the latest OGG documentation and Software from http://edelivery.oracle.com

Question 6:

1) Are we saying GG is mainly data replication solution and doesn’t offer any file synchronization ? I can see GG has many products in it.

Answer:

----------

OGG support file synchronization only in Nonstop systems but not in Oracle database environments.As it internally uses Nonstop tools like FUP DUP and TACL scripts to accomplish this function.

Currently file synchronization is not supported in open systems and Oracle database environments.

Question 7:

GG and DataGuard are licensed together .Can you shed some light on it.

Answer:

----------

The license for Oracle GoldenGate includes the ability to capture database transactions from Oracle Database and deliver database transactions to Oracle Database. It also includes a full use license for Oracle Active Data Guard, and a full use license for XStream. Note, the capture and deliver features of Oracle GoldenGate work with any edition of the Oracle Database, while Active Data Guard and XStream require Oracle Database Enterprise Edition.

More information can be found at below link

http://download.oracle.com/docs/cd/E15881_01/doc.104/e15889.pdf

Question 8:

GG can help upgrading the database from 9i to 11g . How is that possible ? Can you elaborate bit more on that.

Answer:

----------

Please refer to the attached document for more information on the same.

Zero-Downtime Database Upgrades Using Oracle GoldenGate - Oracle_zerodowntime_database_upgrade.pdf -  

4) All the features mentioned above for GG have resemblance with Oracle Data Integrator as well . What is the difference ? Where we should pitch ODI and where to pitch GG ? Aren’t they very close to each other ?

Answer:

----------

Oracle Data Integrator Enterprise Edition:

------------------------------------------

Oracle Data Integrator Enterprise Edition delivers high-performance movement and transformation of heterogeneous data in batches and mini-batches for use in data warehousing, business intelligence, application integration, and service oriented architecture use cases. Oracle Data Integrator Enterprise Edition utilizes heterogeneous databases to perform high speed complex data transformations and leverage existing resources. With its flexible, modular architecture and declarative design methodology, Oracle Data Integrator Enterprise Edition helps companies reduce the total cost of ownership for data integration. In addition, Oracle Data Integrator Enterprise Edition integrates with Oracle’s and third party data quality products.

Oracle Data Integrator Enterprise Edition remains the strategic data integration product from Oracle for ETL, ELT, batch integration, mini-batch integration, and bulk transformation. The changed data capture functionality included with Oracle Data Integrator Enterprise Edition is suitable for periodic, ongoing loads for a data warehouse.

Oracle GoldenGate:

------------------------------------------

As Oracle’s solution for enterprise-wide heterogeneous real time data access and delivery needs, Oracle GoldenGate complements Oracle Data Integrator Enterprise Edition to provide the real time data integration required for real time business intelligence. By reading transaction logs, Oracle GoldenGate imposes minimal impact on transactional systems and maintains transactional integrity across databases. Oracle

GoldenGate moves data with very low latencies in the most demanding operational and business intelligence environments. Oracle GoldenGate is Oracle’s strategic solution for real time data integration. It enables non-invasive operational reporting and other types of query offloading by maintaining a real-time replica that can be on a different database platform and lower cost hardware. In combination with Oracle Data Integrator Enterprise Edition for transformation, Oracle GoldenGate makes real time business intelligence possible, allowing companies to combine insight about the current state with historical context.

Recommended Data Integration Use Cases:

-----------------------------------------------------------

1. Typical Data Warehouse Loading & SOA Use Cases: Oracle Data Integrator Enterprise Edition For typical batch-oriented data warehousing, Oracle Data Integrator Enterprise Edition (ODI-EE) is the recommended solution. ODI-EE extracts, loads, and transforms data for initial loads and incremental batch updates with set-based execution of complex transformations. It can also work with comprehensive data quality products such as

Oracle Data Quality. ODI-EE is also the solution for bulk transformations in a SOA.

2. Data Synchronization, Query Offloading: Oracle GoldenGate Oracle GoldenGate is recommended for data synchronization use cases in which two systems are kept in sync bi-directionally and for use cases of moving database transactions from more expensive systems to less expensive, then running BI tools and other queries against the lower cost replica to reduce the load and cost on mission critical transactional systems.

3. Combining Oracle GoldenGate and Oracle Data Integrator Enterprise Edition It is a powerful combination to use Oracle GoldenGate and Oracle Data Integrator together for real time business intelligence. Oracle GoldenGate captures database transactions from OLTP sources and propagates them in real time to a permanent staging area in an enterprise data warehouse, Then, ODI picks up the changes from the permanent staging area and performs transformation within the database to load into the optimized data warehouse schema. By combining information about the current business

state with historical analysis and context, companies can drive informed business decisions throughout the day.

There is no other solution available in the market that offers real time data integration and transformation within heterogeneous databases to enable real time business intelligence without additional server investment.

Product Integration Plans:Oracle Data Integrator Enterprise Edition and Oracle GoldenGate will continue as separate products that offer additional advantages when used together. Product integration plans include, for example, allowing Oracle GoldenGate to move data from source to target in real time and directly populate the change data capture tables of Oracle Data Integrator so it can perform streamlined complex transformations into the

warehouse schema. This will further reduce the end-to-end latency for real time data warehousing.

With its next generation data integration platform, Oracle envisions even greater synergies between bulk data movement and transformation and real time data movement. Existing customers will be carried forward to the next generation data integration platform from any of Oracle’s existing data integration products, including Oracle GoldenGate.

You can have more information on this at below link

http://www.oracle.com/technology/products/goldengate/htdocs/statement-of-direction-gg.pdf

An Overview of Golden Gate Replication

Oracle Golden Gate

View more presentations from 92qasim.

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.