Encrypting Goldengate Password，goldengate

Encrypting Goldengate Password，goldengate
OGG參數檔案中需要指定使用者密碼，這時候我們需要加密該密碼：[oracle@ogg1 ogg]$ ls -l keygen-rwxr-x— 1 oracle oinstall 327034 Apr 23  2012 keygen[oracle@ogg1 ogg]$ ./keygen 128 40xD209104B9A93E35D9AD03F7E313C5F56 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.

Goldengate進程不可以啟動,日誌到userid goldengate ,password goldengate就沒了,是什情況?

info all

ggserr的日誌
 
怎在11gR2 RAC上配置GoldenGate (上）

第三階段：源和目標RAC資料庫準備步驟 1） Create OGG user 'ggs' on both the source and target database, connect to database using SQL*Plus as SYSDBA: SQL> CREATE USER ggs IDENTIFIED BY ggs; SQL> GRANT CONNECT,RESOURCE,DBA TO ggs; 2）(optional, add Oracle sequence replication support) On both source and target database, go to OGG directory and run this SQL, enter OGG user 'ggs' as prompted: SQL> @sequence.sql 3） Enable supplemental logging on source ODA database: SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS; SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS; SQL> ALTER SYSTEM SWITCH LOGFILE; (Optional) Add Oracle DDL replication support 4） On the source system, go to OGG directory, connect to database using SQL*Plus as SYSDBA. SQL> GRANT EXECUTE ON utl_file TO ggs; 5 On the source system, run the following script, provide OGG user 'ggs' as prompted. SQL> @marker_setup.sql SQL> @ddl_setup.sql NOTE: enter 'INITIALSETUP' when prompted for the mode of installation. SQL> @role_setup.sql SQL> @ddl_enable.sql SQL> @ddl_pin ggs NOTE: 'ggs' here is the OGG user. 第四階段：配置源端的extract group 1） Issue the following command to log on to the database. GGSCI > DBLOGIN USERID ggs, PASSWORD ggs 2） Create a primary Extract group 'myext': GGSCI > ADD EXTRACT myext, TRANLOG, B......餘下全文>>