Webinar: Whats New in Oracle Golden Gate 12c?

The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence.

Date and time: Thursday, May 9th, 2019 8:00 am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)

Join the Webinar to learn new features in Golden Gate.

· Expanded heterogeneous Support
· Multitenant Container Database (CDB) Support
· Oracle Universal Installer (OUI) Support
· Support for Public and Private Clouds
· Integrated Replicat
· Security
· Coordinated Replicat
· New 32K VARCHAR2 Support
· High Availability (HA) enhancements
· Support for Other Oracle products
· Improvements to feature Functionality

To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com and reserve your spot. Registration is limited to first 50 members only.

You will receive an email confirmation with meeting link. For presentation link Click here .

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Webinar: Oracle Golden Gate 12c New Features

The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence.

Date and time: Friday, January 8th, 2016 8:00 am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)

Join the Webinar to learn Golden Gate 12c New Features

· Expanded heterogeneous Support
· Multitenant Container Database (CDB) Support
· Oracle Universal Installer (OUI) Support
· Support for Public and Private Clouds
· Integrated Replicat
· Security
· Coordinated Replicat
· New 32K VARCHAR2 Support
· High Availability (HA) enhancements
· Support for Other Oracle products
· Improvements to feature Functionality

To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com and reserve your spot. Registration is limited to first 50 members only.

You will receive an email confirmation with meeting link. For presentation link Click here .

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Oracle GoldenGate 12c New Features - Part2

Hi Everyone,

My articles published in Oracle Experts website media "Allthingsoracle.com" by RedGate

Please see the article using below link.

Oracle Golden Gate 12c New Features – Part 2

In this article I will cover:

• Security
• Coordinated Replicat
• New 32K VARCHAR2 Support
• High Availability (HA) enhancements
• Support for Other Oracle products
• Improvements to feature Functionality

This article will help all Oracle Community to understand Oracle GoldenGate 12c new features and how it helps in continuous availability, disaster tolerance and real-time data integration solutions that enable the management and movement of transactional data across the enterprise.

I hope you will like the article and it will be helpful to you.

Please leave your valuable comments.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Oracle GoldenGate 12c New Features - Part1

Hi Everyone,

My articles published in Oracle Experts website media "Allthingsoracle.com" by RedGate

Please see the article using below link.

Oracle Golden Gate 12c New Features – Part 1

In this article I will cover:

• Expanded heterogeneous Support
• Multitenant Container Database (CDB) Support
• Oracle Universal Installer (OUI) Support
• Support for Public and Private Clouds
• Integrated Replicat

This article will help all Oracle Community to understand Oracle GoldenGate 12c new features and how it helps in continuous availability, disaster tolerance and real-time data integration solutions that enable the management and movement of transactional data across the enterprise.

I hope you will like the article and it will be helpful to you.

Please leave your valuable comments.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Oracle GoldenGate: A Real-time Data integration & Heterogeneous replication tool

Now a day, the majority of businesses are facing below challenges

Availability - Data must be accessible at or near 24/7/365 without performance degradation or interruption

Rduced latency -  Data must remain up-to-date without latency. 

Heterogeneity and IT flexibility - Integration and replication across different IT systems.

Transaction integrity - Data completeness

Oracle GoldenGate provides the solution for all these challenges. It is a high performance software application for real-time transactional change data capture, distribution, transformation and delivery across heterogeneous.

Oracle GoldenGate 11g Release 2 offers below new features

• Intelligent Conflict Detection and Resolution for Active-Active and Multi-Master implementations 
• Integrated Capture to support all Oracle Database and Exadata compression types, as well as XML Object  Relational, XML Binary data types 
• Expanded support for global deployments, including support for multi-byte and character set conversions 
• Improved security with added support for Federal Information Protection Standard (FIPS) 
• Enhanced manageability and monitoring utilizing Oracle Enterprise Manager 
• Increased extensibility by taking defined actions based on an event record in the transaction log or in the Trail file. 
• Expanded heterogeneity via: 
• Log-based capture from IBM DB2 on i-Series (AS/400) 
• Delivery to Postgres 
• New data types supported for Microsoft SQL Server, Sybase, and MySQL 
• Teradata multi-byte DDL support 
• IBM z/OS improved initial load performance
•  Certification for near zero downtime upgrade for Oracle Communications Billing and Revenue Management applications 

Oracle GoldenGate 11gR2 supports following scenarios

1. Zero-Downtime

2. Data Distribution

3. Disaster recovery and data protection

4. Query offloading.

Oracle GoldenGate also provides graphical monitoring tool for GoldenGate deployments and it consists of the following components:

Oracle GoldenGate Monitor Agent -  An Oracle GoldenGate Monitor Agent is installed on Oracle GoldenGate instance. It collects information of the instance and sends it to the Oracle GoldenGate Monitor Server.

Oracle GoldenGate Monitor Server - The Oracle GoldenGate Monitor Server coordinates the monitoring of multiple Oracle GoldenGate instances..

Oracle GoldenGate Monitor Repository - The Oracle GoldenGate Monitor Server uses a database as a central repository to store information about users and groups, process status, monitoring points, events, and other information.

Please visit the link: Oracle Management pack Key Features and Benefits for Oracle Golden Gate

Refer below links for Oracle GoldenGate Software, Installation Documentation, White papers & Best Practices

•  Download Oracle GoldenGate Software
•  Oracle Golden Gate Documentation
•  Oracle GoldenGate White papers, Podcasts and Webcasts

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Oracle Heterogeneous Services

Oracle offers two solutions to access any number of non-Oracle systems from an Oracle environment in a heterogeneously distributed environment. They are

1. Oracle Generic Connectivity
2. Oracle Transparent Gateways.

Heterogeneous Connectivity Process - The Oracle Database server accesses the non-Oracle Database using Oracle Heterogeneous Services in conjunction with an agent. Heterogeneous Services (HS) is an integrated component within the Oracle Database server and the enabling technology for the current suite of Oracle Transparent Gateway products.

Oracle Generic Connectivity is a generic solution for any ODBC or OLEDB compliant non-Oracle system. It enables connectivity using industry standards such as ODBC and OLEDB driver. Using Generic connectivity it possible to access low-end data stores such as Access, dBase, FoxPro and non-relational targets like Excel. Generic connectivity is provided free of charge with the database server, but it is and limited in functionality and slower compared to Oracle's Gateways.

If Oracle database running on windows, setup the HS ODBC/HS OLEDB agent on the same server to access non-oracle systems. If Oracle database running on UNIX, you must install Oracle server on the windows where non-oracle database is running and setup the HS ODBC/HS OLEDB agent on the same server. If you don’t want to install Oracle server on non-oracle system then you can Install Oracle server on middle tier windows system or system that supports the ODBC or OLE DB protocols and setup the HS agent.

See the below links to setup Oracle Generic connectivity.
Oracle Generic connectivity setup in Oracle 9i
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/gencon.htm#1656
Oracle Generic connectivity setup in Oracle 10g
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14232/gencon.htm#g1012648

Oracle Transparent Gateways is another solution to access non-oracle database and the HS agent is a system-specific application. For example, if you include a MSSQL Sybase database in an Oracle Database distributed system then you need to obtain a Sybase-specific transparent gateway so that the Oracle Database in the system can communicate with it.

Oracle transparent Gateways are licensed separately and agents can be installed on any machine. They can be on the same machine as the Oracle database system or on the same machine as the non-Oracle system or on a third machine as a stand alone.

Following are dedicated Gateways for non-Oracle data sources:-
- Microsoft SQL*Server - Database Gateway for SQL*Server (DG4Msql)
- Sybase - Database Gateway for Sybase (DG4Sybase)
- Informix - Database Gateway for Informix (DG4Ifmx)
- IBM DB2 - Database Gateway for DRDA (DG4DRDA)
- Teradata - Database Gateway for Teradata (DG4Teradata)
- Websphere MQ - Database Gateway for Websphere MQ (DG4MQ)
- Remote online transaction processors (OLTPs) - Database Gateway for APPC (DG4APPC)
- IMS - Database Gateway for IMS (DG4IMS)
- VSAM - Database Gateway for VSAM (Dg4VSAM)
- Adabas - Database Gateway for Adabas (DG4Adabas)

See the below links to setup Transparent Gateways.
Oracle Transparent Gateways setup in Oracle 9i
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/admin.htm#170863
Oracle Transparent Gateways setup in Oracle 10g
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14232/admin.htm

Non-Oracle data sources for which a dedicated transparent gateway is not available can be accessed by using Database Gateway for ODBC (DG4ODBC), which uses third party ODBC drivers to make the connection to the non-Oracle data source

Database Gateway for ODBC (DG4ODBC) is the 11g version of the generic connectivity and certified for older versions (9i, 10g). However, this does require that the Oracle 10g database accessing non-Oracle database through it must be patched to at least 10.2.0.4.

See the below link for Heterogeneous connectivity setup for Oracle Database Gateways
http://www.oracle.com/pls/db111/portal.portal_db?selected=15

There are differences in licensing and functionality of the Database Gateway for ODBC and the other gateways. For more information see the Metalink notes.
Note.232482.1 Gateway and Generic Connectivity Licensing Considerations
Note.252364.1 Functional Differences between Generic Connectivity and Database Gateways

The earlier gateway versions are de-supported. For more information see the Metalink notes.
Note.549796.1 Desupport of Oracle Transparent Gateways

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com