第1页 / 共33页
第2页 / 共33页
第3页 / 共33页
第4页 / 共33页
第5页 / 共33页
第6页 / 共33页
第7页 / 共33页
第8页 / 共33页
OGG常用问题解决手段.docx
1,ogg过来是乱码处理
2,OGG-01154
3,OGG 延时处理
4, OGG-01738
5. OGG-01027
6,OGG-00362
7,OGG-00868
8, OGG-00769
9, OGG-00664
10 , OGG-01232
11, OGG-01411
12, OGG-00542
13,OGG-01296
14, ORA-01950
15 , OGG-01742
16, ogg-28360
17, OGG-00664
18, OGG-01742
19, OGG-03510
20, OGG-01004
21, OGG-05302
22, OGG-04036
23 ,OGG-00768
23 , OGG-00665
24,不会自动删除dirdat文件
25, OGG-00418
26, OGG-05302
27,OGG-01028
1,ogg 过来是乱码处理
select * from crmdb.BUSINESS_CUSTOMER t order by t.create_date desc ;
解决方案:
在进程的参数文件中:
在 userid 的前面一行设置: 是原库的 ZHS16GBK
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
--这是不能用的 SETENV (NLS_LANG="CHINESE_CHINA.ZHS16CGB231280")
2,OGG-01154
WARNING OGG-01154 SQL error 1688 mapping SM.RPT_ORDER_ACCEPT_DETAIL to
SM.RPT_ORDER_ACCEPT_DETAIL OCI Error ORA-01688: unable to extend t
able SM.RPT_ORDER_ACCEPT_DETAIL partition PART_201706 by 1024 in tablespace
CRMDBHIS
解决方案:
先查（CRMDBHIS）表空间是否满了
如果满了就扩表空间（CRMDBHIS）。
3,OGG 延时处理
REPLICAT
RUNNING
去分析表里索引是否合理和看执行计划；
SM1
03:07:45
02:44:21
看是 否有锁表
4, OGG-01738
INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1:
p6427_extr: start=SeqNo: 35, RBA: 10132
2256, SCN: 0.2310699 (2310699), Timestamp: 2015-01-16 09:12:44.000000,
Thread: 1, end=SeqNo: 35, RBA: 101322752, SCN: 0.2310699
(2310699), Timestamp: 2015-01-16 09:12:44.000000, Thread: 1. 长事物
重新启动后，发现状态已经正常，同步已经基本无延迟。
该 bug 只在 RAC 中或者单实例设置了多个 thread 的情况下出现，而且在更高级版本
中已经修复，为了一劳永逸，可以考虑将 ogg 升级至 11.2.1.0.1
5. OGG-01027
目标端
WARNING OGG-01027 Long Running Transaction: XID 19.10.2180707, Items 0, Extract
EFWA_ZWA, Redo Thread 2, SCN 3594.3
400859098 (15439513320922), Redo Seq #163, Redo RBA 351176720.
7399014 records processed as of 2017-06-05 19:08:10 (rate 231,delta
144)
139)
7407445 records processed as of 2017-06-05 19:09:10 (rate 231,delta
7413364 records processed as of 2017-06-05 19:10:11 (rate 231,delta
97)
http://www.aichengxu.com/oracle/1505785.htm
如下的 mos 文章:
GG Extract Report Shows "Purging Transaction", WARNING OGG-00723, OGG-00715, Updating
I/O Checkpoint after Purging Orphaned Transactions, Has Secondary Transaction ID That
Is Duplicate of Existing Open Uncommitted Transaction (文档 ID 1458472.1)
Classic Extract reports false redo corruption errors when using the DBLOGREADER interface
(文档 ID 2014521.1)
Replicat abends due to a record missed by an extract (文档 ID 1990385.1)
GoldenGate Replication On RAC (文档 ID 2079091.1)
于是，就在 ogg 源头的抽取进程中添加了这个隐含参数（
加在了 TRANLOGOPTIONS DBLOGREADER 下面一行），重启了 ogg 源头的抽取进
程。
继续观察运行情况
问题
2017-06-23 12:05:09 ERROR OGG-00878 Could not execute SQL, not logged
onto database.
2017-06-23 12:05:09 ERROR OGG-01668 PROCESS ABENDING.
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=52446508289714
3&id=2173007.1&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=x2vxk9dxl_134
BUG
Description ORACLE GOLDENGATE V12.2.0.1.161018 FOR Oracle 11g
Product
Oracle GoldenGate
Oracle GoldenGate 12.2.0.1.161018
Release
p24764941_12201161018_Linux-x86-64.zip
ERROR OGG-01416 File
解决：
alter extract PUMP_T1ETROLLOVER
--指定投递进程投递的文件号，这里是 10509
alter extract PUMP_T1 ETROLLOVER
alter PUMP_T1 extseqno 10509,extrba 0
--指定抽取进程 extract_name 从 13:00 重新抽取数据
alter extract extract_name,tranlog,begin 2013-09-13 13:00
--指定 replica 进程读取的文件号，然后启动
alter REPLICAT REP_DS extseqno 0753 , extrba 0
start REP_DS;
6,OGG-00362
ERROR OGG-00362 Oracle GoldenGate Capture for Oracle,
e_auth.prm: RMTTRAIL must be specified before FILE/TABLE/SEQUENCE
解决：
7,OGG-00868
做：add extract XXXX, tranlog, begin now
ERROR OGG-00868 Oracle GoldenGate Capture for Oracle,
e_auth.prm: The number of Oracle redo threads (2) is not the same as the
number of checkpoint threads (1). EXTRACT groups on RAC systems should
be created with the THREADS parameter (e.g., ADD EXT ,
TRANLOG, THREADS 2, BEGIN...).
解决：
add extract XXXX, tranlog, begin now, threads 2
在 ogg 里出如下的错误：
GGSCI (rhel133) 6> dblogin sourcedb mydb,userid root
Password:
2013-08-28 17:10:21 WARNING OGG-00769 MySQL Login failed: . SQL error
(2002). Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).
ERROR: Failed to connect to MySQL database engine for HOST localhost,
DATABASE , USER root, PORT 3306.
8, OGG-00769
Mysql 这时需要配置一下环境变量：
-bash-3.00$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
export MYSQL_UNIX_PORT=/var/lib/mysql/mysql.sock
export PATH=$PATH:/u01/app/mysql/ogg11
重新登入 mysql 用户后,
GGSCI (rhel133) 1> dblogin sourcedb mydb,userid root
Password:
Successfully logged into database.
2.如果出现这种错误：
2013-08-29 10:09:54 WARNING OGG-00769 Oracle GoldenGate Delivery for
MySQL, rep1.prm: MySQL Login failed: . SQL error (2002). Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2).
2013-08-29 10:09:54 ERROR OGG-00770 oracle GoldenGate Delivery for
MySQL, rep1.prm: Failed to connect to MySQL database engine for HOST localhost,
DATABASE , USER root, PORT 3306.
解决方法： vi /etc/rc.local
[root@ ] ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
vi /etc/rc.local
9, OGG-00664
2017-07-01 15:20:27 INFO
OGG-02095 Successfully set
environment variable
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1.setenv
(NLS_LANG = "CHINESE_CHINA.AL32UTF8")
2017-07-01 15:20:27 INFO
OGG-02095 Successfully set
environment variable NLS_LANG=CHINESE_CHINA.AL32UTF8.
USERID ogguser, PASSWORD ***
2017-07-01 15:20:27 ERROR OGG-00664 OCI Error beginning
session (status = 12705-ORA-12705: Cannot access NLS data files or invalid
environment specified).
解决：
setenv (NLS_LANG = "CHINESE_CHINA.AL32UTF8")
改
setenv (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
10 , OGG-01232
WARNING OGG-06600 Oracle GoldenGate Capture for Oracle,
dptnd.prm: The remote peer for remote trail /ogg/dirdat/4a does not
support 9 digit seqlen feature. Continuing with 6 digit seqlen.
2017-07-04 14:46:41 ERROR OGG-01232 Oracle GoldenGate
Capture for Oracle, dptnd.prm: Receive TCP params error: TCP/IP error 104
(Connection reset by peer), endpoint: 134.225.71.78:7853.
解决:
1. Create a text file called GLOBALS in the source
2. Add a line containing: TRAIL_SEQLEN_6D
2. 删除应用端的上 ，dirdat/4a 文件 注意：$rm -rf 4a0000*，一定要是确定
没有在用的
3. 在 source 端添加 datapump 进程
add extract xxxx, exttrailsource ./dirdat/4a
add rmttrail ./dirdat/4a, extract xxxx
11, OGG-01411
增加进程启动时间报错 $/XXX/XXX/ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.3 14400833
OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
