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

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 metadata提取的PDF元数据,如何转换为一个Excel
  • ¥15 关于arduino编程toCharArray()函数的使用
  • ¥100 vc++混合CEF采用CLR方式编译报错
  • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
  • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
  • ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
  • ¥50 如何openEuler 22.03上安装配置drbd
  • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
  • ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
  • ¥15 Windows11, backspace, enter, space键失灵