Create CREDENTIALSTORE for oracle Goldengate -12c
Description:-
ADD CREDENTIALSTORE command it’s used to create a credential store for oracle goldengate. The credential store manages user IDs and their encrypted passwords that are used by Oracle GoldenGate processes to communicate with the local database. The credential store avoid’s to specify the user names and clear-text passwords in the Oracle GoldenGate parameter files.
The ADD CREDENTIALSTORE is a new command in Oracle GoldenGate 12c and the default location of the credential store is “$GGHOME/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 the credentialstore information:
GGSCI (ggsource.doyensys.com) 1> INFO CREDENTIALSTORE
Reading from ./dircrd/:
Default domain: OracleGoldenGate
Alias: gguser
Userid: gguser
Catch Me On:- Hariprasath Rajaram
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
