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 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.
info all
ggserr的日志
第三阶段：源和目标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......余下全文>>