OGG unable to connect to the database when password has ASTERISK (*) or QUESTION MARK (?) (wildcard characters) (Doc ID 1542624.1)

Last updated on APRIL 16, 2013

Applies to:

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

Symptoms

 SQL> alter user test identified by "test*";

User altered.

GGSCI (OGG) 8> dblogin userid test, password "test*"
ERROR: Unable to connect to database using user test. 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