Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication. The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You’ll learn methods for tuning Oracle GoldenGate performance. You’ll discover GoldenGate’s utility as a migration and extract, transform, load (ETL) tool. You’ll learn to configure highly-available environments involving GoldenGate, Real Application Clusters, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment. Explains all aspects of using GoldenGate for replication Covers homogeneous, heterogeneous, and bidirectional replication Shows the use of GoldenGate for data migration and extract, transform, load (ETL)

A step-by-step guide to practising Oracle GoldenGate High Availability (HA) options, Microservices, and Real-Time downstream techniques _DESCRIPTIONÊ The book starts with a brief introduction about Oracle GoldenGate with Microservices and how to configure high availability using various methods. Oracle GoldenGate Microservices Architecture (MA) is a similar architecture based on REST APIs which enable us to configure, monitor, and manage Oracle GoldenGate services using a web-based user interface. Each module supports a specific business goal and uses a simple, lightweight, and well-defined interface to communicate with other sets of services. Oracle GoldenGate can interact with custom conflict-resolution routines that customers write to satisfy their business rules. KEY FEATURESÊÊ - Understand how and when they're used classic Vs. Microservices - Learn how to use real-time downstream methods based on the environment - Learn how to solve Oracle GoldenGate (OGG) Conflict Detection and Resolution (CDR) in bi-directional, active replication - Learn how to implement high availability for mission-critical systems using Oracle GoldenGate Ð XAG components - Learn how to set up bi-directional replication between pluggable databases (PDBs) in a multi-tenant environment - Learn how to use differently typed of replicates in pluggable databases (PDBs) in a multi-tenant environmentÊ WHAT WILL YOU LEARNÊ By the end of the book, you will come across a few case studies about how to use Microservices, Kubernetes, REST APIs in Oracle GoldenGate, and How to monitor Oracle GoldenGate processes in real-time environments. This book also helps how to use various file systems like ACFS, DBFS, and NFS in high availability for Oracle GoldenGate.ÊÊ WHO THIS BOOK IS FORÊÊ This book is intended for anyone looking for how to set up and configure Uni-directional, Bi-directional replication in mission-critical environments either using classic Oracle GoldenGate OR Oracle GoldenGate with Microservices. This book also helps various methods to implement real-time downstream techniques. Table of Contents 1. Introduction to Oracle GoldenGate HA - XAG Components 2. Extract and Replicat in Multitenant Environment 3. Consolidated and Cascaded Oracle GoldenGate 4. Introduction to Oracle GoldenGate Methodologies 5. Introduction to Oracle GoldenGate Utilities 6. Bi-Directional Replication with Conflict Detection and Resolution (CDR) 7. Bi-directional Replication with Pluggable Databases (PDBs) in Multitenant Environment 8. Real-Time Downstream Database with Multiple Scenarios 9. Oracle GoldenGate Microservices Architecture overview 10. Managing Oracle GoldenGate and Kubernetes 11. Automation Recipes Via Rest APIs 12. Oracle GoldenGate Tuning and Troubleshooting

Design, install, and configure high-performance data replication solutions using Oracle GoldenGate with this book and eBook.

Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manage relational databases. A key part of that change lies in the concept of offloading SQL processing to the storage layer. In addition there is Oracle's engineering effort in creating a powerful platform for both consolidation and transaction processing. The resulting value proposition in the form of Exadata has truly been a game-changer. Expert Oracle Exadata, 2nd Edition provides a look at the internals and how the combination of hardware and software that comprise Exadata actually work. Authors include Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and built on the foundation laid by Kerry Osborne, Randy Johnson, and Tanel Poder in the first edition. They share their real-world experience gained through a great many Exadata implementations, possibly more than any other group of experts today. Always their goal is toward helping you advance your career through success with Exadata in your own environment. This book is intended for readers who want to understand what makes the platform tick and for whom—"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. This book changes how you think about managing SQL performance and processing. It provides a roadmap to successful Exadata implementation. And it removes the "black box" mystique. You'll learn how Exadata actually works and be better able to manage your Exadata engineered systems in support of your business. This book: Changes the way you think about managing SQL performance and processing Provides a roadmap to successful Exadata implementation Removes the "black box" mystique, showing how Exadata actually works

Master Oracle GoldenGate 11g Enable highly available, real-time access to enterprise data in heterogeneous environments. Featuring hands-on workshops, Oracle GoldenGate 11g Handbook shows you how to install, configure, and implement this high-performance application. You’ll learn how to replicate data across Oracle databases and other platforms, including MySQL and Microsoft SQL Server, and perform near-zero-downtime migrations and upgrades. Monitoring, performance tuning, and troubleshooting are also discussed in this Oracle Press guide. Install and configure Oracle GoldenGate Implement Oracle GoldenGate one-way replication Configure multitarget and cascading replication Use bidirectional replication to build a heterogeneous database infrastructure Secure your environment, control and manipulate data, and prevent errors Configure Oracle GoldenGate for Oracle Clusterware and Oracle Real Application Clusters Use Oracle GoldenGate with MySQL and Microsoft SQL Server Perform near-zero-downtime upgrades and migrations Use Oracle GoldenGate Monitor and Oracle GoldenGate Director Ensure data quality with Oracle GoldenGate Veridata Implement nondatabase integration options

Now in its third edition, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career. Revised to cover Oracle Database 12c Proof-by-example approach: Let the evidence be your guide Dives deeply into Oracle Database’s most powerful features

Enterprise Manager 12c (EM12c), Oracle’s newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today’s increasingly chaotic and change-driven IT environment. Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle’s online knowledgebase. Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. Provides example solutions to everyday problems through EM12c features. Explains the changes in EM12c, included trusted extensions. Focuses on advanced aspects of the EM12c interface.

Expert Oracle RAC 12c is a hands-on book helping you understand and implement Oracle Real Application Clusters (RAC), and to reduce the total-cost-of-ownership (TCO) of a RAC database. As a seasoned professional, you are probably aware of the importance of understanding the technical details behind the RAC stack. This book provides deep understanding of RAC concepts and implementation details that you can apply toward your day-to-day operational practices. You’ll be guided in troubleshooting and avoiding trouble in your installation. Successful RAC operation hinges upon a fast-performing network interconnect, and this book dedicates a chapter solely to that very important and easily overlooked topic. All four authors are experienced RAC engineers with a wealth of hard-won experience encountering and surmounting the challenges of running a RAC environment that delivers on its promise. In Expert Oracle RAC 12c they provide you a framework in which to avoid repeating their hard-won lessons. Their goal is for you to manage your own RAC environment with ease and expertise. Provides a deep conceptual understanding of RAC Provides best practices to implement RAC properly and match application workload Enables readers to troubleshoot RAC with ease What you’ll learn Know when to apply RAC, and when not to Design applications to take advantage of RAC Troubleshoot and solve clusterware problems Manage database backup and recovery in RAC Stay on top of locking issues and deadlock detection Harness the performance from parallel processing in RAC Support your RAC environment with a healthy network interconnect Who this book is for Expert Oracle RAC 12c is for experienced Oracle Database Administrators (DBAs) who are ready to take the next step in their career by expanding their skill set to include building and managing Oracle Real Application Clusters (RAC). DBAs and architects who are in the process of implementing RAC can immensely benefit from this book. It’s an excellent choice for DBAs to learn RAC conceptually, understand best practices, and become experts in troubleshooting RAC problems. Table of ContentsOverview of Oracle RAC Clusterware Management and Troubleshooting RAC Operational Practices RAC New Features Storage and ASM Practices Application Design Issues Managing and Optimizing a Complex RAC Environment Backup and Recovery in RAC Network Practices in RAC RAC Database Optimization Locks and Deadlocks Parallel Query in RAC Clusterware and Database Upgrades Oracle RAC One Node

GoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate's feature-rich portfolio. Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips.

Master Oracle GoldenGate technology on multiple database platforms using this step-by-step implementation guide. Learn about advanced features to use in building a robust, high-availability replication system. Provided are detailed illustration of Oracle GoldenGate concepts, GoldenGate tools and add-ons, as well as illustrative examples. The book covers Oracle GoldenGate for Oracle database, and also discusses setup and configuration for other common databases such as IBM DB2, SYBASE ASE, MySQL, and Microsoft SQL Server. The technology landscape is fast-changing, and Mastering Oracle GoldenGate stays current by covering the new features included in Oracle GoldenGate 12c. The book covers both classic capture and integrated capture, as well as delivery. Also covered are Oracle GoldenGate security and performance tuning, to keep your system secure and performing at its best. You will learn to monitor your GoldenGate system using tools that come with Oracle GoldenGate management pack, as well as using shell scripts. Troubleshooting is well-illustrated with examples: Covering Oracle GoldenGate technology across common database brands Discussing high-performing and secure replication environments Speaking to replication in Big Data and cloud computing environments What You Will Learn Implement Oracle GoldenGate for real time replication Secure and tune your replication environment for high performance Administer your Oracle GoldenGate environment Learn troubleshooting approaches with help of examples Make use of GoldenGate Management Pack and its API Feed live data into Big Data and cloud-based systems Who This Book Is For Database professionals who have chosen to ride the Oracle GoldenGate roller coaster for real-time replication solutions. The book is for beginners as well as professionals who are willing to master the leading replication technology in the industry. It is an excellent choice for professionals who are implementing or maintaining Oracle GoldenGate replication environments on any of the major database management system platforms.