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

这篇关于Oracle GoldenGate 12c 新特性 Credential Store and USERIDALIAS的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---