参考链接文档
https://www.modb.pro/db/416108
mkdir -p /opt/app/ogg/ogg21_ma
mkdir -p /opt/app/ogg/ogg21_sm
mkdir -p /opt/app/ogg/ogg21_deploy
chown -R oracle:oinstall /opt/app/ogg
chmod 775 -R /opt/app/ogg
---- 图像安装
cd /opt/soft/ogg21c&& unzip 213000_fbo_ggs_Linux_x64_Oracle_services_shiphome.zip
cd /opt/soft/ogg21c/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/ && ./runInstaller
----直接静默安装
cat <
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v21_1_0
INSTALL_OPTION=ORA21c
SOFTWARE_LOCATION=/opt/app/ogg/ogg21_ma
START_MANAGER=false
MANAGER_PORT=Not applicable for a Services installation.
DATABASE_LOCATION=Not applicable for a Services installation.
INVENTORY_LOCATION=/u01/app/oraInventory
UNIX_GROUP_NAME=oinstall
EOF
ps -ef|grep ogg |awk ‘{print $2}’ |xargs kill -9
rm -rf /opt/ogg
sed -i “/LOC=/d” /u01/oraInventory/ContentsXML/inventory.xml
su - oracle -c “cd /opt/soft/ogg21c/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1&&./runInstaller -silent -showProgress -responseFile /opt/soft/ogg21c/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/response/oggcore.rsp”
[FATAL] [INS-75012] OGG常见报错
vim /u01/oraInventory/ContentsXML/inventory.xml
删除下面这一行
find /u01/ -iname “orainstRoot.sh”
/u01/oraInventory/orainstRoot.sh
----图形化配置微服务端口
export OGG_HOME=/opt/app/ogg/ogg21_ma
export PATH=$PATH:$OGG_HOME/bin
oggca.sh
-----安装报错
[INS-85054] If the Oracle GoldenGate inventory exists, a new Service Manager cannot be created and registered as a service/daemon.
解决办法
Delete the following files at the OS level:
Linux 7
rm -rf /etc/systemd/system/OracleGoldenGate.service
rm -rf /etc/oggInst.loc
Linux 6
rm -rf /etc/init.d/OracleGoldenGate
rm -rf /etc/rc.d/OracleGoldenGate
rm -rf /etc/rc.d/*OracleGoldenGate
rm -rf /etc/oggInst.loc
验证微服务
netstat -anlp |grep 7809
安装完执行脚本
/opt/app/ogg/ogg21_sm/bin/registerServiceManager.sh
—配置环境变量
cat <
export OGG_HOME=/opt/app/ogg/ogg21_ma
export PATH=$PATH:$OGG_HOME/bin
EOF
–登录
source ~/.bash_profile
adminclient
connect http://192.168.101.159:7809 deployment deploy as oggadmin password oracle
–创建身份证明
add credentialstore
alter credentialstore add user ogg@192.168.101.159:1521/p19c,password ogg alias target_p19c
alter credentialstore add user ogg@192.168.101.169:1521/p19c,password ogg alias source_p19c
–验证登录数据库
dblogin useridalias source_p19c
dblogin useridalias target_p19c
A主机 到 主机 B 的同步
edit params ext5
EXTRACT ext5
USERIDALIAS target_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TRANLOGOPTIONS EXCLUDETAG 99
EXTTRAIL ./dirdat/ea
TABLE IT_MES.*;
ADD EXTRACT ext5 INTEGRATED TRANLOG BEGIN NOW
ADD EXTTRAIL ./dirdat/ea EXTRACT ext5
dblogin useridalias target_p19c
unregister extract ext5 database
REGISTER EXTRACT ext5 DATABASE
ADD REPLICAT repb INTEGRATED EXTTRAIL ./dirdat/ea
delete REPLICAT repb
edit params repb
REPLICAT repb
USERIDALIAS source_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DBOPTIONS SETTAG 99
MAP IT_MES., TARGET IT_MES.;
B主机 到 主机 A 的同步
edit params ext6
EXTRACT ext6
USERIDALIAS source_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
TRANLOGOPTIONS EXCLUDETAG 99
EXTTRAIL ./dirdat/eb
TABLE IT_MES.*;
ADD EXTRACT ext6 INTEGRATED TRANLOG BEGIN NOW
ADD EXTTRAIL ./dirdat/eb EXTRACT ext6
dblogin useridalias source_p19c
unregister extract ext6 database
REGISTER EXTRACT ext6 DATABASE
ADD REPLICAT repa INTEGRATED EXTTRAIL ./dirdat/eb
delete REPLICAT repa
edit params repa
REPLICAT repa
USERIDALIAS target_p19c
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DBOPTIONS SETTAG 99
MAP IT_MES., TARGET IT_MES.;
----TABLEEXCLUDE IT_MES.TEST4; #过滤不同步的表,重启进程
ogg日志
tail -f /opt/app/ogg/ogg21_deploy/var/log/ggserr.log
故障处理OGG-01044 The trail XXX is not assigned to extract
因为参数文件里写的是/ogg/dirdat/lt，而我添加的是./dirdat/lt，尽管都是同一个路径，但是OGG不认！！ 所以，解决办法也很简单，就是把参数文件中的/ogg/dirdat/lt修改为./dirdat/lt，然后重启进程即可。
