Oracle GoldenGate 12c - irantuto.com

1 Oracle GoldenGate 12c Implementer's Guide Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise John P Jeffries professional expertise distilled P U B L I S H I N G. BIRMINGHAM - MUMBAI. Oracle GoldenGate 12c Implementer's Guide Copyright 2015 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented.

2 However, the information contained in this book is sold without warranty, either express or implied. Neither the author nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information. First published: February 2011. Second edition: July 2015. Production reference: 1210715. Published by Packt Publishing Ltd. Livery Place 35 Livery Street Birmingham B3 2PB, UK.

3 ISBN 978-1-78528-047-4. Credits Author Project Coordinator John P Jeffries Milton Dsouza Reviewers Proofreader Asif Momen Safis Editing Shuxuan Nie Gavin Soorma Indexer Monica Ajmera Mehta Eric Yen Graphics Commissioning Editor Disha Haria Nadeem Bagban Production Coordinator Acquisition Editor Conidon Miranda Vinay Argekar Cover Work Content Development Editor Conidon Miranda Akashdeep Kundu Technical Editor Siddhesh Ghadi Copy Editors Relin Hedly Akshata Lobo About the Author John P Jeffries has worked in many countries around the world, consulting on the Oracle technology. He is interested in different cultures and enjoys teaching others. At present, John lives and works in Singapore and is employed as a subject matter expert at a global bank, delivering enterprise-wide infrastructure design solutions, particularly in the database private cloud and data replication space.

4 Since he wrote his first book, Oracle GoldenGate 11g Implementer's Guide, he has been heavily focused on leveraging Oracle 's Fusion Middleware products (including GoldenGate ) to address performance, data migration, and data delivery issues. With over 15 years of experience in Oracle , John has worked for a number of global organizations, such as BT, Siebel Systems, Dell, Thomson Reuters, and Oracle Corporation, to name a few. At Oracle , he worked in advanced customer services on key accounts as a senior principal consultant and became the UK data replication expert, often publishing articles on his own website ( ). John is an Oracle Certified Professional and a GoldenGate specialist.

5 He gives presentations at ODTUG conferences and continues to share his real-life hands-on experience through his work. Known for his ability to provide robust, effective solutions and workarounds, John delivers his knowledge, tips, and tricks in his new book, Oracle GoldenGate 12c Implementer's Guide. Thank you for purchasing my book, which would not have been possible without the help and support of a number of key people and organizations. First, I would like to thank my wife, Wendy, for her dedication, encouragement, and the sacrifice that she has endured. I would also like to thank her for her support at weekends and for putting up with my late nights' work. Wendy also helped me with the proofreading.

6 Second, I would like to thank the reviewers of this book, who provided me with excellent feedback that helped me focus on the material for the Oracle community. Finally, I would like to thank Packt Publishing for asking me to write a second edition of Oracle GoldenGate 11g Implementer's Guide. I trust that you will find this edition just as interesting and informative as the first, enabling you to tailor a successful implementation of Oracle 12c GoldenGate to your specific requirements. About the Reviewers Asif Momen has been working with Oracle technologies for over 14 years and has expertise in database architecture, performance tuning, and high availability. He has a master's degree in software systems from Birla Institute of Technology and Science (BITS), Pilani.

7 Asif has been honored with the prestigious Oracle ACE award from Oracle Technology Network. He has authored Oracle Database XE 11gR2 Jump Start Guide for Packt Publishing. Asif is an Oracle Certified Master (OCM) and has certifications in OCP 11g DBA and OCP 9i Forms Developer. He is also an Oracle Certified Expert in RAC 10g. Asif has given presentations at the Oracle OpenWorld 2012, 2011, and 2010. conferences, All India Oracle User Group (AIOUG), and Middle East Oracle User Group (MEOUG). He is an active contributor to the Oracle user community and plays the following roles in various users groups: Member of the executive committee, Middle East Oracle User Group (MEOUG). Member of the editorial team, All India Oracle User Group (AIOUG).

8 Technical reviewer, Oracle Scene, UK Oracle User Group His articles have appeared in Oracle Support - Customer Knowledge Exchange. His main areas of interest include database architecture and tuning, Oracle RAC, and backup and recovery. He posts his ideas and opinions on The Momen blog at Asif can be reached at Shuxuan Nie is a platform architect with specialization in SOA, Oracle VM, Exalogic, and Java technologies. She holds an MS in computer science from Beijing University of Aeronautics and Astronautics. ShuXuan has 15 years of experience in the IT industry, which includes SOA technologies, such as BPEL, ESB, SOAP, XML, Enterprise Java technologies, Eclipse plugins, and C++ cross-platform development.

9 Since 2010, she has been working at Rubicon Red, helping customers resolve integration issues and design and implement highly available infrastructure platforms on Oracle VM and Exalogic. From 2007 to 2010, ShuXuan worked with the Oracle Global Customer Support team and focused on helping customers solve their middleware/SOA integration problems. Before joining Oracle , he worked as a staff software engineer at IBM China Software Development Lab for 4 years and participated in several complex products, such as IBM Lotus Workplace, WebSphere, and the Eclipse platform. Later, he joined the Australia Bureau of Meteorology Research Center, where he was responsible for the implementation of the Automated Thunderstorm Interactive Forecast System for Aviation and Defense.

10 Gavin Soorma is an Oracle ACE and Oracle Certified Master with over 19 years of experience. He is also an Oracle Certified Professional (versions , 8i, 9i, 10g, 11g, and 12c) and an Oracle Certified Implementation Specialist in GoldenGate , Exadata, and Enterprise Manager 12c. Gavin regularly gives presentations at various Oracle conferences and seminars. He has presented several papers at the IOUG, South African Oracle User Group, Oracle OpenWorld, and the Australian Oracle User Group. He presented a paper on Oracle GoldenGate titled Real Time Access to Real Time Information at AUSOUG 2015, which was held in Melbourne and Perth. He is currently employed as a senior principal consultant at OnCall DBA, an Oracle solution provider based in Perth, Western Australia.