Oracle GoldenGate 12c 新特性 Credential Store and USERIDALIAS

Oracle GoldenGate 12c 新特性 Credential Store and USERIDALIAS

--生成credentialstore文件
 
[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, 2013, 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 13:26 cwallet.sso
 

 

--创建别名
 
GGSCI (db12c) 2> alter credentialstore add user c##ggadmin alias ggroot
 Password:
 

Credential store in ./dircrd/ altered.
 

 

--使用别名登录
 
GGSCI (db12c) 2> dblogin useridalias ggroot
 Successfully logged into database CDB$ROOT.
 

 

--也可以创建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

 

，