ADD CREDENTIALSTORE command to create a credential store. The credential store manages user IDs and their encrypted passwords (together known as credentials) that are used by Oracle GoldenGate processes to interact with the local database. The credential store eliminates the need to specify user names and clear-text passwords in the Oracle GoldenGate parameter files. An optional alias can be used in the parameter file instead of the user ID to map to a userid-password pair in the credential store.
The default location of the credential store is "$GGHOME/dircrd" directory of the GoldenGate software home.
Let's add user to CREDENTIALSTORE
[code] GGSCI (dev.oracledbashop.com) 9> dblogin userid gg01 password gg01; Successfully logged into database. GGSCI (dev.oracledbashop.com as gg01@ggsource) 10> add credentialstore Credential store created. GGSCI (dev.oracledbashop.com as gg01@ggsource) 13> alter credentialstore add user gg01 alias gg01; Password: Credential store altered. [/code]
Now check the login with newly created alias name
[code] GGSCI (dev.oracledbashop.com) 1> dblogin useridalias gg01 Successfully logged into database. GGSCI (dev.oracledbashop.com as gg01@ggsource) 2> [/code]
Go to dircrd under GoldenGate installation and see
[code] [dev:oracle:ggsource]$ pwd /u01/app/oracle/product/gghome/dircrd [dev:oracle:ggsource]$ ls -lrt total 4 -rw-r----- 1 oracle oinstall 589 May 17 21:08 cwallet.sso [/code]
To check the CREDENTIALSTORE information
[code] GGSCI (dev.oracledbashop.com as gg01@ggsource) 2> info credentialstore Reading from credential store: Default domain: OracleGoldenGate Alias: gg01 Userid: gg01 [/code]




No comments:
Post a Comment