New Features of Oracle GoldenGate 12c Credential Store and USERIDALIAS

-- Generate the credentialstore File

[Oracle @ db12c ggs] $ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54
Operating system character set identified as UTF-8.


Copyright (C) 1995,201 3, Oracle and/or its affiliates. All rights reserved.



GGSCI (db12c) 1> add credentialstore


Credential store created in./dircrd /.


GGSCI (db12c) 2> exit
[Oracle @ db12c ggs] $ cd dircrd/
[Oracle @ db12c dircrd] $ ls-l
Total 4

-Rw-r ----- 1 oracle oinstall 324 Apr 8 cwallet. sso

-- Create an alias

GGSCI (db12c) 2> alter credentialstore add user c # ggadmin alias ggroot
Password:


Credential store in./dircrd/altered.

-- Use an alias to log on

GGSCI (db12c) 2> dblogin useridalias ggroot
Successfully logged into database CDB $ ROOT.

-- You can also create a storage alias for PDBs zhongwc1.

GGSCI (db12c) 3> alter credentialstore add user c # ggadmin @ zhongwc1 alias ggzhongwc1
Password:


Credential store in./dircrd/altered.


GGSCI (db12c) 4> dblogin useridalias ggzhongwc1
Successfully logged into database ZHONGWC1.


GGSCI (db12c) 5> info credentialstore


Reading from./dircrd /:


Domain: OracleGoldenGate


Alias: ggroot
Userid: c # ggadmin


Alias: ggzhongwc1
Userid: c # ggadmin @ zhongwc1