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.
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.
Encrypting the database user password involves the following steps:
From GoldenGate Home, run the GoldenGate Software Command Line Interface (GGSCI):
./ggsci
Run the
ENCRYPT PASSWORD
command as follows:ENCRYPT PASSWORD *** <ALGORITHM> ENCRYPTKEY <key|DEFAULT>
for example:
ENCRYPT PASSWORD TIGER AES256 dbkey1 Encrypted password: AADAAAAAAAAAAAFAQCFIIDLCUELFNFECLITBSCAHYBBHHEUGKDNICDCCDCFELJDJFFEAUHUBFGWIUJGCAJJDNDPDZEOHGILBIIWCUIBHHGPBKBHB...