程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> OracleGoldenGate12c新特性CredentialStoreandUSERIDALIAS

OracleGoldenGate12c新特性CredentialStoreandUSERIDALIAS

編輯:Oracle教程

--生成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

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved