Configure Credential Wallet(Optional)
Credential wallet is a store which contains credentials. The logic behind it, is to facilitate the dblogin operations by not exposing the password:
To create and configure the wallet follow the steps:
Create & Configure wallet
[oracle@edvmr1p0 oggtrg]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.3.0.1.0 OGGCORE_12.3.0.1.0_PLATFORMS_170721.0154_FBO Linux, x64, 64bit (optimized), Oracle 12c on Jul 21 2017 23:31:13 Operating system character set identified as UTF-8. Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved. GGSCI (edvmr1p0) 1> Create Wallet Created wallet at location 'dirwlt'. Opened wallet at location 'dirwlt'. GGSCI (edvmr1p0) 2> Add CredentialStore Credential store created in /u01/ogg/oggtrg/dircrd/. GGSCI (edvmr1p0) 3> alter CredentialStore Add User c##OGG_Admin@amer Password oracle_4U Alias oggadmin_amer Credential store in /u01/ogg/oggtrg/dircrd/ altered. GGSCI (edvmr1p0) 4> alter CredentialStore Add User c##OGG_Admin@euro Password oracle_4U Alias oggadmin_euro Credential store in /u01/ogg/oggtrg/dircrd/ altered. GGSCI (edvmr1p0) 5> alter CredentialStore Add User c##OGG_Admin Password oracle_4U Alias oggadmin_root Credential store in /u01/ogg/oggtrg/dircrd/ altered. GGSCI (edvmr1p0) 6> info CredentialStore Reading from /u01/ogg/oggtrg/dircrd/: Default domain: OracleGoldenGate Alias: oggadmin_euro Userid: c##OGG_Admin@euro Alias: oggadmin_amer Userid: c##OGG_Admin@amer Alias: oggadmin_root Userid: c##OGG_Admin GGSCI (edvmr1p0) 7> DBLogin UserIDAlias oggadmin_amer Successfully logged into database AMER. GGSCI (edvmr1p0 as c##OGG_Admin@orcl/AMER) 8> DBLogin UserIDAlias oggadmin_euro Successfully logged into database EURO. GGSCI (edvmr1p0 as c##OGG_Admin@orcl/EURO) 9>