You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate
manage process is running on port 7809. Your requirements include using a custom encryption
key and advanced encryption standard (AES), and you have created an ENCKEYS file
What parameters should you use?
A.
This feature is not supported in oracle goldenGate 10.
B.
RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, ENCRYPT KEY
C.
RMTHOST usserval, MGRPORT AES, ENCRYPTKEY MYKWY, MBRPORT 7809
D.
RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY
Explanation:
Reference :
http://gavinsoorma.com/2010/07/goldengate-encrypting-data-and-passwords/
A. GoldenGate 10g does not support AES encryption.
B
AES128 uses the AES-128 cipher, which has a key size of 128 bits. AES128 is the default if no algorithm is specified.
•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 variable-length key size from 32 bits to 128 bits. Use BLOWFISH for backward compatibility with earlier Oracle GoldenGate versions and for Oracle GoldenGate installations for DB2 on z/OS, DB2 for i, and SQL/MX on NonStop. On those platforms, BLOWFISH is the only supported encryption method. Use AES where supported, because it is more secure than BLOWFISH for those platforms.
B. But the syntax is not correct.
The correct syntax is (KeyName insted of Encrypt):
RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, KeyName