Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle Goldengate 11g Complete Cookbook

You're reading from   Oracle Goldengate 11g Complete Cookbook Dig deep into administering Oracle Goldengate 11g using this comprehensive cookbook. From the very basics of installation to advanced features like migration, you'll learn the practical way through code scripts and examples.

Arrow left icon
Product type Paperback
Published in Sep 2013
Publisher Packt
ISBN-13 9781849686143
Length 362 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Ankur Gupta Ankur Gupta
Author Profile Icon Ankur Gupta
Ankur Gupta
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Oracle GoldenGate 11g Complete Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Installation and Initial Setup FREE CHAPTER 2. Setting up GoldenGate Replication 3. DDL Replication and Initial Load 4. Mapping and Manipulating Data 5. Oracle GoldenGate High Availability 6. Monitoring, Tuning, and Troubleshooting GoldenGate 7. Advanced Administration Tasks – I 8. Advanced Administration Tasks – Part II 9. GoldenGate Veridata, Director, and Monitor Index

Encrypting the trail files


The trail files are the key component in the GoldenGate configuration. Since these files hold the data that is extracted by the Extract process, keeping them in the default format poses a security risk. We can overcome this security risk by encrypting the trail files using various algorithms. In this recipe we will learn how to configure the automatic encryption of the trail files.

Getting ready

You need to generate the encryption keys and store them in the ENCKEYS file before encrypting the trail files. Follow the steps in the Generating encryption keys recipe to generate and store a 256-bit key called dbkey1 in the ENCKEYS file.

How to do it…

Here are the steps to configure the encryption and decryption of trail files.

Perform the following steps in the source environment:

  1. From GoldenGate Home, run the GoldenGate Software Command Line Interface (GGSCI):

    ./ggsci
  2. Edit the Extract process configuration:

    EDIT PARAMS EGGTEST1
  3. Add the ENCRYPTTRAIL command before the EXTTRAIL...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image