Encrypting database user passwords
GoldenGate requires an Oracle user password to connect to the source and target databases. In this recipe you will learn how to encrypt the database passwords using the ENCRYPT
utility.
Getting ready
You need to generate the encryption keys and store them in the ENCKEYS
file before generating encrypted passwords. Follow the steps in the Generating encryption keys recipe to generate and store a 256-bit key called dbkey1
in the ENCKEYS
file.
Tip
Although you can generate encrypted passwords using the DEFAULT
encryption keys, Oracle recommends using custom encryption keys for all production systems.
How to do it…
Encrypting the database user password involves the following steps:
- From GoldenGate Home, run the GoldenGate ...
Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.