logminer issue

Posted by Roshan on Aug 26, 2020; 10:38am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/logminer-issue-tp8686.html

Hi Erman,

OGG is running on one Oracle database server (v 12.1.0.2) to replicate tables on a MSSQL server. I am connecting streamset to this server (Oracle CDC). The mechanism to replicate changes from the Oracle server is same as golden gate: mining the redo logs using logminer and replicate changes to another target (e.g Mongo DB...).

I noticed sometimes the goldengate extract process abends with the following error in alert log:

Wed Aug 26 14:30:03 2020
Errors in file /u01/ora12c/diag/rdbms/bi/BI/trace/BI_j000_4941.trc:
ORA-12012: error on auto execute of job "APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS"
ORA-04063: package body "APEX_040200.WWV_FLOW_WORKSHEET_API" has errors
Wed Aug 26 14:30:44 2020
Thread 1 advanced to log sequence 96839 (LGWR switch)
  Current log# 4 seq# 96839 mem# 0: /data1/oradata/BI/onlinelog/redo04a.rdo
  Current log# 4 seq# 96839 mem# 1: /data1/oradata/BI/onlinelog/redo04b.rdo
Wed Aug 26 14:30:52 2020
Archived Log entry 95582 added for thread 1 sequence 96838 ID 0x45acdab7 dest 1:
Wed Aug 26 14:31:11 2020
krvxenq: Failed to acquire logminer dictionary lock (1). pid=100 OS id=4545. Retrying...
Wed Aug 26 14:35:01 2020

In ggserr.log, there is no error. Kindly advise if there is conflict with streamset and golden gate.

Thanks,

Roshan