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
,
