生成goldengate使用者的密碼暗文

shytodear發表於2014-03-05
Go密碼
==========生成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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章