miaoxb 2017-08-14 12:56 采纳率: 100%
浏览 2339
已采纳

windows下OGG遭遇字符集问题,求大侠指点

在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.

  • 写回答

4条回答 默认 最新

  • miaoxb 2017-08-15 01:07
    关注

    这个问题解决了,把setenv放到登录用户名密码上面就不报错了

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

悬赏问题

  • ¥15 Cubemax打好的程序无法导入keil中,怎么解决。
  • ¥15 本地部署一个javaweb项目
  • ¥15 Index was outside the bounds of the array
  • ¥15 (标签-Python|关键词-数据类型)(相关搜索:数据类型)
  • ¥15 一个识别内容的自动化脚本程序
  • ¥15 anaconda虚拟python环境部署langchain-chatchat报错
  • ¥20 matlab有约束条件下的多元函数求最小值
  • ¥50 如何隐藏网页弹出框的url地址栏
  • ¥20 metropolis算法模拟二维ising模型来计算磁化强度,fortran
  • ¥15 uniapp-typescript-vue报错