Tuesday 6 June 2017

Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied. Oracle GoldenGate

I used credentialstore for credential encryption in GoldenGate, when i tried to login it thrown below error message.
The error message is self explanatory, there is issue with username and password.

Simply update the password for the GoldenGate user in Database.

Issue:-
GGSCI (abc) 4> dblogin useridalias ogg_user
ERROR: Unable to connect to database using user ogg_user@test. Please check privileges.
Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied.


Solution:-

1.Connect to the Database and update the password for the GoldenGate user.

[oracle@abc ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Jun 7 13:30:36 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>
SQL>
SQL> alter user ogg_user identified by oracle;

User altered.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


2. Connect to the GoldenGate and Update the Credentialstore with updated password and try login, it worked.

[oracle@abc ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.



GGSCI (abc) 2> alter credentialstore add user ogg_user password oracle alias ogg

Credential store in ./dircrd/ altered.

GGSCI (abc) 3> dblogin useridalias ogg
Successfully logged into database.


No comments:

Post a Comment