- Administering Oracle GoldenGate Classic Architecture
- Encrypting a Password in a Command or Parameter File
- Encrypting the Password
D.1 Encrypting the Password
- Run GGSCI.
- Issue the
ENCRYPT PASSWORDcommand.ENCRYPT PASSWORD
passwordalgorithmENCRYPTKEY {key_name| DEFAULT}Where:
-
passwordis the clear-text login password. Do not enclose the password within quotes. If the password is case-sensitive, type it that way. -
algorithmspecifies the encryption algorithm to use:-
AES128uses the AES 128 cipher, which has a key size of 128 bits. -
AES192uses the AES 192 cipher, which has a key size of 192 bits. -
AES256uses the AES 256 cipher, which has a key size of 256 bits. -
BLOWFISHuses Blowfish encryption with a 64-bit block size and a variable-length key size from 32-bits to 128-bits. Use AES if supported for the platform. UseBLOWFISHfor backward compatibility with earlier Oracle GoldenGate versions, and for DB2 z/OS and DB2 for i. AES is not supported on those platforms.
-
-
ENCRYPTKEYkey_namespecifies the logical name of a user-created encryption key in theENCKEYSlookup file. The key name is used to look up the actual key in theENCKEYSfile. Using a user-defined key and anENCKEYSfile is required for AES encryption. To create a key andENCKEYSfile, see Populating an ENCKEYS File with Encryption Keys. -
ENCRYPTKEY DEFAULTdirects Oracle GoldenGate to generate a predefined Blowfish key. This type of key is insecure and should not be used in a production environment if the platform supports AES. Use this option only for DB2 on /OS and DB2 for i whenBLOWFISHis specified.ENCRYPT PASSWORDreturns an error if AES is used withDEFAULT.If no algorithm is specified, AES 128 is the default for all database types except DB2 z/OS, where
BLOWFISHis the default.
The following are examples of
ENCRYPT PASSWORDwith its various options.ENCRYPT PASSWORD mypassword AES256 ENCRYPTKEY mykey1 ENCRYPT PASSWORD mypassword BLOWFISH ENCRYPTKEY mykey1 ENCRYPT PASSWORD mypassword BLOWFISH ENCRYPTKEY DEFAULT
-
- The encrypted password is output to the screen when you run the
ENCRYPT PASSWORDcommand. Copy the encrypted password and then see Specifying the Encrypted Password in a Parameter File or Command for instructions on pasting it to a command or parameter.
Parent topic: Encrypting a Password in a Command or Parameter File