OGG Encrypt password does not work for special character question mark
(Doc ID 2113012.1)
Last updated on JUNE 05, 2019
Applies to:Oracle GoldenGate - Version 18.104.22.168.27 and later
Information in this document applies to any platform.
when password contains question mark, the generated hash from 'encryption password' does not work when trying to connect to database through dblogin under ggsci.
[ ]# cat ENCKEYS
encrypt password "S?OWNER_GGS" ENCRYPTKEY securekey1
Algorithm used: AES128
GGSCI (server) 9> dblogin userid ggs_owner, password
AADAAAAAAAAAAALANCFHWHZAMGGIBFPFAAPBXBEGAHMCOIYGVDVAHGFBITGXGYIAIYELHJCSCVI, encryptkey securekey1
ERROR: Unable to connect to database using user ggs_owner. Please check privileges.
ORA-01017: invalid username/password; logon denied.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document