Thursday Jan 29, 2015

Oracle GoldenGate 12c for Oracle Database - Integrated Capture sharing capture session

Oracle GoldenGate for Oracle Database has introduced several features in Release 12.1.2.1.0. In this blog post I would like to explain one of the interesting features:  “Integrated Capture (a.k.a. Integrated Extract) sharing capture session”. This feature allows making the creation of additional Integrated Extracts faster by leveraging existing LogMiner dictionaries. As Integrated Extract requires registering the Extract let’s first see what is ‘Registering the Extract’?

REGISTER EXTRACT EAMER DATABASE

The above command registers the Extract process with the database for what is called “Integrated Capture Mode”. In this mode the Extract interacts directly with the database LogMining server to receive data changes in the form of logical change records (LCRs).

When you create Integrated Extract prior to release Oracle GoldenGate 12.1.2.1.0, you might have seen the delay in registering the Extract with database. It is mainly because the creation of Integrated Extract involves dumping the dictionary and then processing that dictionary to populate LogMiner tables for each session, which causes overhead to online systems and hence it requires extra time to startup. The same process is being followed when you create additional Integrated Extract.

What if you could use the existing LogMiner dictionaries to create the additional Integrated Extract? This is what it has been done in this release. Additional Integrated Extract creation can be made faster significantly by leveraging existing LogMiner dictionaries which have been mined already. Hence no more separate copy of the LogMiner dictionaries to be dumped with each Integrated Extract. As a result, it will make the creation of additional Integrated Extracts much faster and helps avoid significant database overhead caused by dumping and processing the dictionary.

In order to use the feature, you should have Oracle DB version 12.1.0.2 or higher, and Oracle GoldenGate for Oracle version 12.1.2.1.0 or higher. The feature is currently supported for non-CDB databases only.

Command Syntax:

REGISTER EXTRACT group_mame DATABASE

..

{SHARE [AUTOMATIC | extract | NONE]}

It has primarily three options to select with; NONE is default if you don’t specify anything.

AUTOMATIC option will clone/share the LogMiner dictionary from the existing closest capture. If no suitable clone candidate is found, then a new LogMiner dictionary is created.

Extract option will clone/share from the capture session associated for the specified Extract. If this is not possible, then an error occurs the register does not complete.

NONE option does not clone or create a new LogMiner dictionary; this is the default.

While you use the feature, the SHARE options should be followed by SCN and specified SCN must be greater than or equal to at least one of the first SCN of existing captures and specified SCN should be less than current SCN.

Let’s see few behaviors prior to 12.1.2.1.0 release and with SHARE options. 'Current SCN’ indicates the current SCN value when register Extract command was executed in following example scenario.

Capture Name

LogMiner ID

First SCN

Start SCN

LogMiner Dictionary ID (LM-DID)

EXT1

1

60000

60000

1

EXT2

2

65000

65000

2

EXT3

3

60000

60000

3

EXT4

4

65000

66000

2

EXT5

5

60000

68000

1

EXT6

6

70000

70000

4

EXT7

7

60000

61000

1

EXT8

8

65000

68000

2

Behavior Prior to 12.1.2.1.0 – No Sharing

Register extract EXT1 with database (current SCN: 60000)

Register extract EXT2 with database (current SCN: 65000)

Register extract EXT3 with database SCN 60000 (current SCN: 65555)

Register extract EXT4 with database SCN 61000   à Error!!

Registration of Integrated Extract EXT1, EXT2 and EXT3 happened successfully where as EXT4 fails because the LogMiner server does not exist at SCN 61000.

Also take a note that all Integrated Extract (EXT1 – EXT3) created dictionaries separately (LogMiner Dictionary IDs are different, now onwards I’ll call them LM-DID).

New behavior with different SHARE options

  • Register extract EXT4 with database SHARE AUTOMATIC (current SCN: 66000)

EXT4 automatically chose the capture session EXT2 as it has Start SCN 65000 which is nearer to current SCN 66000. Hence EXT4 & EXT3 capture sessions would share the same LM-DID 2.

  • Register extract EXT5 with database SHARE EXT1 (current SCN: 68000)

EXT5 is sharing the capture session EXT1. Since EXT1 is up and running, it doesn’t give any error. LM-DID 1 would be shared across EXT 5 and EXT1 capture sessions.

  • Register extract EXT6 with database SHARE NONE (current SCN: 70000)

EXT6 is being registered with SHARE NONE option; hence the new LogMiner dictionary will be created or dumped. Please see LM-DID column for EXT6 in above table. It contains LM-DID value 4.

  • Register extract EXT7 with database SCN 61000 SHARE NONE (current SCN: 70000)

It would generate an error as similar to EXT4 @SCN61000. The LogMiner Server doesn’t exist at SCN 61000 and since the SHARE option is NONE, it won’t share the existing LogMiner dictionaries as well. This is same behavior as prior to 12.1.2.1.0 release.

  • Register extract EXT7 with database SCN 61000 SHARE AUTOMATIC (current SCN: 72000)

EXT7 is sharing the capture session EXT1 as it is the closest for SCN61000. You must have noticed that the EXT7 @SCN61000 scenario has passed with SHARE AUTOMATIC option, which was not the case earlier (EXT4 @61000).

  • Register extract EXT8 with database SCN 68000 SHARE EXT2 (current SCN: 76000)

EXT8 extract is sharing EXT2 capture session. Hence sharing of LogMiner dictionaries happens between EXT8 & EXT2

This feature is not only providing you faster start up for additional Integrated Extract, but also resolves few scenarios which wasn’t possible earlier. If you are using this feature and had questions or comments, please let me know by leaving your comments below. I’ll reply to you as soon as possible.

Tuesday Jul 15, 2014

Oracle GoldenGate 12c Capture for SQL Server

In Oracle GoldenGate 12c we have expanded the heterogeneity of the product by adding support for the latest versions of the major databases. 

In Oracle GoldenGate 12.1.2.0.1 for SQL Server, which is available for download on My Oracle Support, we offer support for capturing from and delivering to SQL Server 2012. Oracle GoldenGate 12c also supports SQL Server 2008 and SQL Server 2008 R2 Capture and Delivery.

Two other highly anticipated new features for Oracle GoldenGate 12c for SQL Server, are the ability for Capture to read from SQL Server compressed transaction log backups and the ability to restrict the need for Capture to read from transaction log backups, required when customers use 3rd party transaction log backup utilities.

Some of the key capabilities of Oracle GoldenGate for SQL Server are as follows:

  • Oracle GoldenGate now supports Capture from SQL Server 2012 beginning with GoldenGate 12.1.2.0.1.
  • Oracle GoldenGate for SQL Server can be configured to Capture from tables without Primary Keys.
  • Oracle GoldenGate 12c for SQL Server supports SQL Server native backup compression and includes the optional configuration to never have to read from transaction log backups, which enables any log backup utility to be used.
  • Capture process can work in conjunction with SQL Server Transactional Replication, and Change Data Capture.
  • Oracle GoldenGate for SQL Server can provide real-time data to heterogeneous target databases, and receive real-time data from heterogeneous databases.

A complete list of supported features and details on how to implement those features are available in the Oracle GoldenGate 12c Documentation Library, available at the following address: http://docs.oracle.com/goldengate/1212/gg-winux/index.html

I also recommend reading our white paper Using Oracle GoldenGate 12c with SQL Server”  that provides more details on how GoldenGate supports SQL Server databases.

Tuesday Jul 08, 2014

Oracle GoldenGate Veridata Repair is here!

By Joe deBuzna, Director, Oracle Data Integration Product Management

Fix your out of sync data with a single click using the new Oracle GoldenGate Veridata 12.3 heterogeneous data repair feature!

I am so happy to finally be typing that sentence because I get asked about the Veridata Repair feature all the time. So YES, it’s really here! Call me biased, but this is one of the most highly sought after, killer features in the Oracle Data Integration product line, if not all of Oracle Fusion Middleware. And while it’s part of the Oracle GoldenGate product suite, it can compare and fix data between any two databases regardless of how you’re moving the data around: Oracle GoldenGate, Oracle Data Integrator, Oracle Streams, Logical Data Guard, Oracle Advanced Replication, SQL scripts, custom batch jobs, SQL*Loader – it does not matter! As long as Veridata has the right database connection permissions and supports the platform, you’re good to go.

And why does data go out of sync? Let me count the main ones, so we can keep this post short and sweet. The big ones we see include bad source data (e.g. out of bounds characters from wrong NLS settings and bad dates) got inserted or updated, no logging source operations caused data gaps in logical replication products, and bulk data loads/copies into target systems were timed incorrectly (improperly “instantiated” for replication). And here’s the one we don’t like to talk about: we work in extremely complicated IT environments and sometimes people just make mistakes. Sometimes we inherit those mistakes. And it’s ok to have mistakes. But far better if you can quickly identify them and it is absolutely crucial to fix them as soon as possible to avoid domino effects of inconsistent data.

So don’t just hope your data is in sync, prove it and have confidence knowing it. Have confidence when you’re about to pull the switch on your cloud migration or failover; have confidence looking your CEO in the eye telling him that his “single source of truth” still is; have confidence that complex, multi-master conflict detection and resolution setup you designed, or inherited, is actually keeping everything in sync.

You can learn more about the repair feature via a few new resources we have for you below. Take a look and see how you can pick and chose only which tables and specific rows you want to repair; what we did to make this feature fast and secure; how we can suppress target triggers; and more:

You can also watch a half hour video of me talking about and giving a demo of both Oracle GoldenGate Veridata and Monitor 12.1.3 here:

Oracle University Learning Stream video for Oracle GoldenGate Monitor and Oracle GoldenGate Veridata.

For Oracle GoldenGate Veridata 12.1.3 we now include in a single download Oracle GoldenGate Veridata Server, Veridata Java agents, Oracle GoldenGate Monitor Server, and Oracle GoldenGate Monitor agents. This single download can be found on eDelivery.oracle.com and on our Oracle Technology Network page.

And since we’re now based on Oracle Weblogic Server 12.1.3, you’ll need to also download the Oracle Application Development Runtime Infrastructure.

To see which platforms are supported, you can click on the Certifications tab in My Oracle Support, or download the spreadsheet “System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.1.3)”.

Finally, please feel free to leave comments and feedback below. For those willing to share, I’m always looking for interesting stories on how you’ve seen data going out of sync and how you ended up fixing it.


Wednesday May 21, 2014

Zero Downtime Consolidation to Oracle Database 12c: Webcast Recap

As companies move to private cloud implementations to increase agility and reduce costs, and start their plans with consolidating their databases, a major question arises: how do we move our systems without causing major disruption to the business. At the end, the most important systems that need to move to this new architecture are the ones that cannot tolerate extensive downtime for any reason. In last week’s webcast “Zero Downtime Consolidation to Oracle Database 12c with Oracle GoldenGate 12c” we tackled this specific dilemma that IT organizations face. The webcast is now available on demand via the link above in case you missed it last week.

In the webcast, we started discussing the benefits companies achieve when they consolidate to a private database cloud, critical database capabilities to deliver database as a service, and a quick overview Oracle Database 12c features that enable private database clouds deployments. Nick Wagner, director of product management for Oracle Database High Availability, talked about the new Global Data Services feature in Oracle Database Maximum Availability Architecture (MAA) as well. Global Data Services helps organizations to handle challenges involved with managing multiple database replicas across different sites. The product manages database replicas of Active Data Guard and Oracle GoldenGate products, and offers workload balancing to maximize performance as well as intelligent handling of outages using all available replicas. Nick also discussed the database features available for upgrading, migrating, and consolidating into Oracle Database 12c and when it makes sense to use Oracle GoldenGate for these efforts.

After Nick, Chai Pydimukkala from senior director of product management for GoldenGate discussed some of the key new features of Oracle GoldenGate 12c for Oracle Database and its expanding heterogeneity that supports consolidation from all major databases. Chai continued his presentation with GoldenGate’s solution architecture for zero downtime consolidation and explained how it minimizes risk with failback option as well as via the phased migration option by running old and new environments concurrently.

Chai also gave an example on how Oracle Active Data Guard customers can seamlessly use GoldenGate for a zero downtime migration without affecting their standby system for high ongoing high availability and disaster recoery. After customer examples we had a long Q&A section. For the full presentation and Q&A with the experts you can watch the on-demand version of the webcast via the following link.

Zero Downtime Consolidation to Oracle Database 12c with Oracle GoldenGate 12c

In the rest of this blog post, I provided  answers to some of the questions we could not take in the live event. 

1) Additional difference in features between GoldenGate 11g and 12c?

Please take a look at our previous blog posts below where we discussed many of the new features of GoldenGate 12c.

· Advanced Replication for The Masses – Oracle GoldenGate 12c for the Oracle Database.

· GoldenGate 12c - What is Coordinated Delivery?

· GoldenGate 12c - Coordinated Delivery Example

· Oracle GoldenGate 12c - Announcing Support for Microsoft and IBM

You can also listen to our podcast: Unveiling Oracle GoldenGate 12c

More comprehensive information can be found in the webcast replay  Introducing Oracle GoldenGate 12c: Extreme Performance Simplified or GoldenGate 12c resource kit.

2) Does GoldenGate have a term license that customer can purchase for migration purposes?

We do offer 1 year license that customer can be used for this purposes.

3) Is there a Oracle Tutorial on configuring and testing Zero downtime upgrade using GoldenGate?

Here is a high level outline/tutorial for the migration. It will require some knowledge of how to setup GoldenGate and configuration.

Oracle GoldenGate Best Practice: Oracle Migrations and Upgrades 9i and up

A more broad discussion of this topic can be found in the following white paper. Zero Downtime Database Upgrades using Oracle GoldenGate 12c

4) If the number of updates to the database is very high, does GoldenGate give some kind of compression to transfer the Trail Files and be up to date with the changes?

Oracle GoldenGate does provide support of compress of change data in the Trail File to better the transfer throughput from source to target with the usage of COMPRESS and COMPRESSTHRESHOLD. 

RMTHOST

{host_name | IP_address}

{, MGRPORT port | PORT port}

[, COMPRESS]

[, COMPRESSTHRESHOLD]

[, ENCRYPT algorithm [KEYNAME key_name]]

[, PARAMS collector_parameters]

[, STREAMING | NOSTREAMING]

[, TCPBUFSIZE bytes]

[, TCPFLUSHBYTES bytes]

[, TIMEOUT seconds]

COMPRESS

This option is valid for online or batch Capture processes and any Oracle GoldenGate initial-load method that uses Trails. Compresses outgoing blocks of records to reduce bandwidth requirements. Oracle GoldenGate decompresses the data before writing it to the Trail. COMPRESS typically results in compression ratios of at least 4:1 and sometimes better. However, compressing data can consume CPU resources.

COMPRESSTHRESHOLD

This option is valid for online or batch Capture processes and any Oracle GoldenGate initial-load method that uses trails. Sets the minimum block size for which compression is to occur. Valid values are from 0 and through 28000. The default is 1,000 bytes.

5) Can the Source system utilize 12C GoldenGate for DML/DDL capture and target system utilize GoldenGate 11g?

Yes.  You can replicate from a higher version of GoldenGate to a lower version using FORMAT RELEASE option. 

FORMAT RELEASE <major>.<minor>

In the on demand replay of the webcast you will find more questions answered by our product management experts. So make sure to watch the on demand webcast as well.

Tuesday May 06, 2014

No Way Out, But to Consolidate

IT teams receive pressures on multiple fronts: Business groups demand new application services delivered faster and continuous, high-quality IT service to support highly dynamic and competitive business operations. In the meanwhile IT teams are asked to reduce costs and improve ROI from existing systems in highly complex and siloed environments.

In the midst of this conundrum, the only way out for IT leadership is to consolidate and leverage cloud architecture. Especially consolidation at the database level and implementing a private database-as-a-service (DBaaS) environment is a transformative approach to delivering database functionality to end users in an agile, efficient, and scalable way.  It helps organizations improve resource utilization, and lower both capital and operational expenditures.

Oracle Database 12c is designed to support database consolidation with many new features for deploying shared database environment. The new multitenant architecture, simplified management capabilities, improvements to security and compliance, along with robust and flexible Maximum Availability Architecture, are only a few of the key differentiators.

While this all sounds good and logical for IT teams, when it comes to moving to a private database cloud, they face yet another major challenge: How do we move our critical systems to a new environment without interrupting our operations. In today’s 24/7 world, especially customer-facing systems cannot tolerate hours or days of downtime. For some of them, even few minutes of downtime can bring high costs to the business. As in each major project, risk involved with moving to a new system is a real deterrent factor too.

Oracle GoldenGate 12c offers the core capabilities to enable this major move to a database as a service environment. With its optimized support for Oracle Database 12c multitenant architecture and heterogeneous data replication capabilities, Oracle GoldenGate allows organizations to avoid business disruption while the systems are moving to a consolidated, DBaaS environment. In addition, Oracle GoldenGate offers a failback option to the old environment, or a phased migration option by running old and new systems simultaneously in active-active mode, to minimize risks. Oracle GoldenGate’s heterogeneity includes all major database vendors and operating systems including SQL Server, DB2 (LUW, z/Os, iSeries), Sybase ASE, HP NonStop and more. 

In our webcast Zero Downtime Consolidation to Oracle Database 12c with Oracle GoldenGate 12c on May 13th 10am PT we will present this solution with specific architecture examples and comparison to other database upgrade options.

Zero Downtime Consolidation to Oracle Database 12c with Oracle GoldenGate 12c

May 13th, 10am PT/ 1pm ET

If your organization needs to improve agility, increase innovation, and reduce costs, I invite you to join this webcast to learn how to remove the risk and business interruption barriers to move to an agile and cost-efficient private database cloud.

Tuesday Apr 29, 2014

What's New in Oracle GoldenGate 12c for DB2 iSeries

Oracle GoldenGate 12c (12.1.2.0.1) for IBM DB2 iSeries was released on February 15, 2014. The new version delivers the following new features: 

  • Native Delivery (Replicat): the new feature allows the user to install Oracle GoldenGate on the IBM i server and delivers the data directly to the IBM DB2 for i database. In previous releases, users had to install Oracle GoldenGate on a remote server and apply the data to the IBM DB2 for i database via ODBC. The native delivery not only improves the performance but also supports the GRAPHIC, VARGRAPHIC and DBCLOB datatypes, which are not supported in the ODBC remote delivery for IBM DB2 for i. 
  • Schema Wildcarding: as with other databases that Oracle GoldenGate supports, the schema wildcarding is now available for the IBM DB2 for i database as well.
  • Auto discard: the discard file is now created by default. 
  • Coordinated Delivery (Replicat):  the coordinated delivery is supported in the native delivery (replicat). 
  • BATCHSQL: supported on IBM i 7.1 and higher version. 

Thursday Oct 24, 2013

Oracle GoldenGate 12c - Leading Enterprise Replication

Oracle GoldenGate 12c released  on October 17th and includes several new cutting edge features that firmly establishes GoldenGate's leader position in the data replication space.   In fact, this release more than doubles the performance of data delivery, supports Oracle's new multitenant database feature,  it's more secure, has more options for high availability, and has made great strides to simplify the configuration and deployment of the product.     Read through the press release if you haven't already and do not miss the quote from Cern's Eva Dafonte Perez, regarding Oracle GoldenGate 12c "….performs five times faster compared to previous GoldenGate versions and simplifies the management of a multi-tier environment"

There are a variety of new and improved features in the Oracle GoldenGate 12c.  Here are the highlights:

  • Optimized for Oracle Database 12c -  GoldenGate 12c is custom tailored to the unique capabilities of Oracle database 12c and out of the box GoldenGate 12c supports multitenant (pluggable database (PDB)) and non-consolidated deployments of Oracle Database 12c.   The naming convention used by database 12c is now in three parts (PDB-name, schema-name, and object name).  We have made changes to the GoldenGate capture process to support the new naming convention and streamlined the whole process so a single GoldenGate capture process is being used at the container level rather than at each individual PDB.  By having the capture process at the container level resource usage and the number of processes are reduced. To view a conceptual architecture diagram click here.
  • Integrated Delivery for the Oracle Database - Leveraging a lightweight streaming API built exclusively for Oracle GoldenGate 12c, this process distributes load, auto tunes the degree of parallelism, scales better, and delivers blinding rates of changed data delivery to the Oracle database.  One of the goals for Oracle GoldenGate 12c was to reduce IT costs by simplifying the configuration and reduce the time to manage complex infrastructures.  In previous versions of Oracle GoldenGate, customers would split transaction loads by grouping tables into multiple different delivery processes (click here to view the previous method). Each delivery process executed independently and without any interaction or knowledge of other delivery processes.  This setup was complicated to configure and time consuming as the developer needed in-depth knowledge of the source and target schemas and the transaction profile. With GoldenGate 12c and Integrated Delivery we have made it easier to configure and faster to deploy.  To view a conceptual architecture diagram of integrated delivery click here
  • Coordinated Delivery for Non-Oracle Databases - Coordinated Delivery orchestrates high-speed apply processes and simplifies the configuration of GoldenGate for non-Oracle targets. In Oracle GoldenGate 12c a single delivery process is used with multiple threads (click here) and key events, such as primary key updates, event markers, DDL, etc, are coordinated between the various threads to insure that the transactions are applied in the same sequence as they were captured, all while delivery improved performance. 
  • Replication Between On-Premises and Cloud-Based systems. - The trend for business to utilize both on-premises and cloud-based systems is rising and businesses need to replicate data back and forth.   GoldenGate 12c can be configured in a variety of ways to provide real-time replication when unrestricted or restricted (limited ports or HTTP tunneling) networks are between on-premises and cloud-based systems.   

  • Expanded Heterogeneity - It wouldn't be a GoldenGate release without new and improved platform support.   Release 1 includes support for MySQL 5.6 and Sybase 15.7.   Upcoming in the next release GoldenGate, support will be expanded for MS SQL Server, DB2, and Teradata.
  • Tighter Security - Oracle GoldenGate 12c is integrated with the Oracle wallet to shield usernames and passwords using strong encryption and aliases.   Customers accustomed to using the Oracle Wallet with other Oracle products will instantly be familiar with how to use this great new feature
  • Expanded Oracle Application and Technology Support -   GoldenGate can be used along with Oracle Coherence to enable real-time changed data feeds to the Coherence cache using Toplink and the Oracle GoldenGate JMS adapter.     Plus,  Oracle Advanced Customer Services (ACS) now offers a low downtime E-Business Suite platform and database migrations using GoldenGate as the enabling technology. 

Keep tuned for more blogs on the new features and the upcoming launch webcast where we will go into these new features in more detail.   In the mean time make sure to read through our white paper "Oracle GoldenGate 12c Release 1 New Features Overview"

Wednesday Sep 25, 2013

Oracle GoldenGate AppAdvantage in Action at Land O’Lakes, Smuckers, and Veolia Water

On Tuesday at OpenWorld we had the honor to host a panel with GoldenGate customers: Land O’Lakes, Smuckers, and Veolia Water. Besides giving us yummy nutrition and healthy water, these companies have another aspect in common. They all use GoldenGate to boost their ERP application.

Veoila Water’s Pierre Kerrinckx came from their HQ in France for this panel and spoke to us about the database migration project for their JD Edwards ERP system. Using GoldenGate Veolia was able to migrate from Oracle Database 10gR2 on Aix 5.3 Oracle 10g R2 to Oracle Database Aix 7.1 Oracle 11g R2 and did so with only 2 hours of interruption to JD Edwards end users. Pierre mentioned, the other benefit of GoldenGate was the ability to switch back to the old environment if needed.

Land O’Lakes’ Mark Kohls talked about their use of GoldenGate for their JD Edwards ERP system supporting the Purina business line. Land O’Lakes had to migrate enterprise-wide JDE Xe ERP system to new database and application server platform with minimal downtime to the business. While their goal was to have less than 8 hours of downtime, with GoldenGate they limited downtime to 30 minutes.

Both Veolia and Land O’Lakes used GoldenGate in an Active-Passive fashion, meaning that the new environment was not used simultaneously with the old one, and the users migrated all at once. GoldenGate provides Active-Active migration model too, if the company prefers to do a phased migration and truly zero downtime.

Smuckers's Neal Indermuhle had a different story to share. He talked about operational reporting for their critical Oracle E-Business Suite and how using Oracle GoldenGate helped the company to achieve the near real-time data they need in making critical business decisions. Neil shared that the replication latency averages less than 10 seconds and Oracle GoldenGate Veridata is leveraged to validate synchronization.

I would like to thank Pierre, Mark, and Neal for sharing their best practices, and taking tough questions from the audience. If you would like to learn more about Oracle GoldenGate’s solutions for JD Edwards, E-Business Suite and other key Oracle Applications please check out our new resource center with recorded video presentations and detailed white papers.

Before I get ready for another full day at OpenWorld tomorrow I would like to leave you with the key GoldenGate sessions we have lined up for Wednesday:

Best Practices for Integrating Oracle GoldenGate with Oracle Active Data Guard (CON8500)
Wednesday, September 25, 2013 at 10:15AM-11:15AM PT
Moscone South – 104

Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)
Wednesday, September 25, 2013 at 11:45AM-12:45PM PT
Moscone West – 2024

Integrated Apply for Oracle Database: Scalable Replication with Oracle GoldenGate (CON8198)
Wednesday, September 25, 2013 at 5:00PM-6:00PM PT
Moscone North – 131

Friday Sep 20, 2013

Must-Attend Oracle GoldenGate sessions at OpenWorld

 We are very excited for a great event next week. In my last couple of blogs I gave overviews of what is lined up in the Data Integration track. Today I’d like to highlight some of the other key Oracle GoldenGate sessions in case you missed them in our Focus On Data Integration document.

 Obviously the Oracle GoldenGate: New Features and Product Strategy (CON8867) session on Monday at 12:15PM in Moscone West – 2024 is a must-attend session for the GoldenGate community. You will hear the latest features and the roadmap.

If you are currently evaluating high availability solutions then the session “Continuous Availability with Oracle GoldenGate: Best Practices from Comcast” will help you greatly. You’ll get to hear best practices from Comcast on how they implemented four-way and three-way multimaster (active-active) replication architectures using Oracle GoldenGate. You can see how they were able to perform zero downtime system maintenance activities such as patching and upgrades of the operating systems and relational databases supporting critical business operations.

Continuous Availability with Oracle GoldenGate: Best Practices from Comcast (CON8951)

Monday at 12:15PM PT Moscone South – 300

 On Tuesday the session “A Panel of Masterminds: Perspectives from Oracle GoldenGate Customers” will feature a customer panel made up of enterprise architects and other data integration professionals to discuss how they revolutionized their business using Oracle GoldenGate. This interactive session will provide examples of how Oracle GoldenGate supports critical Oracle Applications such as Oracle E-Business Suite and JD Edwards.

A Panel of Masterminds: Perspectives from Oracle GoldenGate Customers (CON8898)

Tuesday at 3:45PM-4:45PM PT Moscone West – 2024

Data integration is not simply replication and in many instances it requires real-time ETL capability. Oracle GoldenGate and Oracle Data Integrator work together for improved data integration agility. In the Hands-On-Lab “Combining Oracle Data Integrator and Oracle GoldenGate”, specifically designed for developers, DBAs, and architects, you will hear best practices for using Oracle GoldenGate and Oracle Data Integrator together to perform real-time ETL. Attendees will experience and hands-on walkthrough on how to configure Oracle GoldenGate from Oracle Data Integrator Studio

 Hand-on-Lab: Combining Oracle Data Integrator and Oracle GoldenGate (HOL10144)

Tuesday at 3:45PM Marriott Marquis – Nob Hill AB

Oracle GoldenGate and Oracle Active Data Guard are two powerful technologies that can be implemented together seamlessly. On Wednesday you can learn how these two technologies can work together in the session “Best Practices for Integrating Oracle GoldenGate with Oracle Active Data Guard”. For Oracle Database customers incorporating data integration with high availability, this session is a can’t miss!

Best Practices for Integrating Oracle GoldenGate with Oracle Active Data Guard (CON8500)

Wednesday 10:15AM PT Moscone South – 104

 For E-Business Suite, Oracle BI, and Oracle Coherence customers a great session awaits you on Wednesday: “Powering Solutions for Oracle Applications with Oracle GoldenGate” will cover E-Business Suite platform migrations and operational reporting, Oracle BI real-time reporting, and Oracle Coherence hot caching. This is a great opportunity to learn how Oracle GoldenGate can extend capabilities with your business applications

Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)

Wednesday 11:45AM PT Moscone West – 2024

 On Thursday we will start with the session “Oracle Management Pack for Oracle GoldenGate: Product Update”, which will cover the latest features and enhancements to managing and monitoring GoldenGate.

Oracle Management Pack for Oracle GoldenGate: Product Update (CON9105)

Thursday 11:00AM PT Moscone West – 2012

 In the session “Deploying Oracle GoldenGate with Multitenant Container Databases” you can learn how Oracle GoldenGate can be deployed to capture and replicate changes using Container Databases (CDBs) and Pluggable Databases (PDBs) introduced in the Oracle Database 12c multitenant architecture. Our experts will also provide Oracle GoldenGate configuration recommendations for common and advanced deployment models within the multitenant architecture.

Deploying Oracle GoldenGate with Multitenant Container Databases (CON8499)

Thursday 2:00PM Moscone South – 200

A key use case for GoldenGate is providing zero downtime, and low-risk database upgrades and platform changes. “Cross-Platform Database Upgrades with Oracle GoldenGate” will cover database upgrade scenarios and how you can leverage Oracle GoldenGate and Oracle Data Guard technologies to achieve your upgrade goals. In addition, you will learn how to take advantage of Oracle Advanced Customers Support Services to help you complete your business-critical upgrades while achieving high availability.

Cross-Platform Database Upgrades with Oracle GoldenGate (CON4286)

Thursday 2:00PM Moscone South – 305

As every year GoldenGate team offers a set of strong hands-on-labs. “Deep Dive into Oracle GoldenGate” hands-on-lab’s focus is to provide an overview of the Oracle GoldenGate architecture and then allow attendees to instantiate a secondary database that can be used for disaster recovery or a reporting instance. Hope you can join this session and see firsthand how easy Oracle GoldenGate is to use and how it can be a very valuable technology solution for your organization.

Deep Dive into Oracle GoldenGate (HOL10026)

Thursday 11:00AM Marriott Marquis – Nob Hill AB

Oracle GoldenGate customers looking to take control of their Oracle GoldenGate deployments must attend our Hands-On-Lab session “Deep Dive into Oracle GoldenGate Monitor”. This lab will focus on our complementary product Oracle GoldenGate Monitor, designed to deliver end-to-end visibility into Oracle GoldenGate instances across the enterprise. Attendees will learn about key features including automatic heterogeneous solution discovery, persisted monitoring points, display of replication elements, lag graphs, and creation of alerts.

Deep Dive into Oracle GoldenGate Monitor (HOL10128)

Thursday 12:30 PM - 1:30 PM PT-- Marriott Marquis - Nob Hill AB

I also would like to remind you that you can visit GoldenGate product management in the following demo pods to ask your questions:

Oracle GoldenGate and Oracle Data Integrator – POD 3412

Monitoring Oracle GoldenGate for End-to-End Visibility – POD 3493

Oracle GoldenGate for Oracle Applications – POD 3494

Oracle GoldenGate: Real-Time Transactional Database Replication – POD 3518

Next week you will hear from me and our PM team about what was discussed in these sessions. Stay tuned for more, and enjoy OpenWorld 2013 next week!

 

Friday Sep 06, 2013

Sneak Peek into Data Integration Sessions at Oracle OpenWorld 2013

As we are getting ready for another great OpenWorld I'd like to give you sneak peek into what we have planned for data integration topics this year. As in the last few years, the Data Integration track is again full with great customer speakers, product updates, and hands-on-labs. While I am not able to share everything we will cover in these sessions I can say that you will get to hear about new solutions and new features for both Oracle Data Integrator and Oracle GoldenGate.

On Monday at 10:45am our VP of Development Brad Adelberg will open the data integration track by presenting the direction of Oracle Data Integrator and Oracle GoldenGate in the Accelerating Your Business with Oracle Data Integration Solutions (Moscone West 2024) session. Brad will explain how Oracle's data integration products enable organizations to get the most value out of big data,  their investments into Oracle Applications, and cloud deployments. The session will cover the key themes of the upcoming releases of our products.

Following Brad's great overview into overall Oracle Data Integration, GoldenGate product management will present  Oracle GoldenGate New Features and Product Strategy at 12:15pm in the same location. You will hear about new features of the product. Following GoldenGate PM, Oracle Data Integrator product management will present Oracle Data Integrator's product vision and new features in the session:
Oracle Data Integrator Product Update and Future Strategy at 1:45pm in the same room: Moscone West 2024.

The last session of Monday is a must-attend session. You will get to meet the winners of  the Oracle Excellence Awards for Oracle Fusion Middleware Innovation and learn about their impressive success stories across all Fusion Middleware products. I highly recommend adding Oracle Fusion Middleware: Meet This Year’s Most Impressive Innovators to your OpenWorld schedule. It will take place at 4:45pm  at Yerba Buena Center for the Arts, Lam Research Theater.

On Tuesday data quality product strategy sessions will kick off the day for our track with Oracle Enterprise Data Quality: Product Overview and Roadmap at 10:30am (Moscone West 2024) . Right after this session you will have a chance to hear from GoldenGate customers in the A Panel of Masterminds: Perspectives from Oracle GoldenGate Customers session at 3:30pm in the same room. This panel brings us presenters from Smuckers, Land o Lakes and OTV France. I will discuss this session in more detail next week. For now I will mention that customers will discuss how they achieved zero downtime upgrades and migrations and improved performance using GoldenGate with their Oracle Applications.

At the end of Tuesday you can attend another informative Oracle Data Integrator session about Extracting Strategic Insights from Business Data with Oracle Data Integrator (5:30pm, Moscone West 2012)

Wednesday starts with a great customer panel, Real-World Data Quality: Customers Using Oracle Enterprise Data Quality, at 10:15am in Moscone 2024. The must-attend session of Wednesday is Customer Perspectives: Oracle Data Integrator.  Paychex, Infiniti Insurance are among the customers presenting in this session and will be discussing best practices in implementing Oracle Data Integrator. Don't miss this session at 1:15pm in Moscone 2012.  I also recommend checking out at 3:30pm Making the Move to Oracle Data Integrator. ODI PM will be joined by Oracle partners Rittman Mead and sumIT AG. Together they will share great tips for a phased migration path from Oracle Warehouse Builder to Oracle Data Integrator.

Thursday is packed with many in-depth technical product deep dive sessions from experts. The two that I want to highlight here are: Configuring Oracle Business Intelligence Applications on Oracle Data Integrator: A Deep Dive, which will explain best practices for configuring and tuning Oracle Business Intelligence Applications' latest release which embeds Oracle Data Integrator.  This one is at 12:30pm at Moscone South 303. The second session I recommend, Deploying Oracle GoldenGate with Multitenant Container Databases, will share details on how to set up GoldenGate in the context of container databases (CDBs). You can attend it at 2pm at Moscone South 200.

Even though I listed 12 session in this blog post for you to review, there are many more, very informative sessions available this year at OpenWorld. Please make sure to review the Focus On Data Integration to discover other sessions that may interest you.

Stay tuned for more blogs on the some of the key sessions I mentioned above.


Friday Aug 23, 2013

Ensuring Data Consistency with Oracle GoldenGate Veridata

Today’s 24/7/365, fast-paced world brought the need for high data availability and with that came redundant distributed copies of the data. In our complex IT environment, maintaining data consistency across these distributed systems is not a trivial task unfortunately. Data discrepancy occurs for many reasons, including database configuration differences between source and target, configuration errors during data migration, user errors, gaps in data replication or replication lags. Even when using products that replicate data reliably, such as Oracle GoldenGate, there remain potential causes of data discrepancy.

When data discrepancies occur, businesses can see its impact in the form of incorrect decision-making; failed service-level agreements; and ultimately, operational, financial, and legal risk.

Oracle GoldenGate Veridata helps companies avoid these risks and operate their redundant systems with high confidence knowing that their backup systems, reporting databases, multi-master replication environments have consistency. Oracle GoldenGate Veridata provides an easy-to-use yet powerful solution for identifying out-of-synch data before it negatively impacts the business.

Deployed together with the Oracle GoldenGate real-time data replication  product or separately, Oracle GoldenGate Veridata ensures data consistency is maintained across databases. The software enables periodic checks—as frequently as desired—between heterogeneous source and the target databases without taking either system offline.

Some of the benefits of the product include:

  • Reduced risk exposure. Knowing about data inconsistencies can help address issues before they impact business operations. Oracle GoldenGate Veridata identifies data discrepancies so that corrective measures can be quickly taken.
  • Improve IT Productivity. Oracle GoldenGate Veridata's automated data comparison capabilities reduces the time and resources required for data validation Graphical illustrations and detailed reports clearly convey the key results and specific data disparities so that IT can take immediate corrective action. If there are no inconsistencies, users can document the accuracy of their data for regulatory compliance reporting needs.
  • Continuous operation during validation. With its ability to compare in-flight transactions, Oracle GoldenGate Veridata supports databases that are in use without interrupting business operations. Combining a light footprint and groundbreaking technology, the application imposes minimal impact on technology infrastructure.

If your organization has strict requirements to keep redundant systems consistent, I highly recommend reading more about Oracle GoldenGate Veridata product via our new white paper: Ensuring Data Consistency with Oracle GoldenGate Veridata.

You can also find out best practices on installation and configuration in the Oracle GoldenGate Veridata Handbook on My Oracle Support (Knowledge ID 1583563.1.)

Tuesday Feb 05, 2013

Deeper Look into Integrated Capture for Oracle Database

With Oracle GoldenGate 11gR2 we announced a new "Integrated Capture" process for the Oracle Database. In our launch webcast back in September'12 our product team presented this feature along with other key features such as intelligent conflict management, advanced encryption, global deployment support and more.  You can watch that webcast on demand here.

We now have a recorded presentation with more details on this new feature. You can watch the GoldenGate Integrated Capture screencast to get a deeper look into this feature.

Integrated Capture for Oracle Database is very unique in the industry. This feature enables a deeper integration into the database engine and serves as the foundation for new features GoldenGate for Oracle Database will be adding  in the future.

As we mentioned in our recent Maximum Availability with Oracle GoldenGate webcast, GoldenGate's Classic Capture is still available for both Oracle Database, as well as other non-Oracle databases GoldenGate supports. Below is an overview of supported Oracle Database versions and features for both Classic and Integrated Capture.

Also please make sure to check out our new resources on GoldenGate's continuous availability solutions to learn more about Integrated Capture feature and other key new features.

Thursday Jan 10, 2013

Maximum Availability with Oracle GoldenGate Webcast: On Demand Link & FAQ

Last month we had a live webcast on a hot topic: Maximum Availability with Oracle GoldenGate. The webcast presentation focused on how Oracle GoldenGate can help achieve maximum availability for Oracle Database and other major databases. This webcast was very useful in answering a frequently asked question around GoldenGate's role for Oracle Database Maximum Availability Architecture (MAA) and when to use Oracle GoldenGate vs Active Data Guard. Product experts, Joe Meeks from Oracle Database High Availability product management team and Nick Wagner from Oracle GoldenGate product management team, addressed this question for us. Joe and Nick presented GoldenGate’s key solutions within MAA, and when to use which product along with Integrated Capture and Automated Conflict Management features of GoldenGate 11gR2. If you missed this event I highly recommend watching it on demand via the following link.

Watch On Demand:Maximum Availability with Oracle GoldenGate.

We also recorded a short podcast on this topic. Oracle GoldenGate 11gR2 for Maximum Availability

In the live webcast we had a very interactive audience who submitted over 100 questions during the event. Joe and Nick answered the most commonly asked questions about GoldenGate’s use cases and technology. Here are a few of the questions that we did not have time to answer during the event, along with the answers from the PM team.

  • Can I use the target database as warehouse for select only. If I were to allow users to this target, are there steps to ensure both source and target databases remain in sync?

 Yes you can use the target for read only or select only operations. Yes, we can do bi-directional active-active replication if you want to allow users to make changes to the target system. We can replicate those back to the source.

  • Can Integrated Capture be run on Oracle Database Standard Edition?

Yes, but all of the features that are only supported by Integrated Capture are only available with Oracle Database Enterprise Edition.

  •  Is it possible to capture database transactions from a source database using GoldenGate and publish them as messages into   a JMS queue?

Yes, GoldenGate can capture from and deliver to JMS queue. Please see our page for Java Adapter for more info. 

  • Can GoldenGate be used in environments where a number of tables do not have primary keys?

Yes. In tables without primary keys, we will use all non-LOB columns in the where clause for updates and deletes and then use ROWNUM = 1.

  • Is there a webinar that shows how to set up Oracle GoldenGate?

 Oracle GoldenGate Youtube channels has many useful videos and labs including “Oracle GoldenGate Fundamentals and How Oracle GoldenGate Works” and “Oracle GoldenGate Deep Dive Hands-on Labs” in 3 part series. You can browse and watch them here. Please check out GoldenGate training sessions with Oracle University as well.

I highly recommend subscribing to GoldenGate’s Youtube channel along with joining the GoldenGate Facebook and Twitter communities to get regular updates on the product.

Monday Aug 27, 2012

It was worth the wait… Welcome Oracle GoldenGate 11g Release 2

It certainly was worth the wait to meet Oracle GoldenGate 11gR2, because it is full of new features on multiple fronts. In fact, this release has the longest and strongest list of new features in Oracle GoldenGate’s history. The new release brings GoldenGate closer to the Oracle Database while expanding the support for global implementations and heterogeneous systems. It is more secure, more flexible, and faster.

We announced the availability of Oracle GoldenGate 11gR2 via a press release. If you haven’t seen it yet, please check it out. As covered in this announcement, there are a variety of improvements in the product:

  • Integrated Capture for Oracle Database: brings Oracle GoldenGate’s Capture process closer to the Oracle Database engine and enables support for Advanced Compression among other benefits.
  • Enhanced Conflict Detection & Resolution, speeds and simplifies the conflict detection and resolution process for Active-Active deployments.
  • Globalization, meaning Oracle GoldenGate can be deployed for databases that use multi-byte/Unicode character sets.
  • Security and Performance Improvements, includes support Federal Information Protection Standard (FIPS).
  • Increased Extensibility by kicking off actions based on an event record in the transaction log or in the Trail file.
  • Integration with Oracle Enterprise Manager 12c , in addition to the Oracle GoldenGate Monitor product.
  • Expanded Heterogeneity, including capture from IBM DB2 for i on iSeries (AS/400) and delivery to Postgres

We will explain these new features in more detail at our upcoming launch webcast:

(Sept 12 8am/10am PT)

In addition to learning more about these new features, the webcast will allow you to ask your questions to product management via live Q&A section. So, I hope you will not miss this opportunity to explore the new release of Oracle GoldenGate 11g and see how it can deliver enterprise-class real-time data integration solutions..

I look forward to a great webcast to unveil GoldenGate’s new capabilities.

About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
7
11
12
13
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today