Fixing credential store issue in Goldengate, i faced this issue recently so thought to update here on the blog, usually when we refresh our environments there is an issue with credentials of goldengate administrator, in that case you have to check credential store and make sure to update in extract or replicat process parameter files.
GGSCI (node1.example.com) 2> start *
Sending START request to MANAGER ...
EXTRACT DPUMP1 starting
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (node1.example.com) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DPUMP1 00:00:00 84:16:29
EXTRACT STOPPED EXT1 00:00:00 84:16:28
GGSCI (node1.example.com) 12> view report ext1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Aug 7 2014 10:40:21
Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.
Starting at 2020-03-28 12:53:43
***********************************************************************
***********
***
: [/u01/app/oracle/product/12.1.2/ggate/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6ab4df]]
: [/u01/app/oracle/product/12.1.2/ggate/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)
+0x104) [0x6ab9e4]]
: [/u01/app/oracle/product/12.1.2/ggate/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6abdab]]
: [/u01/app/oracle/product/12.1.2/ggate/extract(main+0x3f) [0x5bfa2f]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3ed681d994]]
: [/u01/app/oracle/product/12.1.2/ggate/extract [0x534319]]
2020-03-28 12:53:45 ERROR OGG-00664 OCI Error beginning session (status = 1017-ORA-01017: invalid username/password; logon denied).
2020-03-28 12:53:45 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (node1.example.com) 13> info credentialstore
Reading from ./dircrd/:
Default domain: OracleGoldenGate
Alias: ggadmin
Userid: ggadmin
Alias: ggus
Userid: ggus
GGSCI (node1.example.com) 14> delete credentialstore
Credential store deleted from ./dircrd/.
GGSCI (node1.example.com) 15> info credentialstore
ERROR: Unable to open credential store in ./dircrd/.
# Here you need to know the password of ggadmin user (administrater user of goldengate) if you dont know you can reset as well and update the credential store.
GGSCI (node1.example.com) 16> alter credentialstore add useridalias ogg user ggadmin, password g
ERROR: Invalid argument 'useridalias'.
GGSCI (node1.example.com) 17> alter credentialstore add user ggadmin alias ogg
Password:
ERROR: Unable to open credential store in ./dircrd/.
GGSCI (node1.example.com) 18> ALTER CREDENTIALSTORE ADD USER ggadmin alias ogg password g
ERROR: Invalid argument 'password'.
GGSCI (node1.example.com) 19> ALTER CREDENTIALSTORE ADD USER ggadmin alias ogg
Password:
ERROR: Unable to open credential store in ./dircrd/.
GGSCI (node1.example.com) 20> add credentialstore
Credential store created in ./dircrd/.
GGSCI (node1.example.com) 21> ALTER CREDENTIALSTORE ADD USER ggadmin alias ogg
Password:
Credential store in ./dircrd/ altered.
GGSCI (node1.example.com) 22> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DPUMP1 00:00:00 84:25:11
EXTRACT STOPPED EXT1 00:00:00 84:25:10
## Update the parameter file with this alias
GGSCI (node1.example.com) 30> view params ext1
EXTRACT ext1
USERIDALIAS ogg
EXTTRAIL /u01/app/oracle/product/12.1.2/ggate/dirdat/lt
TABLE SCOTT.TAB1;
TABLE SCOTT.TAB2;
GGSCI (node1.example.com) 26> start *
Sending START request to MANAGER ...
EXTRACT DPUMP1 starting
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (node1.example.com) 27> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPUMP1 00:00:00 84:25:43
EXTRACT RUNNING EXT1 84:26:08 00:00:01
GGSCI (node1.example.com) 28> info ext1
EXTRACT EXT1 Last Started 2020-03-28 13:02 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Process ID 5950
Log Read Checkpoint Oracle Redo Logs
2020-03-28 13:10:24 Seqno 17, RBA 5702656
SCN 0.1896693 (1896693)
