Phenomenon: GG do init data load report error OGG-00869 OGG-00199
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.
15:54:18 INFO OGG-01236 Oracle GoldenGate Delivery for Oracle, initrep. prm: Trace file/tmp/s. out opened.
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.
15:54:19 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, initrep. prm: replicat initrep started.
15:54:19 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, initrep. prm: Failed to retrieve column list handle for table SYMICS..
15:54:19 ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, initrep. prm: Table SYMICS. A does not exist in target database.
15:54:24 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, initrep. prm: process abending.
15:54:24 INFO OGG-01237 Oracle GoldenGate Delivery for Oracle, initrep. prm: Trace file/tmp/s. out closed.
Analysis:
Only the database account is created on the TARGET end, and no related tables are created, as shown below:
SQL> describe SYMICS.
ERROR:
ORA-04043: object SYMICS. A does not exist
For init data load, you must first create the source table on the target end; otherwise, an error is reported.
Solution:
Import table definitions through exp/imp before init data load.