ERROR OGG-01028 Detect inconsistency in pdata after 6 retries

Last weekend i was alerted of gg abend with error gode ogg-01028.

Been working with oracle gg for almost 6 years but this the first i encounter such issue.

  ***********************************************************************
**                     Run Time Messages                             **
***********************************************************************


2016-09-04 00:19:15  WARNING OGG-01027  Detect inconsistency in pdata after 0 retries, expecting tb 1048576, nf 20, got tb 196863, nf 255, bc 1572884, nb 1277498645, on record with seqno 9759
, rba 119140084 for data starts at rba 32480300.

Source Context :
  SourceModule            : [er.redo.ora.rtc]
  SourceID                : [/scratch/aime1/adestore/views/aime1_staxj16/oggcore/OpenSys/src/app/er/redo/oracle/rtc.c]
  SourceFunction          : [RTC_producer(void *)]
  SourceLine              : [2118]

2016-09-04 00:19:44  ERROR   OGG-01028  Detect inconsistency in pdata after 6 retries, expecting tb 1048576, nf 20, got tb 196863, nf 255, bc 1572884, nb 1277498645, on record with seqno 9759
, rba 119140084 for data starts at rba 32480300.

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************

Continue reading

Advertisements

ORA-06512: at line 1 SQL BEGIN sys.dbms_xstream_gg.SET_FOO_TRIGGER_SESSION_CONTXT (fire=>TRUE); END;.

Just another day n the office where our Development was refresh from production.

Development DB is configured to have GG multi bidirectional replication.
I started the Manager, extract and pump without any issue but when starting the replicat i’m getting below error.

2016-05-09 13:34:41  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, ckn2ure2.prm:  PROCESS ABENDING.
2016-05-09 13:40:18  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start CKL2BRE2.
2016-05-09 13:40:18  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host gcxxxx2s:37774 (START REPLICAT CKL2BRE2 ).
2016-05-09 13:40:18  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT CKL2BRE2 starting.
2016-05-09 13:40:19  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  REPLICAT CKL2BRE2 starting.
2016-05-09 13:40:19  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2016-05-09 13:40:19  ERROR   OGG-00868  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  ORA-26944: User "GGS_ADMIN" attempted to invoke a procedure without proper permissions.
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 197
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 230
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 9
ORA-06512: at line 1 SQL BEGIN sys.dbms_xstream_gg.SET_FOO_TRIGGER_SESSION_CONTXT (fire=>TRUE); END;.
2016-05-09 13:40:19  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  PROCESS ABENDING.
oracle@gcxxxx2s[CXXXESIT2] /gg111/112/11.2/11g =>

Continue reading

OGG-01705 : Input checkpoint position 6926171 for input trail file ‘df000877’ is greater than the size of the file (6879012)

One of our server rebooted itself, the server is running with Oracle GG. after the server starts. Some of the replicats ABENDED.

 
2012-11-29 00:20:52  ERROR   OGG-01705  Oracle GoldenGate Delivery for Oracle, rqpusr.prm: 
Input checkpoint position 6926171 for input trail file '/home/oracle/ggs11/dirdat/eqpuser/df000877' is greater than the size of the file (6879012). 

Continue reading

Cannot find metadata property DDL_MD_COL_LOB_ENCRYPT

NOTE : we just upgraded our GG from 10.4 to 11.1.1.1.

just another day at work and got a call the our reporting database is lagging.
i checked the GG on the target and its working fine.

but when i check the source i see and error on gg log.

 
EXTRACT EARADMNE started.
Socket buffer size set to 27985 (flush size 27985).
Recovery initialization completed for target file /home/oracle/ggs11/dirdat/ed001500, at RBA 1346, CSN 845972482261.
Output file /home/oracle/ggs11/dirdat/ed is using format RELEASE 10.4/11.1.
Rolling over remote file /home/oracle/ggs11/dirdat/ed001501.
Position of first record processed Sequence 215348, RBA 185149968, SCN 196.4158866571, 2012-04-04 12:05:59 AM.
 Continue reading