DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, March 19, 2018

ADD CREDENTIALSTORE on Goldengate 12c

ADD CREDENTIALSTORE goldengate 12c


The ADD CREDENTIALSTORE is a new command in Oracle GoldenGate 12c and the default location of the credential store is “$GG_HOME/dircrd” directory of the GoldenGate software home.

Let’s add a user to credential store

GGSCI (ggsource.doyensys.com) 3> DBLOGIN USERID gguser, PASSWORD xxxxx
Successfully logged into database.

GGSCI (ggsource.doyensys.com ) 4> ADD CREDENTIALSTORE

Credential store created in ./dircrd/.

GGSCI (ggsource.doyensys.com ) 5> ALTER CREDENTIALSTORE ADD USER gguser ALIAS gguser
Password:

Credential store in ./dircrd/ altered.

Now check the login with newly created alias name……..

GGSCI (ggsource.doyensys.com ) 6> dblogin useridalias gguser
Successfully logged into database.

$ cd /u01/app/gghome/dircrd
$ ls -lrth
total 4.0K
-rw-r----- 1 oracle dba 517 Feb 22 22:55 cwallet.sso

From above we can see that Auto Login wallet has been created

To verify:

GGSCI (ggsource.doyensys.com) 1>  INFO CREDENTIALSTORE

Reading from ./dircrd/:

Default domain: OracleGoldenGate

  Alias: gguser
  Userid: gguser


GGSCI (ggsource.doyensys.com ) 1> edit params mgr
PORT 7809
USERIDALIAS gguser
PURGEOLDEXTRACTS /u01/app/gghome/dirdat, USECHECKPOINTS



UPDATE Password:

If we want to change the passwords on regular basis due to security then our Extract/pump/replicat will go ABENDED so when ever we change the password for gguser then we also need to update the credentialstore password.

if password modified then perform below steps to update:

GGSCI (ggsource.doyensys.com) 1> dblogin useridalias gguser
ERROR: Unable to connect to database using user gguser. Please check privileges.
Unable to initialize database connection because of error ORA-01017: invalid username/password; logon denied.

GGSCI (ggsource.doyensys.com) 2> alter credentialstore replace user gguser alias gguser
Password:

Credential store in ./dircrd/ altered.

GGSCI (ggsource.doyensys.com) 3> info credentialstore

Reading from ./dircrd/:

Default domain: OracleGoldenGate

  Alias: gguser
  Userid: gguser

GGSCI (ggsource.doyensys.com) 4> dblogin useridalias gguser
Successfully logged into database.

No comments: