ITPub博客

首页 > 数据库 > Oracle > 生成goldengate用户的密码暗文

生成goldengate用户的密码暗文

原创 Oracle 作者:shytodear 时间:2014-03-05 21:41:54 0 删除 编辑
==========生成ogguser的密码暗文=============

[oracle@liuqi1 ogg]$ ./ggsci


Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21


Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.



GGSCI (liuqi1) 1> encrypt password ogguser
Expecting either 'ENCRYPTKEY' or an encryption algorithm
GGSCI (liuqi1) 2> exit
[oracle@liuqi1 ogg]$ ./keygen 128 4
0x90552325408D8E700C32897334CEFC2B


0xAD66902C3A6500761497F45F1E32E032


0xCA77FD33343D727B1CFC5F4C0896C339


0xE7886A3B2F15E4002461CB38F2F9A640


[oracle@liuqi1 ogg]$ vi ENCKEYS
securekey1 0x90552325408D8E700C32897334CEFC2B
securekey2 0xAD66902C3A6500761497F45F1E32E032
securekey3 0xCA77FD33343D727B1CFC5F4C0896C339
securekey4 0xE7886A3B2F15E4002461CB38F2F9A640
[oracle@liuqi1 ogg]$
[oracle@liuqi1 ogg]$
[oracle@liuqi1 ogg]$ scp -rp ENCKEYS oracle@liuqi2:/ogg
ENCKEYS                                                                                     100%  184     0.2KB/s   00:00
[oracle@liuqi1 ogg]$ ./ggsci


Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21


Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.






GGSCI (liuqi1) 1> encrypt password ogguser encryptkey securekey1
Encrypted password:  AADAAAAAAAAAAAHALBIDBHTCKDDGEBYBEGDBPEUJIJTEDETGGFUFNGRAMBPGJIAHTJXFEIJIWFDFEBVI
Algorithm used:  AES128




GGSCI (liuqi1) 2> dblogin userid ogguser, password AADAAAAAAAAAAAHALBIDBHTCKDDGEBYBEGDBPEUJIJTEDETGGFUFNGRAMBPGJIAHTJXFEIJIWFDFEBVI,encryptkey securekey1
Successfully logged into database.


GGSCI (liuqi1) 3> edit params rep_app1
REPLICAT rep_app1
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ogguser,password AADAAAAAAAAAAAHALBIDBHTCKDDGEBYBEGDBPEUJIJTEDETGGFUFNGRAMBPGJIAHTJXFEIJIWFDFEBVI,ENCRYPTKEY securekey1
ASSUMETARGETDEFS
GETTRUNCATES
report at 1:59
reportrollover at 2:00
reperror default,abend
ALLOWNOOPUPDATES
DISCARDFILE ./dirrpt/rep_app1.dsc, PURGE
MAP liuqi.test2 , TARGET liuqi.test2;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27126919/viewspace-1101854/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2013-11-05

  • 博文量
    65
  • 访问量
    164165