Hi Guys,
I found very cool feature in 12c Goldengate creating password wallet and avoiding password in paramfile of goldengate process. when we implement wallet we can add goldengate user and password to encrypted wallet credential store and we can use alias instead of username and password in goldengate parameter files
Example of paramfile without wallet credential alias
extract ENTNEW
SETENV (ORACLE_SID=oval007p)
SETENV (ORACLE_HOME="/u01/app/oracle/product/12.1.0/dbhome_1")
userid ggsuser, password oracle
exttrail /u01/app/trails/ba
reportcount every 10 minutes, rate
Table universe.world
In the above param file, we are using goldengate user and password, our objective is to avoid user credentials in goldengate paramfile
Implementation plan for creating wallet and adding a credential store to wallet
step1: create wallet
step2: add goldengate user to the credential store
Step3: validate using alias
Step1:
[oracle@tnc61 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter 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:21:34
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.
GGSCI (tnc61.ffdc.com) 1> create wallet
Created wallet at location 'dirwlt'.
Opened wallet at location 'dirwlt'.
Step2:
GGSCI (tnc61.ffdc.com) 2> add credentialstore
Credential store created in ./dircrd/.
GGSCI (tnc61.ffdc.com) 3> info credentialstore
Reading from ./dircrd/:
No information found in credential store.
GGSCI (tnc61.ffdc.com) 9> alter credentialstore add user ggsuser password oracle alias ggs_user
Credential store in ./dircrd/ altered.
syntax:
alter credentialstore add user <goldengateuser> password <passwordofgguser> alias <aliasname>
Step3:
GGSCI (tnc61.ffdc.com) 10> dblogin useridalias ggs_user;
Successfully logged into database.
Finally we can replace goldengate user credentials with alias. Goldengate process with alias
ggsci> view param entnew
extract ENTNEW
SETENV (ORACLE_SID=oval007p)
SETENV (ORACLE_HOME="/u01/app/oracle/product/12.1.0/dbhome_1")
useridalias ggs_user
exttrail /u01/app/trails/ba
logallsupcols
updaterecordformat compact
reportcount every 10 minutes, rate
Table universe.world
Nikhil Tatineni-- "
12c goldengate-- "
