一、安装GoldenGate[源端,目标端]
1、创建ogg目录
[root@source ~]# mkdir /DBSoft/ogg
[root@source ~]# cd /DBSoft/ogg/
2、解压缩ogg安装介质
[root@source ogg]# unzip /root/OGG_v11_for_ora11g_linux64.zip
Archive: /root/OGG_v11_for_ora11g_linux64.zip
inflating: ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
inflating: OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
inflating: README.txt
3、可以看到介质包含一个tar包,pdf文件以及一个readme
[root@source ogg]# ll
total 201016
-rw-rw---- 1 root root 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
-rwxrwxr-x 1 root root 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
-rwxrwxr-x 1 root root 26726 Aug 3 2010 README.txt
4、修改ogg目录所属组为oinstall及所属用户为oracle
[root@source ogg]# cd ..
[root@source DBSoft]# ll
total 32
drwxr-x--- 3 oracle oinstall 4096 Sep 2 22:40 admin
drwxr-xr-x 6 oracle oinstall 4096 Sep 2 22:44 cfgtoollogs
drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:38 checkpoints
drwxrwxr-x 11 oracle oinstall 4096 Sep 2 22:39 diag
drwxr-x--- 4 oracle oinstall 4096 Sep 2 22:41 fast_recovery_area
drwxr-xr-x 2 oracle oinstall 4096 Sep 3 10:27 ogg
drwxrwx--- 5 oracle oinstall 4096 Sep 2 22:39 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 Sep 2 22:32 product
[root@source DBSoft]# chown -R oracle:oinstall ogg/
[root@source DBSoft]# su - oracle
5、再次进入ogg目录,解压缩ogg主程序文件
[oracle@source ~]$ cd /DBSoft/ogg/
[oracle@source ogg]$ ll
total 201016
-rw-rw---- 1 oracle oinstall 205096960 Jul 29 2010 ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
-rwxrwxr-x 1 oracle oinstall 500964 Aug 6 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf
-rwxrwxr-x 1 oracle oinstall 26726 Aug 3 2010 README.txt
#正在解压缩
[oracle@source ogg]$ tar -xvf ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
bcpfmt.tpl
bcrypt.txt
chkpt_ora_create.sql
cobgen
convchk
db2cntl.tpl
ddl_access.tpl
ddl_cleartrace.sql
ddlcob
ddl_db2_os390.tpl
ddl_db2.tpl
ddl_ddl2file.sql
ddl_disable.sql
ddl_enable.sql
ddlgen
ddl_informix.tpl
ddl_mss.tpl
ddl_mysql.tpl
ddl_nopurgeRecyclebin.sql
ddl_nssql.tpl
ddl_ora10.sql
ddl_ora10upCommon.sql
ddl_ora11.sql
ddl_ora9.sql
ddl_oracle.tpl
ddl_pin.sql
ddl_purgeRecyclebin.sql
ddl_remove.sql
ddl_session1.sql
ddl_session.sql
ddl_setup.sql
ddl_sqlmx.tpl
ddl_status.sql
ddl_staymetadata_off.sql
ddl_staymetadata_on.sql
ddl_sybase.tpl
ddl_tandem.tpl
ddl_tracelevel.sql
ddl_trace_off.sql
ddl_trace_on.sql
defgen
demo_more_ora_create.sql
demo_more_ora_insert.sql
demo_ora_create.sql
demo_ora_insert.sql
demo_ora_lob_create.sql
demo_ora_misc.sql
demo_ora_pk_befores_create.sql
demo_ora_pk_befores_insert.sql
demo_ora_pk_befores_updates.sql
emsclnt
extract
freeBSD.txt
ggMessage.dat
ggsci
help.txt
keygen
libicudata.so.38
libicui18n.so.38
libicuuc.so.38
libxerces-c.so.28
libxml2.txt
logdump
marker_remove.sql
marker_setup.sql
marker_status.sql
mgr
notices.txt
params.sql
replicat
reverse
role_setup.sql
server
sqlldr.tpl
tcperrs
UserExitExamples/
UserExitExamples/ExitDemo_lobs/
UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
UserExitExamples/ExitDemo_lobs/readme.txt
UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX
UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj
UserExitExamples/ExitDemo_passthru/
UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX
UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS
UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj
UserExitExamples/ExitDemo_passthru/readme.txt
UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c
UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS
UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX
UserExitExamples/ExitDemo_more_recs/
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
UserExitExamples/ExitDemo_more_recs/readme.txt
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
UserExitExamples/ExitDemo/
UserExitExamples/ExitDemo/exitdemo.c
UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX
UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS
UserExitExamples/ExitDemo/readme.txt
UserExitExamples/ExitDemo/exitdemo.vcproj
UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS
UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX
UserExitExamples/ExitDemo/Makefile_exit_demo.AIX
UserExitExamples/ExitDemo_pk_befores/
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX
UserExitExamples/ExitDemo_pk_befores/readme.txt
UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX
UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS
usrdecs.h
zlib.txt
6、解压缩完之后,执行ggsci命令进入OGG交互界面
[oracle@source ogg]$GGSCI
GGSCI (source) 1>
7、创建OGG所需目录
GGSCI (source) 1> create subdirs
Creating subdirectories under current directory /DBSoft/ogg
Parameter files /DBSoft/ogg/dirprm: created
Report files /DBSoft/ogg/dirrpt: created
Checkpoint files /DBSoft/ogg/dirchk: created
Process status files /DBSoft/ogg/dirpcs: created
SQL script files /DBSoft/ogg/dirsql: created
Database definitions files /DBSoft/ogg/dirdef: created
Extract data files /DBSoft/ogg/dirdat: created
Temporary files /DBSoft/ogg/dirtmp: created
Veridata files /DBSoft/ogg/dirver: created
Veridata Lock files /DBSoft/ogg/dirver/lock: created
Veridata Out-Of-Sync files /DBSoft/ogg/dirver/oos: created
Veridata Out-Of-Sync XML files /DBSoft/ogg/dirver/oosxml: created
Veridata Parameter files /DBSoft/ogg/dirver/params: created
Veridata Report files /DBSoft/ogg/dirver/report: created
Veridata Status files /DBSoft/ogg/dirver/status: created
Veridata Trace files /DBSoft/ogg/dirver/trace: created
Stdout files /DBSoft/ogg/dirout: created
GGSCI (source) 2>exit
8、至此我们可以看到目录已经创建,OGG安装初始化完成
[oracle@source ogg]$ ls -ltr dir*
dirver:
total 28
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 trace
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 status
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 report
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 params
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oosxml
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oos
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 lock
1、创建ogg目录
[