您好,欢迎访问一九零五行业门户网

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

其它类似信息

推荐信息