Encrypt password value for GoldenGate using blowfish algorithm

 

Encrypt password value for Golden Gate using Blow fish algorithm

GGSOURCE IS THE PASSWORD FOR USER GGSOURCE (DB USER)

Login as ggsci user:

GGSCI (Linux03 as GGSOURCE@orcl/PDBORCL) 14> ENCRYPT PASSWORD 
GGSOURCE,ENCRYPTKEY DEFAULT

Using Blowfish encryption with DEFAULT key.
Encrypted password:  AACAAAAAAAAAAALAXCJHZHLEZAKGMFABMBWBEJLFHCRHABJGYI  --> This is encrypted value
Algorithm used:  BLOWFISH

[gguser@Linux03 OGGHOME]$ mkdir dirinc
[gguser@Linux03 OGGHOME]$ vi ./dirinc/ggtarget.inc


We can create a  include file to use it for our future references.

GoldenGate Trainer (to All - Entire Audience): vi ./dirinc/ggtarget.inc
USERID ggtarget, PASSWORD AACAAAAAAAAAAALAXCJHZHLEZAKGMFABMBWBEJLFHCRHABJGYI, ENCRYPTKEY DEFAULT
  
we can use new hash value for our ggsci future dblogins  like this

GGSCI (Linux03 as GGSOURCE@orcl/PDBORCL) 15> DBLOGIN USERID GGSOURCE@PDBORCL,PASSWORD AACAAAAAAAAAAALAXCZHLEZAKGMFABMBWBEJLFHCRHABJGYI ,ENCRYPTKEY DEFAULT

While PDBORCL is the DB NAME


Successfully logged into database PDBORCL