OGG Encrypt password does not work for special character question mark
Last updated on JUNE 07, 2017
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.
[CDBS1DEA1]# cat ENCKEYS
encrypt password "S?OWNER_GGS" ENCRYPTKEY securekey1
Algorithm used: AES128
GGSCI (server) 9> dblogin userid ggs_owner, password
AADAAAAAAAAAAALANCFHWHZAMGGIBFPFAAPBXBEGAHMCOIYGVDVAHGOHBICFBITGXGYIAIYELHJCSCVI, encryptkey securekey1
ERROR: Unable to connect to database using user ggs_owner. Please check privileges.
ORA-01017: invalid username/password; logon denied.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms