大佬教程收集整理的这篇文章主要介绍了Oracle GoldenGate 安装配置全记录，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。
解压压缩包
.bash_profile中添加如下内容
export LD_liBRARY_PATH=$ORACLE_HOME/lib
GGSCI (rac01) 3> create subdirs
Creating subdirectorIEs under current directory /home/oracle/ogg
Parameter files /home/oracle/ogg/dirprm: already exists
Report files /home/oracle/ogg/dirrpt: created
Checkpoint files /home/oracle/ogg/dirchk: created
Process status files /home/oracle/ogg/dirpcs: created
sql script files /home/oracle/ogg/dirsql: created
Database deFinitions files /home/oracle/ogg/dirdef: created
Extract data files /home/oracle/ogg/dirdat: created
Temporary files /home/oracle/ogg/dirtmp: created
Stdout files /home/oracle/ogg/dirout: created
sql> create tablespace ggs_tbs datafile size 50m;
tablespace created.
sql> create user ggs IDentifIEd by ggs default tablespace ggs;
User created.
sql> grant dba to ggs;
Grant succeeded.
sql> alter database force logging;
Database altered.
sql> alter database add supplemental log data;
Database altered.
GGSCI (rac01) 1> edit params ./globals
输入：ggschema ggs
sql> @sequence
Please enter the name of a schema for the GoldenGate database objects:
ggs
sql> alter system set recyclebin=off deferred scope=both;
System altered.
sql> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ggs
sql> @ddl_setup.sql
Oracle GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source,the system recycle bin must be Disabled. For Oracle 11g and later,it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ggs
sql> @role_setup.sql
GGS Role setup script
This script will drop and recreate the role GGS_GGSUSER_RolE
To use a different role name,quit this script and then edit the params.sql script to change the gg_role parameter to the preferred name. (Do not run the script.)
You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter GoldenGate schema name:ggs
GRANT GGS_GGSUSER_RolE TO <loggedUser>
sql> @?/rdbms/admin/dbmspool.sql
Package created.
Grant succeeded.
sql> @ddl_pin ggs;
GGSCI (rac01) 3> edit params mgr （空文件直接保存退出即可，除非默认端口7809被占用）
GGSCI (rac01) 4> start mgr
Manager started.
GGSCI (rac01) 8> DBLOGIN USERID ggs
Password:
Successfully logged into database.
GGSCI (rac01) 9> add trandata hr.test (表名test可以为*通配符)
2016-10-25 08:04:43 WARNING OGG-00869 No unique key is defined for table 'TEST'. All viable columns will be used to represent the key,but may not guarantee uniqueness. KEYColS may be used to define the key.
Logging of supplemental redo data enabled for table HR.TEST.
GGSCI (rac01) 10> add extract ext01,tranlog,begin Now,threads 2
EXTRACT added.
GGSCI (rac01) 12> add exttrail ./dirdat/ex,extract ext01
EXTTRAIL added.
GGSCI (rac01) 13> edit params ext01
EXTRACT ext01
USERID ggs,PASSWORD ggs
TRANlogoPTIONS ASMUSER sys@asm,ASMPASSWORD oracle
disCARDfile ./dirdat/ex.dsc,purge
EXTTRAIL ./dirdat/ex
ddlinclude all
table hr.*;
GGSCI (rac01) 17> add extract pump01,exttrailsource ./dirdat/ex
EXTRACT added.
GGSCI (rac01) 18> add rmttrail /home/oracle/ogg/dirdat/ex,EXTRACT pump01
RMTTRAIL added.
GGSCI (rac01) 19> edit params pump01
EXTRACT pump01
USERID ggs,PASSWORD ggs
PAsstHRU
RMTHOST 192.168.56.203,MGRPORT 7809,TCPBUFSIZE 100000,TCPFLUSHBYTES 300000
RMTTRAIL /home/oracle/ogg/dirdat/ex
table hr.*;
GGSCI (hadoop03) 1> dblogin userID ggs,password ggs
Successfully logged into database.
GGSCI (hadoop03) 2> add checkpointtable ggs.checkpoint
Successfully created checkpoint table ggs.checkpoint.
GGSCI (hadoop03) 3> edit params ./GLOBALS
CHECKPOINTtable ggs.checkpoint
GGSCI (hadoop03) 1> add replicat rep01,exttrail /home/oracle/ogg/dirdat/ex,checkpointtable ggs.checkpoint
REPliCAT added.
GGSCI (hadoop03) 14> edit params rep01
REPliCAT repnd
USERID ggs,PASSWORD ggs
BATCHsql
PURGEolDEXTRACTS
HANDLEColliSIONS
ASSUMetaRGETDEFS
INSERTAPPEND
disCARDfile ./dirdat/r1.dsc,purge
ddl include all
map hr.*,target hr.*;
GGSCI (rac01) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT StopPED EXT01 00:00:00 00:20:23
EXTRACT StopPED TRANS01 00:00:00 00:11:37
GGSCI (rac01) 2> start EXT01
Sending START request to MANAGER ...
EXTRACT EXT01 starting
GGSCI (rac01) 3> start TRANS01
Sending START request to MANAGER ...
EXTRACT TRANS01 starting
GGSCI (rac01) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT01 00:00:00 00:20:31
EXTRACT RUNNING TRANS01 00:00:00 00:11:45
GGSCI (hadoop03) 13> start repnd
Sending START request to MANAGER ...
REPliCAT REPND starting
以上是大佬教程为你收集整理的Oracle GoldenGate 安装配置全记录全部内容，希望文章能够帮你解决Oracle GoldenGate 安装配置全记录所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。