EncryptingGoldengatePassword - 数据库编程

OGG参数文件中需要指定用户密码，这时候我们需要加密该密码： [oracle@ogg1 ogg]$ ls -l keygen -rwxr-x— 1 oracle oinstall 327034 Apr 23 2012 keygen [oracle@ogg1 ogg]$ ./keygen 128 4 0xD209104B9A93E35D9AD03F7E313C5F56 0x63A5DF267306004625223653811C234C 0xF440AF024C791C2EB0732C28D1FCE641 0x2E87795E96CF515DE536AF489C404B55 [oracle@ogg1 ogg]$ vi ENCKEYS securekey1 0xD209104B9A93E35D9AD03F7E313C5F56

securekey2 0x63A5DF267306004625223653811C234C

securekey3 0xF440AF024C791C2EB0732C28D1FCE641

securekey4 0x2E87795E96CF515DE536AF489C404B55

GGSCI (ogg1) 2> encrypt password zbdba encryptkey securekey3
Encrypted password: AADAAAAAAAAAAAFAUCDBDHUIKBLIJJXHHGMCUBSDEBIEWGPFAGODECCFNISBKBNBRJGEUIUHLGTCQCEI
Algorithm used: AES128 GGSCI (ogg1) 5> dblogin userid ogg, password AADAAAAAAAAAAAFAUCDBDHUIKBLIJJXHHGMCUBSDEBIEWGPFAGODECCFNISBKBNBRJGEUIUHLGTCQCEI,encryptkey securekey3;
Successfully logged into database.