Oracle GoldenGate 安装总结（实验）

最新推荐文章于 2024-10-16 14:50:14 发布

leishifei

最新推荐文章于 2024-10-16 14:50:14 发布

阅读量801

点赞数

分类专栏： Oracle GoldenGate 文章标签： oracle 2010 aix 64bit db2 session

本文链接：https://blog.csdn.net/leishifei/article/details/6371809

版权

Oracle GoldenGate 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

1. 到GoldenGate网站https://edelivery.oracle.com/下载软件

Oracle GoldenGate V11.1.1.0.0 for Oracle 11g 64bit for AIX5.36.1.zip

2. 上传下载的软件到相应目录

# cd /u01/app/oracle

# ls

Oracle_GoldenGate_V11.1.1.0.0_for_Oracle_11g_64bit_for_AIX_5.36.1.zip --名称我改过了，空格都用_替换了

admin

cfgtoollogs

checkpoints

diag

flash_recovery_area

oraInventory

oradata

product

3. 创建GoldenGate的安装目录

# mkdir goldengate --我的安装目录/u01/app/oracle/goldengate

4. 解压GoldenGate软件到安装目录

# cd goldengate

# unzip ../Oracle_GoldenGate_V11.1.1.0.0_for_Oracle_11g_64bit_for_AIX_5.36.1.zip

Archive: ../Oracle_GoldenGate_V11.1.1.0.0_for_Oracle_11g_64bit_for_AIX_5.36.1.zip

inflating: ggs_AIX_ppc_ora11g_64bit_v11_1_1_0_0_078.tar

inflating: OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf

inflating: README.txt

解压完成后查看目录内容：

# ls -l

total 215720

-rwxr-xr-x 1 root system 500964 Aug 05 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf

-rwxrwxr-x 1 root system 26726 Aug 02 2010 README.txt

-rw-r--r-- 1 root system 109905920 Jul 28 2010 ggs_AIX_ppc_ora11g_64bit_v11_1_1_0_0_078.tar

5. 解压tar文件到安装目录

# tar -xvf ggs_AIX_ppc_ora11g_64bit_v11_1_1_0_0_078.tar

x mgr, 7877343 bytes, 15386 media blocks.

x ggsci, 7634275 bytes, 14911 media blocks.

x ggMessage.dat, 448512 bytes, 876 media blocks.

x help.txt, 133635 bytes, 262 media blocks.

x tcperrs, 759 bytes, 2 media blocks.

x bcrypt.txt, 1725 bytes, 4 media blocks.

x libxml2.txt, 1668 bytes, 4 media blocks.

x zlib.txt, 1476 bytes, 3 media blocks.

x freeBSD.txt, 1968 bytes, 4 media blocks.

x notices.txt, 206097 bytes, 403 media blocks.

x libxerces-c.a, 9209080 bytes, 17987 media blocks.

x libicui18n38.a, 9302329 bytes, 18169 media blocks.

x libicuuc38.a, 6302602 bytes, 12310 media blocks.

x libicudata38.a, 11360230 bytes, 22188 media blocks.

x cobgen, 3263818 bytes, 6375 media blocks.

x ddlcob, 3297000 bytes, 6440 media blocks.

x emsclnt, 3440985 bytes, 6721 media blocks.

x keygen, 29717 bytes, 59 media blocks.

x logdump, 610865 bytes, 1194 media blocks.

x reverse, 160914 bytes, 315 media blocks.

x server, 7717813 bytes, 15074 media blocks.

x convchk, 3244107 bytes, 6337 media blocks.

x ddlgen, 3851565 bytes, 7523 media blocks.

x defgen, 3781694 bytes, 7387 media blocks.

x extract, 14308437 bytes, 27947 media blocks.

x replicat, 12927268 bytes, 25249 media blocks.

x usrdecs.h, 21197 bytes, 42 media blocks.

x bcpfmt.tpl, 426 bytes, 1 media blocks.

x db2cntl.tpl, 159 bytes, 1 media blocks.

x ddl_access.tpl, 3334 bytes, 7 media blocks.

x ddl_db2.tpl, 3017 bytes, 6 media blocks.

x ddl_db2_os390.tpl, 3502 bytes, 7 media blocks.

x ddl_informix.tpl, 2984 bytes, 6 media blocks.

x ddl_mss.tpl, 3414 bytes, 7 media blocks.

x ddl_mysql.tpl, 3481 bytes, 7 media blocks.

x ddl_nssql.tpl, 2653 bytes, 6 media blocks.

x ddl_oracle.tpl, 3458 bytes, 7 media blocks.

x ddl_sqlmx.tpl, 2652 bytes, 6 media blocks.

x ddl_sybase.tpl, 3523 bytes, 7 media blocks.

x ddl_tandem.tpl, 2653 bytes, 6 media blocks.

x sqlldr.tpl, 248 bytes, 1 media blocks.

x UserExitExamples

x UserExitExamples/ExitDemo_lobs

x UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX, 3438 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_lobs/readme.txt, 5218 bytes, 11 media blocks.

x UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX, 3434 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_lobs/exitdemo_lob.c, 33494 bytes, 66 media blocks.

x UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX, 3432 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS, 3476 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj, 13540 bytes, 27 media blocks.

x UserExitExamples/ExitDemo_pk_befores

x UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS, 1905 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX, 1950 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c, 36395 bytes, 72 media blocks.

x UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj, 13554 bytes, 27 media blocks.

x UserExitExamples/ExitDemo_pk_befores/readme.txt, 8722 bytes, 18 media blocks.

x UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX, 1956 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX, 1944 bytes, 4 media blocks.

x UserExitExamples/ExitDemo

x UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS, 1965 bytes, 4 media blocks.

x UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX, 1940 bytes, 4 media blocks.

x UserExitExamples/ExitDemo/Makefile_exit_demo.AIX, 1944 bytes, 4 media blocks.

x UserExitExamples/ExitDemo/readme.txt, 501 bytes, 1 media blocks.

x UserExitExamples/ExitDemo/exitdemo.c, 41877 bytes, 82 media blocks.

x UserExitExamples/ExitDemo/exitdemo.vcproj, 14942 bytes, 30 media blocks.

x UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX, 1946 bytes, 4 media blocks.

x UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS, 1954 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_more_recs

x UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj, 13552 bytes, 27 media blocks.

x UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX, 3465 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX, 3438 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_more_recs/readme.txt, 4192 bytes, 9 media blocks.

x UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c, 30707 bytes, 60 media blocks.

x UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX, 3425 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS, 3511 bytes, 7 media blocks.

x UserExitExamples/ExitDemo_passthru

x UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX, 1935 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS, 1974 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj, 13550 bytes, 27 media blocks.

x UserExitExamples/ExitDemo_passthru/readme.txt, 2358 bytes, 5 media blocks.

x UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX, 1944 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS, 1945 bytes, 4 media blocks.

x UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c, 20415 bytes, 40 media blocks.

x UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX, 1949 bytes, 4 media blocks.

x chkpt_ora_create.sql, 739 bytes, 2 media blocks.

x ddl_ora10.sql, 12424 bytes, 25 media blocks.

x ddl_ora10upCommon.sql, 3863 bytes, 8 media blocks.

x ddl_ora11.sql, 11064 bytes, 22 media blocks.

x ddl_ora9.sql, 12365 bytes, 25 media blocks.

x demo_more_ora_create.sql, 1217 bytes, 3 media blocks.

x demo_more_ora_insert.sql, 967 bytes, 2 media blocks.

x demo_ora_create.sql, 883 bytes, 2 media blocks.

x demo_ora_insert.sql, 821 bytes, 2 media blocks.

x demo_ora_lob_create.sql, 4015 bytes, 8 media blocks.

x demo_ora_misc.sql, 2275 bytes, 5 media blocks.

x demo_ora_pk_befores_create.sql, 1269 bytes, 3 media blocks.

x demo_ora_pk_befores_insert.sql, 1227 bytes, 3 media blocks.

x demo_ora_pk_befores_updates.sql, 2520 bytes, 5 media blocks.

x ddl_cleartrace.sql, 1059 bytes, 3 media blocks.

x ddl_ddl2file.sql, 4189 bytes, 9 media blocks.

x ddl_disable.sql, 746 bytes, 2 media blocks.

x ddl_enable.sql, 692 bytes, 2 media blocks.

x ddl_nopurgeRecyclebin.sql, 388 bytes, 1 media blocks.

x ddl_pin.sql, 1026 bytes, 3 media blocks.

x ddl_purgeRecyclebin.sql, 1227 bytes, 3 media blocks.

x ddl_remove.sql, 3686 bytes, 8 media blocks.

x ddl_session.sql, 1053 bytes, 3 media blocks.

x ddl_session1.sql, 425 bytes, 1 media blocks.

x ddl_setup.sql, 228606 bytes, 447 media blocks.

x ddl_status.sql, 8872 bytes, 18 media blocks.

x ddl_staymetadata_off.sql, 2506 bytes, 5 media blocks.

x ddl_staymetadata_on.sql, 2501 bytes, 5 media blocks.

x ddl_trace_off.sql, 2543 bytes, 5 media blocks.

x ddl_trace_on.sql, 2862 bytes, 6 media blocks.

x ddl_tracelevel.sql, 2955 bytes, 6 media blocks.

x params.sql, 4539 bytes, 9 media blocks.

x role_setup.sql, 4042 bytes, 8 media blocks.

x marker_remove.sql, 2162 bytes, 5 media blocks.

x marker_setup.sql, 3702 bytes, 8 media blocks.

x marker_status.sql, 1715 bytes, 4 media blocks.

6. 改变GoldenGate软件的所有者为oracle用户

# chown -R oracle:oinstall /u01/app/oracle/goldengate

# ls -l

total 429936

-rwxr-xr-x 1 oracle oinstall 500964 Aug 05 2010 OGG_WinUnix_Rel_Notes_11.1.1.0.0_078.pdf

-rwxrwxr-x 1 oracle oinstall 26726 Aug 02 2010 README.txt

drwxrwxrwx 7 oracle oinstall 256 Jul 28 2010 UserExitExamples

-r--r--r-- 1 oracle oinstall 426 Mar 11 2007 bcpfmt.tpl

-r--r--r-- 1 oracle oinstall 1725 Sep 10 2002 bcrypt.txt

-r--r--r-- 1 oracle oinstall 739 Mar 12 2010 chkpt_ora_create.sql

-rwxr-xr-x 1 oracle oinstall 3263818 Jul 28 2010 cobgen

-rwxr-xr-x 1 oracle oinstall 3244107 Jul 28 2010 convchk

-r--r--r-- 1 oracle oinstall 159 Mar 11 2007 db2cntl.tpl

-r--r--r-- 1 oracle oinstall 3334 Mar 11 2007 ddl_access.tpl

-r--r--r-- 1 oracle oinstall 1059 Mar 12 2010 ddl_cleartrace.sql

-r--r--r-- 1 oracle oinstall 3017 Mar 11 2007 ddl_db2.tpl

-r--r--r-- 1 oracle oinstall 3502 Mar 11 2007 ddl_db2_os390.tpl

-r--r--r-- 1 oracle oinstall 4189 Mar 12 2010 ddl_ddl2file.sql

-r--r--r-- 1 oracle oinstall 746 Mar 12 2010 ddl_disable.sql

-r--r--r-- 1 oracle oinstall 692 Mar 12 2010 ddl_enable.sql

-r--r--r-- 1 oracle oinstall 2984 Mar 11 2007 ddl_informix.tpl

-r--r--r-- 1 oracle oinstall 3414 Mar 22 2010 ddl_mss.tpl

-r--r--r-- 1 oracle oinstall 3481 Jun 01 2007 ddl_mysql.tpl

-r--r--r-- 1 oracle oinstall 388 Mar 12 2010 ddl_nopurgeRecyclebin.sql

-r--r--r-- 1 oracle oinstall 2653 Mar 17 2007 ddl_nssql.tpl

-r--r--r-- 1 oracle oinstall 12424 May 21 2010 ddl_ora10.sql

-r--r--r-- 1 oracle oinstall 3863 May 21 2010 ddl_ora10upCommon.sql

-r--r--r-- 1 oracle oinstall 11064 Mar 12 2010 ddl_ora11.sql

-r--r--r-- 1 oracle oinstall 12365 Mar 12 2010 ddl_ora9.sql

-r--r--r-- 1 oracle oinstall 3458 Mar 11 2007 ddl_oracle.tpl

-r--r--r-- 1 oracle oinstall 1026 Mar 12 2010 ddl_pin.sql

-r--r--r-- 1 oracle oinstall 1227 Mar 12 2010 ddl_purgeRecyclebin.sql

-r--r--r-- 1 oracle oinstall 3686 May 13 2010 ddl_remove.sql

-r--r--r-- 1 oracle oinstall 1053 Jun 23 2009 ddl_session.sql

-r--r--r-- 1 oracle oinstall 425 Jun 29 2009 ddl_session1.sql

-r-xr-xr-x 1 oracle oinstall 228606 Jun 29 2010 ddl_setup.sql

-r--r--r-- 1 oracle oinstall 2652 Jun 06 2007 ddl_sqlmx.tpl

-r--r--r-- 1 oracle oinstall 8872 Mar 12 2010 ddl_status.sql

-r--r--r-- 1 oracle oinstall 2506 Mar 12 2010 ddl_staymetadata_off.sql

-r--r--r-- 1 oracle oinstall 2501 Mar 12 2010 ddl_staymetadata_on.sql

-r--r--r-- 1 oracle oinstall 3523 Mar 11 2007 ddl_sybase.tpl

-r--r--r-- 1 oracle oinstall 2653 Mar 11 2007 ddl_tandem.tpl

-r--r--r-- 1 oracle oinstall 2543 Mar 12 2010 ddl_trace_off.sql

-r--r--r-- 1 oracle oinstall 2862 Mar 12 2010 ddl_trace_on.sql

-r--r--r-- 1 oracle oinstall 2955 Mar 12 2010 ddl_tracelevel.sql

-rwxr-xr-x 1 oracle oinstall 3297000 Jul 28 2010 ddlcob

-rwxr-xr-x 1 oracle oinstall 3851565 Jul 28 2010 ddlgen

-rwxr-xr-x 1 oracle oinstall 3781694 Jul 28 2010 defgen

-r--r--r-- 1 oracle oinstall 1217 Mar 12 2010 demo_more_ora_create.sql

-r--r--r-- 1 oracle oinstall 967 Mar 12 2010 demo_more_ora_insert.sql

-r--r--r-- 1 oracle oinstall 883 Mar 12 2010 demo_ora_create.sql

-r--r--r-- 1 oracle oinstall 821 Mar 12 2010 demo_ora_insert.sql

-r--r--r-- 1 oracle oinstall 4015 Mar 12 2010 demo_ora_lob_create.sql

-r--r--r-- 1 oracle oinstall 2275 Mar 12 2010 demo_ora_misc.sql

-r--r--r-- 1 oracle oinstall 1269 Mar 12 2010 demo_ora_pk_befores_create.sql

-r--r--r-- 1 oracle oinstall 1227 Mar 12 2010 demo_ora_pk_befores_insert.sql

-r--r--r-- 1 oracle oinstall 2520 Mar 12 2010 demo_ora_pk_befores_updates.sql

-rwxr-xr-x 1 oracle oinstall 3440985 Jul 28 2010 emsclnt

-rwxr-xr-x 1 oracle oinstall 14308437 Jul 28 2010 extract

-r--r--r-- 1 oracle oinstall 1968 May 13 2009 freeBSD.txt

-r--r--r-- 1 oracle oinstall 448512 Jul 07 2010 ggMessage.dat

-rw-r--r-- 1 oracle oinstall 109905920 Jul 28 2010 ggs_AIX_ppc_ora11g_64bit_v11_1_1_0_0_078.tar

-rwxr-xr-x 1 oracle oinstall 7634275 Jul 28 2010 ggsci

-r--r--r-- 1 oracle oinstall 133635 Jul 16 2010 help.txt

-rwxr-xr-x 1 oracle oinstall 29717 Jul 28 2010 keygen

-r--r--r-- 1 oracle oinstall 11360230 Mar 20 2008 libicudata38.a

-r--r--r-- 1 oracle oinstall 9302329 Mar 20 2008 libicui18n38.a

-r--r--r-- 1 oracle oinstall 6302602 Mar 20 2008 libicuuc38.a

-r-xr-xr-x 1 oracle oinstall 9209080 Mar 04 2010 libxerces-c.a

-r--r--r-- 1 oracle oinstall 1668 Mar 08 2005 libxml2.txt

-rwxr-xr-x 1 oracle oinstall 610865 Jul 28 2010 logdump

-r--r--r-- 1 oracle oinstall 2162 Mar 12 2010 marker_remove.sql

-r--r--r-- 1 oracle oinstall 3702 Mar 12 2010 marker_setup.sql

-r--r--r-- 1 oracle oinstall 1715 Mar 12 2010 marker_status.sql

-rwxr-xr-x 1 oracle oinstall 7877343 Jul 28 2010 mgr

-r--r--r-- 1 oracle oinstall 206097 Jan 15 2010 notices.txt

-r--r--r-- 1 oracle oinstall 4539 May 20 2010 params.sql

-rwxr-xr-x 1 oracle oinstall 12927268 Jul 28 2010 replicat

-rwxr-xr-x 1 oracle oinstall 160914 Jul 28 2010 reverse

-r--r--r-- 1 oracle oinstall 4042 Mar 12 2010 role_setup.sql

-rwxr-xr-x 1 oracle oinstall 7717813 Jul 28 2010 server

-r--r--r-- 1 oracle oinstall 248 Mar 11 2007 sqlldr.tpl

-r--r--r-- 1 oracle oinstall 759 Mar 11 2007 tcperrs

-r--r--r-- 1 oracle oinstall 21197 Apr 05 2010 usrdecs.h

-r--r--r-- 1 oracle oinstall 1476 Mar 08 2005 zlib.txt

7. 改变环境变量

# su - oracle

$ vi .profile

export PATH=$ORACLE_HOME/bin:$ORACLE_BASE/goldengate:usr/sbin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_BASE/goldengate:/lib:/usr/lib

8. 到GoldenGate安装目录执行ggsci命令，然后执行create subdirs命令

$ cd /u01/app/oracle/goldengate

$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.0.0 Build 078

AIX 5L, ppc, 64bit (optimized), Oracle 11 on Jul 28 2010 15:53:00

GGSCI (nodea) 1> create subdirs

Creating subdirectories under current directory /u01/app/oracle/goldengate

Parameter files /u01/app/oracle/goldengate/dirprm: created

Report files /u01/app/oracle/goldengate/dirrpt: created

Checkpoint files /u01/app/oracle/goldengate/dirchk: created

Process status files /u01/app/oracle/goldengate/dirpcs: created

SQL script files /u01/app/oracle/goldengate/dirsql: created

Database definitions files /u01/app/oracle/goldengate/dirdef: created

Extract data files /u01/app/oracle/goldengate/dirdat: created

Temporary files /u01/app/oracle/goldengate/dirtmp: created

Veridata files /u01/app/oracle/goldengate/dirver: created

Veridata Lock files /u01/app/oracle/goldengate/dirver/lock: created

Veridata Out-Of-Sync files /u01/app/oracle/goldengate/dirver/oos: created

Veridata Out-Of-Sync XML files /u01/app/oracle/goldengate/dirver/oosxml: created

Veridata Parameter files /u01/app/oracle/goldengate/dirver/params: created

Veridata Report files /u01/app/oracle/goldengate/dirver/report: created

Veridata Status files /u01/app/oracle/goldengate/dirver/status: created

Veridata Trace files /u01/app/oracle/goldengate/dirver/trace: created

Stdout files /u01/app/oracle/goldengate/dirout: created

GGSCI (nodea) 2> quit

$ ls -ltr