Oracle GoldenGate(ogg)安裝經驗大彙總，采坑總結，絕對幹貨！

一下是安裝ogg過程中遇到的問題和解決辦法，絕對良心幹貨，抽空會寫更詳細的安裝教程。更多精彩内容請點選

• OGG-00685 begin time prior to oldest log in log history

  https://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#GWUAD153

  https://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:\app\qingmiaokeji\admin\orcl\adump\expdp_zzbs.par PARALLEL=8 flashback_scn=1438905

  登入使用者必須是dba

  F:\app\qingmiaokeji\admin\orcl\dpdump

  導出

  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/79879275

  https://blog.csdn.net/teisite/article/details/81196244

• centos7 安裝oracle

  https://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 specified

  https://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=0

  https://www.2cto.com/database/201503/380443.html

  https://blog.csdn.net/orion61/article/details/25365741

  ALTER 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 option

  ogg 接收和發送端 ogg版本不一緻，可用formate level參數

  EXTTRAIL ./dirdat/dbty/tr,FORMAT LEVEL 5

愛技術的程式員，在職上岸非全研究所學生；技術興趣廣泛：架構、java、python、nodejs、性能優化、工具、大資料、AI等技術分享！