您好,欢迎访问一九零五行业门户网

GG做init data load时报错OGG-00869 OGG-00199 解决

现象:gg做init data load时报错ogg-00869 ogg-001992013-11-11 15:54:18 info ogg-03501 oracle goldengate delivery for oracl
现象: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导入表定义。
其它类似信息

推荐信息