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

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条)

相关推荐 更多相似问题