Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle GoldenGate 11g Implementer's guide
  • Table Of Contents Toc
  • Feedback & Rating feedback
Oracle GoldenGate 11g Implementer's guide

Oracle GoldenGate 11g Implementer's guide

By : John P Jeffries, John P Jeffries
4.3 (8)
close
close
Oracle GoldenGate 11g Implementer's guide

Oracle GoldenGate 11g Implementer's guide

4.3 (8)
By: John P Jeffries, John P Jeffries

Overview of this book

Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount. Your days of dismay over the lack of documentation over Oracle GoldenGate are over. Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion. Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters. This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual. With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say "replicate"
Table of Contents (21 chapters)
close
close
Oracle GoldenGate 11 Implementer's guide
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
1
GGSCI Commands
2
GoldenGate Installed Components
3
The Future of Oracle GoldenGate
4
Index

Uninstalling GoldenGate from Linux/UNIX


Uninstalling the GoldenGate software is, as one would expect, the reverse of installing it. The de-installation is as simple as the installation and can be done by following the example below:

  1. Log on to the database server (as oracle) where the GoldenGate software is installed.

  2. Change directory to the GoldenGate home:

    cd /home/oracle/ggs
    
  3. Start GGSCI:

    ggsci
    
  4. Stop all GoldenGate processes:

    GGSCI (dbserver1) 1> stop EXTRACT *
    

    Or:

    GGSCI (dbserver1) 1> stop REPLICAT *
    

    Then:

    GGSCI (dbserver1) 2> stop MGR
    Manager process is required by other GGS processes.
    Are you sure you want to stop it (y/n)? y
    Sending STOP request to MANAGER ...
    Request processed.
    Manager stopped.
    
    GGSCI (dbserver1) 3> exit
    
  5. Change directory to the installation directory:

    cd /home/oracle
    
  6. Remove the GoldenGate files:

    rm -rf ggs
    
  7. Logon to the Oracle database as SYSDBA and drop the GoldenGate Admin user. Include the CASCADE keyword:

    sqlplus / as sysdba
    SQL> drop user ggs_admin...
Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle GoldenGate 11g Implementer's guide
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon