在Windows环境下配置了OGG10g到11g的同步,数据抽取、传输都没问题,但最后一步复制到目标数据库出问题了,查看日志是字符集不一致造成,日志信息如下:
2017-08-14 20:48:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (Administrator): start repl.
2017-08-14 20:48:01 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host WIN-MGD10HEP2HN:49677 (START REPLICAT REPL ).
2017-08-14 20:48:01 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPL starting.
2017-08-14 20:48:01 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, REPL.prm: REPLICAT REPL starting.
2017-08-14 20:48:01 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, REPL.prm: Operating system character set identified as GBK. Locale: zh_Hans_CN, LC_ALL:.
2017-08-14 20:48:01 INFO OGG-03501 Oracle GoldenGate Delivery for Oracle, REPL.prm: WARNING: NLS_LANG environment variable is invalid or not set. Using operating system character set value of US7ASCII.
2017-08-14 20:48:01 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, REPL.prm: Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
C:\OGG\dirtmp.
2017-08-14 20:48:02 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, REPL.prm: REPLICAT REPL started.
2017-08-14 20:51:40 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host JTV-76644BE50DE:1219 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2017-08-14 20:51:40 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically).
2017-08-14 20:51:41 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from SERVER on host WIN-MGD10HEP2HN:49722 (REPORT 3168 7501).
2017-08-14 20:51:41 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7501).
2017-08-14 20:51:41 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds.
2017-08-14 20:52:00 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to JTV-76644BE50DE:1226.
2017-08-14 20:52:00 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening c:\ogg\dirdat\et000001 (byte -1, current EOF 1142).
2017-08-14 20:52:00 INFO OGG-01670 Oracle GoldenGate Collector for Oracle: Closing c:\ogg\dirdat\et000001.
2017-08-14 20:52:00 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening c:\ogg\dirdat\et000001 (byte 1142, current EOF 1142).
2017-08-14 20:52:00 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing c:\ogg\dirdat\et000001 to disk.
2017-08-14 20:52:00 INFO OGG-01735 Oracle GoldenGate Collector for Oracle: Synchronizing c:\ogg\dirdat\et000001 to disk.
2017-08-14 20:52:00 INFO OGG-01670 Oracle GoldenGate Collector for Oracle: Closing c:\ogg\dirdat\et000001.
2017-08-14 20:52:00 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening c:\ogg\dirdat\et000002 (byte -1, current EOF 0).
2017-08-14 20:52:00 INFO OGG-01020 Oracle GoldenGate Delivery for Oracle, REPL.prm: Processed extract process RESTART_ABEND record at seq 2, rba 1117 (aborted 0 records).
2017-08-14 20:52:10 INFO OGG-01020 Oracle GoldenGate Delivery for Oracle, REPL.prm: Processed extract process RESTART_ABEND record at seq 2, rba 1179 (aborted 0 records).
2017-08-14 20:52:12 WARNING OGG-03504 Oracle GoldenGate Delivery for Oracle, REPL.prm: NLS_LANG character set US7ASCII on the target is different from the source database character set ZHS16GBK. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
windows下OGG遭遇字符集问题,求大侠指点
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
4条回答 默认 最新
- miaoxb 2017-08-15 01:07关注
这个问题解决了,把setenv放到登录用户名密码上面就不报错了
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥15 angular项目错误
- ¥20 需要帮我远程操控一下,运行一下我的那个代码,我觉得我无能为力了
- ¥20 有偿:在ubuntu上安装arduino以及其常用库文件。
- ¥15 请问用arcgis处理一些数据和图形,通常里面有一个根据点划泰森多边形的命令,直接划的弊端是只能执行一个完整的边界,但是我们有时候会用到需要在有很多边界内利用点来执行划泰森多边形的命令
- ¥30 在wave2foam中执行setWaveField时遇到了如下的浮点异常问题,请问该如何解决呢?
- ¥750 关于一道数论方面的问题,求解答!(关键词-数学方法)
- ¥200 csgo2的viewmatrix值是否还有别的获取方式
- ¥15 Stable Diffusion,用Ebsynth utility在视频选帧图重绘,第一步报错,蒙版和帧图没法生成,怎么处理啊
- ¥15 请把下列每一行代码完整地读懂并注释出来
- ¥15 寻找公式识别开发,自动识别整页文档、图像公式的软件