>  기사  >  데이터 베이스  >  GG做init data load时报错OGG-00869 OGG-00199 解决

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

WBOY
WBOY원래의
2016-06-07 17:34:121877검색

现象: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导入表定义。

linux

성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.