OGG Encrypt password does not work for special character question mark (Doc ID 2113012.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.27 and later
Information in this document applies to any platform.

Symptoms

when password contains question mark, the generated hash from 'encryption password' does not work when trying to connect to database through dblogin under ggsci.
e.g.,

server>:/app/oracle/gg/db/orcl
[ORCL]#
server:/app/oracle/gg/db/orcl
[CDBS1DEA1]# cat ENCKEYS
securekey1 0x7437621B86A458725A43870743E9C960
securekey2 0x25DCDB20F54D592BD7AB585ECA85093F
securekey3 0xD680552663F7596455142A355122491D
securekey4 0x8725CF2BD2A05A1DD37CFB0BD7BE887B

encrypt password "S?OWNER_GGS" ENCRYPTKEY securekey1
Encrypted password:
AADAAAAAAAAAAALANCFHWHZAMGGIBFPFAAPBXBEGAHMCOIYGVDVAHGOHBICFBITGXGYIAIYELHJCSCVI
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.

 

Cause

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