ogg 登录mysql报字符集_ogg登陆数据库用户密码加密

使用过gg的人应该都知道，在配置抽取和复制进程参数文件的时候都需要配置ogg用户以登陆数据库，这里就涉及到一个数据库安全的问题，不过还好，ogg提供了一些加密方法，如下摘录自gg的administrator guide中关于加密数据库用户密码的一段说明：

To encrypt the password

1. Run GGSCI.

2. Issue the ENCRYPT PASSWORD command.

ENCRYPT PASSWORD ENCRYPTKEY {| DEFAULT}

Where:

❍ is the clear-text login password. Do not enclose the password within

quotes. If the password is case-sensitive, type it that way.

❍ specifies the encryption algorithm to use:

◗ AES128 uses the AES-128 cipher, which has a key size of 128 bits.

◗ AES192 uses the AES-192 cipher, which has a key size of 192 bits.

◗ AES256 uses the AES-256 cipher, which has a key size of 256 bits.

◗ BLOWFISH uses Blowfish encryption with a 64-bit block size and a variablelength

key size from 32 bits to 128 bits. Use BLOWFISH only for backward

compatibility with earlier Oracle GoldenGate versions.

❍ ENCRYPTKEY specifies the logical name of a user-created encryption key in

the ENCKEYS lookup file. The key name is used to look up the actual key in the

ENCKEYS file. Using a user-defined key and an ENCKEYS file is required for AES

encryption. To create a key and ENCKEYS file, see “Generating encryption keys” on

page 134.

❍ ENCRYPTKEY DEFAULT directs Oracle Gol