Replicat Abended With following Error
2016-02-17 08:09:55 INFO OGG-03035 Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.
2016-02-17 08:09:55 INFO OGG-02696 NON-ANSI SQL parameter syntax is used for parameter parsing.
replicat rotr131
sourcedefs dirdef/nsp-rwpk.def
Source Context :
SourceModule : [er.init]
SourceID : [/scratch/aime1/adestore/
SourceFunction : [get_infile_params(time_elt_
SourceLine : [1596]
2016-02-17 08:09:55 ERROR OGG-00303 Problem at line 103. Bad column definition: PREV_VDSL_UP_RATE
134 11 684 3 0 1 0 8 8ED 192 19 26 0 0 1 0 19 19 19 0 5
0 0 1 0 0 0.
2016-02-17 08:09:55 ERROR OGG-01668 PROCESS ABENDING.
Root Cause: Definition file which is used by replicat is corrupted
Fix: Rename the existing definition file in ogghome/dirdef directory and re-create New defintion file from Source database using defgen utility & place it in GoldenGateHome/dirdef directory
Regards,
Nikhil Tatineni
Knowledge On GoldenGate
12c: Oracle Goldengate wallet
Oracle GoldenGate: Defgen utility
Oracle GoldenGate: General Monitoring
Delete Unused Process in Goldengate
Goldengate: Supplemental Logging
Oracle GoldenGate: logdump utility
Oracle GoldenGate: How to find out Transaction INFO?
How to Trace Goldengate process?
GoldenGate Daily Patrol scripts on Servers
http://oracle-in-memory.blogspot.com/2016/02/goldengate-daily-patrol-scripts-on.html
Adding Primary keys to table replicated by goldengate
http://oracle-in-memory.blogspot.com/2016/02/adding-primary-keys-to-tables.html
12c: Integrated GoldenGate Extract
http://oracle-in-memory.blogspot.com/2016/02/12c-integrated-extract.html
Migrating Oracle database using Goldengate
Migrating Oracle database using Goldengate