Install Visual C ++ 2005 SP1 Redistributable Package
* Download from here.
* Double click to install.
Set Env Var
* Set ORACLE_HOME and ORACLE_SID environment variables accordingly.
Install Golden Gate Software
* Unzip Golden Gate download into a local folder (e.g. C:\prog\gg104). Make sure there is no space in folder names.
* Open a DOS shell and cd to GoldenGate folder.
* Issue command ‘GGSCI’ to bring up the GoldenGate command interface.
* Issue command ‘CREATE SUBDIRS’ to create needed subdiretories.
* Issue command ‘exit’ to exit command interface.
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\WINDOWS\system32>cd C:\prog\gg104 C:\prog\gg104>ggsci Oracle GoldenGate Command Interpreter for Oracle Version 10.4.0.19 Build 002 Windows (optimized), Oracle 10 on Sep 18 2009 15:54:55 Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved. GGSCI (mycomputer) 1> CREATE SUBDIRS Creating subdirectories under current directory C:\prog\gg104 Parameter files C:\prog\gg104\dirprm: created Report files C:\prog\gg104\dirrpt: created Checkpoint files C:\prog\gg104\dirchk: created Process status files C:\prog\gg104\dirpcs: created SQL script files C:\prog\gg104\dirsql: created Database definitions files C:\prog\gg104\dirdef: created Extract data files C:\prog\gg104\dirdat: created Temporary files C:\prog\gg104\dirtmp: created Veridata files C:\prog\gg104\dirver: created Veridata Lock files C:\prog\gg104\dirver\lock: created Veridata Out-Of-Sync files C:\prog\gg104\dirver\oos: created Veridata Out-Of-Sync XML files C:\prog\gg104\dirver\oosxml: created Veridata Parameter files C:\prog\gg104\dirver\params: created Veridata Report files C:\prog\gg104\dirver\report: created Veridata Status files C:\prog\gg104\dirver\status: created Veridata Trace files C:\prog\gg104\dirver\trace: created Stdout files C:\prog\gg104\dirout: created GGSCI (mycomputer) 2> exit C:\prog\gg104>
Configure Manager Port
GGSCI 3> EDIT PARAMS MGR # Manager listening on port 7809 PORT 7809 # Additional params # DYNAMICPORTLIST {<port> | <port>-<port>} [, ...] # DYNAMICPORTREASSIGNDELAY <seconds> AUTORESTART {ER | EXTRACT | REPLICAT} {group name | wildcard} [, RETRIES <max retries>] [, WAITMINUTES <wait minutes>] [, RESETMINUTES <reset minutes>] # PURGEOLDEXTRACTS
Install Manager as Window Services
C:\prog\gg104>install ADDSERVICE Service 'GGSMGR' created. Install program terminated normally.
Delete Manager as Window Service
C:\prog\gg104>install deleteservice Service 'GGSMGR' removed. Install program terminated normally.
Start Manager
* From ggsci:
START MANAGER
* From Windows Services
Start installed service
Stop Manager
* From ggsci:
STOP MANAGER [!]
* From Windows Services
Stop installed service
Prepare Database
Enable Supplemental Log
-- Enable supplemental logging ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; -- Swith log to start supplemental logging ALTER SYSTEM SWITCH LOGFILE; -- Verify supplemental logging is enabled (with a result of 'YES') SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;