Oracle GoldenGate(ogg)安装经验大汇总,采坑总结,绝对干货!

发布时间:2022-06-29 发布网站:脚本宝典
脚本宝典收集整理的这篇文章主要介绍了Oracle GoldenGate(ogg)安装经验大汇总,采坑总结,绝对干货!脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。

Oracle GoldenGate(ogg)安装经验大汇总,采坑总结,绝对干货!

 

一下是安装ogg过程中遇到的问题和解决办法,绝对良心干货,抽空会写更详细的安装教程。更多精彩内容请点击

  • OGG-00685 begin time prior to oldest log in log historyhttps://blog.csdn.net/kiwi_kid/article/details/36184241

  • goldengate 故障及解决方法汇总https://blog.csdn.net/amethystqi/article/details/6597861

  • oracle 手册https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_gettingstarted.htm#GWUAD153https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/toc.htm

  • (EXT.prm) line 13: Parsing error, [convertucs2clobs] is obsolete.

  • expdp/impdp中parfile参数使用http://blog.itpub.net/26839123/viewspace-734463/

  • window 注意 导入导出导入expdp parfile=D:appqingmiaokejiadminorcladumpexpdp_zzbs.par PARALLEL=8 flashback_scn=1438905登录用户必须是dbaF:appqingmiaokejiadminorcldpdump导出impdp qingmiaokeji/qingmiaokeji REMAP_SCHEMA=qingmiaokeji:qingmiaokeji REMAP_TABLESPACE=qingmiaokeji:qingmiaokeji_data dumpfile= expdp_zzbs_%U.dmp

  • virtual box centos7 配置 上网https://blog.csdn.net/rcjjian/article/details/79879275https://blog.csdn.net/teisite/article/details/81196244

  • centos7 安装oraclehttps://www.cnblogs.com/liuguosong/p/6057498.html

  • 修改字符集https://www.cnblogs.com/gaoyuechen/p/9447404.html

  • 错误整理: ORA-12705: Cannot access NLS data files or invalid environment specifiedhttps://blog.csdn.net/wolfchou/article/details/8696048

  • 在Windows系统设置goldengate服务随系统启动https://blog.csdn.net/qq_42924709/article/details/85113791?tdsourcetag=s_pctim_aiomsg

  • GoldenGate 配置extract,replicat进程自启动https://www.cnblogs.com/xqzt/p/4531045.html?tdsourcetag=s_pctim_aiomsg

  • 删除10天前的trail文件

  • Windows平台使用RMAN命令自动删除Oracle过期归档日志的方法https://blog.csdn.net/xiaolongzaixian/article/details/47921247

  • Windows计划任务设置,定时执行指定脚本https://jingyan.baidu.com/article/e2284b2b72bffce2e6118d2c.html

  • ogg trail文件版本问题,重置https://community.oracle.com/message/14447940?tstart=0https://www.2cto.com/database/201503/380443.htmlhttps://blog.csdn.net/orion61/article/details/25365741ALTER EXTRACT EPMP ETROLLOVER

ALTER REPLICAT finance, EXTSEQNO 53

  • ORA-12560: TNS: 协议适配器错误https://www.jianshu.com/p/1c3dbe96af03

  • OGG-01194 Oracle GoldenGate Capture for Oracle, ext_sc0.prm: EXTRACT task REP_SC0 abended : File InitialLoad, with compatibility level 6, is not compatible with the current software version's compatibility level of 5. Modify the file writer's parameter file to generate the appropriate format using the FORMAT LEVEL 5 optionogg 接收和发送端 ogg版本不一致,可用formate level参数EXTTRAIL ./dirdat/dbty/tr,FORMAT LEVEL 5

一下是安装ogg过程中遇到的问题和解决办法,绝对良心干货,抽空会写更详细的安装教程。更多精彩内容请点击

  • OGG-00685 begin time prior to oldest log in log historyhttps://blog.csdn.net/kiwi_kid/article/details/36184241

  • goldengate 故障及解决方法汇总https://blog.csdn.net/amethystqi/article/details/6597861

  • oracle 手册https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_gettingstarted.htm#GWUAD153https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/toc.htm

  • (EXT.prm) line 13: Parsing error, [convertucs2clobs] is obsolete.

  • expdp/impdp中parfile参数使用http://blog.itpub.net/26839123/viewspace-734463/

  • window 注意 导入导出导入expdp parfile=D:appqingmiaokejiadminorcladumpexpdp_zzbs.par PARALLEL=8 flashback_scn=1438905登录用户必须是dbaF:appqingmiaokejiadminorcldpdump导出impdp qingmiaokeji/qingmiaokeji REMAP_SCHEMA=qingmiaokeji:qingmiaokeji REMAP_TABLESPACE=qingmiaokeji:qingmiaokeji_data dumpfile= expdp_zzbs_%U.dmp

  • virtual box centos7 配置 上网https://blog.csdn.net/rcjjian/article/details/79879275https://blog.csdn.net/teisite/article/details/81196244

  • centos7 安装oraclehttps://www.cnblogs.com/liuguosong/p/6057498.html

  • 修改字符集https://www.cnblogs.com/gaoyuechen/p/9447404.html

  • 错误整理: ORA-12705: Cannot access NLS data files or invalid environment specifiedhttps://blog.csdn.net/wolfchou/article/details/8696048

  • 在Windows系统设置goldengate服务随系统启动https://blog.csdn.net/qq_42924709/article/details/85113791?tdsourcetag=s_pctim_aiomsg

  • GoldenGate 配置extract,replicat进程自启动https://www.cnblogs.com/xqzt/p/4531045.html?tdsourcetag=s_pctim_aiomsg

  • 删除10天前的trail文件

  • Windows平台使用RMAN命令自动删除Oracle过期归档日志的方法https://blog.csdn.net/xiaolongzaixian/article/details/47921247

  • Windows计划任务设置,定时执行指定脚本https://jingyan.baidu.com/article/e2284b2b72bffce2e6118d2c.html

  • ogg trail文件版本问题,重置https://community.oracle.com/message/14447940?tstart=0https://www.2cto.com/database/201503/380443.htmlhttps://blog.csdn.net/orion61/article/details/25365741ALTER EXTRACT EPMP ETROLLOVER

ALTER REPLICAT finance, EXTSEQNO 53

  • ORA-12560: TNS: 协议适配器错误https://www.jianshu.com/p/1c3dbe96af03

  • OGG-01194 Oracle GoldenGate Capture for Oracle, ext_sc0.prm: EXTRACT task REP_SC0 abended : File InitialLoad, with compatibility level 6, is not compatible with the current software version's compatibility level of 5. Modify the file writer's parameter file to generate the appropriate format using the FORMAT LEVEL 5 optionogg 接收和发送端 ogg版本不一致,可用formate level参数EXTTRAIL ./dirdat/dbty/tr,FORMAT LEVEL 5

脚本宝典总结

以上是脚本宝典为你收集整理的Oracle GoldenGate(ogg)安装经验大汇总,采坑总结,绝对干货!全部内容,希望文章能够帮你解决Oracle GoldenGate(ogg)安装经验大汇总,采坑总结,绝对干货!所遇到的问题。

如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。
标签: