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

WebLogic Server Patch WDJ7 Installation (Weblogic Server Upgrade)

Weblogic Server Upgrade

Please follow the steps below, this patch will upgrade the already Weblogic installation (10.3.2) to WebLogic Patch WDJ7.

cd /u01/app/oraoem/Middleware
cd utils/bsu
./bsu.sh

WebSphere Application Server

Websphere AS

Siebel SARM Questions and Answers

Qustion: What is SARM?

Answer: Siebel Application Response Measurement (SARM) is a performance-tracing framework that was originally introduced in Siebel 7.5

Question: How to enable SARM?

Answer: SARM should be enabled from Grid Control UI and also from the srvrmgr utility. In order to enable from Grid Control UI please click on

Siebel Enterprise à Diagnostics Configuration à Enable SARM

and to enable them from srvrmgr utility please execute following commands.

 These sequence of commands must be executed for each components:

change param SARMLevel=2 for comp [component_name]
change param SARMBufferSize=5000000 for comp [component_name]
change param SARMFileSize=15000000 for comp [component_name]
change param SARMPeriod=3 for comp [component_name]

Now, issue the following to ensure that the values are set:
list param SARMLevel

Question: Where to find the srvrmgr utility and is it available for Windows and Unix machines?

Answer: The srvrmgr utility is available on both the UNIX and Windows machine.
It is normally found in the /siebsrvr/bin directory.

Question: How to find the values of SARM parameters.

Answer: Please execute below commands from srvrmgr utility.

list param SARMLevel
list param SARMBufferSize
list param SARMFileSize
list param SARMPeriod

Question: For how long the information is kept in SARM files and what if we want to have report for previous months?

Answer: It depends on SARMLevel, SARMBufferSize, SARMFileSize and SARMPeriod parameters.  If the size of the sarm file execeeds SARMFileSize, then the log files gets rotated Generating a report from previous months is not supported out of the box in the current release.

Question: Can we archive the SARM files to use them later on?

Answer: Yes, the SARM log file can be archived so that they can be used later.
OEM does not provide this feature. Archiving the SARM log file must be done on the Siebel side.

Installation of 10.2.0.5 GC Fails During Relink of Target 'agent nmo nmb nmhs emsubagent'

Installation of 10.2.0.5 GC Fails During Relink of Target 'agent nmo nmb nmhs emsubagent'

Note: It is a known bug and further information could be retreived from 837072.1

1) Modify the following files:

cd $ORACLE_HOME/sysman/lib

vi env_emagent.mk

vi ins_emagent.mk

2) Make the following changes to the ins_emagent.mk file:

i. On line 29, change the following line from:

# libnmevc \

To this:

# libnmevc

Removing the trailing slash will remove the "Syntax Error" from the make file.

3) Make the following changes to the env_emagent.mk file:

i. At or around line 2427, you should see the following line:

NEW_LD_SHLIBS = $(EMAGENT_SHLIBS)

This needs to be changed to include the EMAGENT_SHLIBS redefined after it:

NEW_LD_SHLIBS = $(EMAGENT_SHLIBS)

EMAGENT_SHLIBS= $(LIBURLDATAFETCHLET_SHARED) \

$(LIBDMSFETCHLET_SHARED) \

$(LIBOSFETCHLET_SHARED) \

$(LIBTNMECR_SHARED) \

$(LIBSPFETCHLET_SHARED) \

$(LIBOCI_SHARED) \

$(LIBWBEMFETCHLET_SHARED) \

$(LIB_UT_FETCHLET_SHARED) \

$(LIBPORTFETCHLET_SHARED) \

$(LIBTESTFETCHLET_SHARED) \

$(LIBVERFETCHLET_SHARED) \

$(LIBPROPFROMASSOCFETCHLET_SHARED) \

$(LIBSQLFETCHLET_SHARED) \

$(LIBSQLTFETCHLET_SHARED) \

$(LIBTNMECLU_SHARED) \

$(LIBTNMEVR_SHARED) \

$(LIBNMEVQ_SHARED) \

$(LIBNMEVC_SHARED) \

$(LIBNMEVSP_SHARED) \

$(LIBNMS_SHARED) \

$(LIBNMS0_SHARED) \

$(LIBNMSP_SHARED) \

$(LIB_NMADBG_SHARED) \

$(LIB_NMADM_SHARED) \

$(LIB_NMALK_SHARED) \

$(LIB_NMARL_SHARED) \

$(LIB_NMASF_SHARED) \

$(LIB_NMASTK_SHARED) \

$(LIBNMEPS_SHARED) \

$(LIB_OJMX_FETCHLET_SHARED) \

$(LIBNMECLURAC_SHARED) \

$(LIBHCFETCHLET_SHARED) \

$(LIBSGAFETCHLET_SHARED)

Grid Control Migration to New Server with Different Hostname or Domainname

Grid Control OMS and Repository Database can be migrated to new server with different hostname or domainname by using any of the two methods below.The steps below are applicable only if both source and destination servers are on the same OS platform.

Method 1

---------

1.Stop the OMS and Agent running on OMS server( the agent installed with the OMS) .

2.Clean up the Central Management Agent ( the agent installed with the OMS):

Connect to the repository DB as SYSMAN and execute the following PL/SQL API:

SQL> exec mgmt_admin.cleanup_agent('');

Note: - This command may take some time to complete, so please don't interrupt.

- To get the old agent name use the following query:

select target_name from mgmt_targets where target_type='oracle_emd';

3.Migrate the Repository Database to target server .You can refer to 'Doc ID 602955.1' for the same.

4.Install Additional OMS on new server following the document below

'Installing an Additional Oracle Management Service Release 5 (10.2.0.5)'

http://download.oracle.com/docs/cd/B16240_01/doc/install.102/e10953/installing_em.htm#CHDJFFGJ

5.Point the target Agents to the new OMS following the steps in the Documentation below

'Configuring the Management Agent to Use a New Management Service'

http://download.oracle.com/docs/cd/B16240_01/doc/em.102/e10954/postinstall_config.htm#i1024275

Method 2

---------

If you prefer to reduce downtime and dont want to stop the source OMS before the installation of Additional OMS then follow the steps as below

1.Install Additional OMS on new server pointing to existing repository database on source server following the document below

'Installing an Additional Oracle Management Service Release 5 (10.2.0.5)'

http://download.oracle.com/docs/cd/B16240_01/doc/install.102/e10953/installing_em.htm#CHDJFFGJ

2.Then stop both the OMS and migrate Database to new server

3.Configure the OMS on new server to point to Repository on new server.You can refer to documentattion below for the same

http://download.oracle.com/docs/cd/B16240_01/doc/install.102/e10953/postinstall_config.htm#i1020180

4.Clean up the Central Management Agent on the source server ( the agent installed with the OMS):

Connect to the repository DB as SYSMAN and execute the following PL/SQL API:

SQL> exec mgmt_admin.cleanup_agent('');

Note: - This command may take some time to complete, so please don't interrupt.

- To get the old agent name use the following query:

select target_name from mgmt_targets where target_type='oracle_emd';

5.Start the OMS on new server

6.Point the target Agents to the new OMS following the steps in the Documentation below

'Configuring the Management Agent to Use a New Management Service'

http://download.oracle.com/docs/cd/B16240_01/doc/em.102/e10954/postinstall_config.htm#i1024275

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

Data Guard for Ebusiness Suite.‏

Data Guard for Ebusiness Suite.‏
There is a metalink note which covers the data guard for e-business suite. The main message is that Data Guard is not very different when it sits with the ebusiness sutie. Data guard remains generic whatever configuration you may choose.
Below are some metalink notes for dataguard with EBS.
For 11i (341437.1)
For R12 (452056.1)
403347.1 is also helpful

The other major bit need to remember is that data guard is only for data changes. It can’t replicate or propagate the applications changes. E.g. you apply a ebusiness suite patch to Prod , the database changes would be synched to DR but not the application changes.

Same way if you apply a RDBMS patch or OPATCH which changes the database binaries , this will not be propagated to DR.

So for the application update you need to look for another solution. We use RSYCN at most of our places which is an operating system feature. It keeps monitoring the files and as for a file verision is updated , it will push it through to DR.

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