现象:GG做init data load时报错OGG-00869 OGG-00199
来源:互联网 发布:数据库存储过程怎么用 编辑:程序博客网 时间:2024/06/05 10:36
现象:GG做init data load时报错OGG-00869 OGG-00199
2013-11-11 15:54:18 INFO OGG-03501 Oracle GoldenGate Delivery for Oracle, initrep.prm: WARNING: NLS_LANG environment variable is invalid or not set. Using operating system character set value of AL32UTF8.
2013-11-11 15:54:18 INFO OGG-01236 Oracle GoldenGate Delivery for Oracle, initrep.prm: Trace file /tmp/s.out opened.
2013-11-11 15:54:19 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, initrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/home/oracle/ogg/dirtmp.
2013-11-11 15:54:19 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, initrep.prm: REPLICAT INITREP started.
2013-11-11 15:54:19 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, initrep.prm: Failed to retrieve column list handle for table SYMICS.A.
2013-11-11 15:54:19 ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, initrep.prm: Table SYMICS.A does not exist in target database.
2013-11-11 15:54:24 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, initrep.prm: PROCESS ABENDING.
2013-11-11 15:54:24 INFO OGG-01237 Oracle GoldenGate Delivery for Oracle, initrep.prm: Trace file /tmp/s.out closed.
分析:
TARGET端只建立了数据库账号,没有创建相关表,如下:
SQL> describe SYMICS.A
ERROR:
ORA-04043: object SYMICS.A does not exist
对于init data load时,需要先在目标端将source的表创建好,否则会报错。
解决方法:
init data load前,先通过exp/imp导入表定义。
2013-11-11 15:54:18 INFO OGG-03501 Oracle GoldenGate Delivery for Oracle, initrep.prm: WARNING: NLS_LANG environment variable is invalid or not set. Using operating system character set value of AL32UTF8.
2013-11-11 15:54:18 INFO OGG-01236 Oracle GoldenGate Delivery for Oracle, initrep.prm: Trace file /tmp/s.out opened.
2013-11-11 15:54:19 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, initrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/home/oracle/ogg/dirtmp.
2013-11-11 15:54:19 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, initrep.prm: REPLICAT INITREP started.
2013-11-11 15:54:19 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, initrep.prm: Failed to retrieve column list handle for table SYMICS.A.
2013-11-11 15:54:19 ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, initrep.prm: Table SYMICS.A does not exist in target database.
2013-11-11 15:54:24 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, initrep.prm: PROCESS ABENDING.
2013-11-11 15:54:24 INFO OGG-01237 Oracle GoldenGate Delivery for Oracle, initrep.prm: Trace file /tmp/s.out closed.
分析:
TARGET端只建立了数据库账号,没有创建相关表,如下:
SQL> describe SYMICS.A
ERROR:
ORA-04043: object SYMICS.A does not exist
对于init data load时,需要先在目标端将source的表创建好,否则会报错。
解决方法:
init data load前,先通过exp/imp导入表定义。
0 0
- 现象:GG做init data load时报错OGG-00869 OGG-00199
- GG做init data load时,报错OGG-01192,OGG-01668
- GG做extract时报错OGG-00053
- ogg
- OGG
- ogg
- OGG
- ogg
- ogg
- ogg
- OGG
- OGG
- OGG
- OGG Initial Load测试
- 【OGG】OGG-00869 & ORA-01732
- ogg initial load初始化加载
- GG链路过多端口不足导致的报错OGG-01223
- OGG报错:ERROR OGG-01028解决办法
- android处理图片的一些问题总结
- ios中的关键字总结
- Inno Setup入门(二十一)——Inno Setup类参考(7)
- STATA常用命令总结
- Chrome插件开发入门
- 现象:GG做init data load时报错OGG-00869 OGG-00199
- 【COCOS2DX-ANDROID-游戏开发之二三】 界面中嵌入Android的WebView
- myeclipse中写struts.xml配置文件打开提示功能
- 系统消息
- 逃过一劫
- 在 Visual Studio 2013 中创建 ASP.NET Web 项目(1):概述 - 创建 Web 应用程序项目
- 数据结构:自定义线性数组
- OGG执行DDL复制报ORA-01435 user does not exist
- 致命错误:linux/videodev.h:没有那个文件或目录