Saturday, March 19, 2016

Oracle GoldenGate ERROR OGG-01668


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/views/aime1_staxj04/oggcore/OpenSys/src/app/er/init.cpp]
  SourceFunction          : [get_infile_params(time_elt_def *, time_elt_def *, char **)]
  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

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...