Integrated Mode Extract - KnlbmEnq: All Subscribers Are Inactive - Stop Enqueuing (Doc ID 1516816.1)

Last updated on JUNE 05, 2014

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Upon HEAVY load the EXTRACT will go into a status where the checkpoint Lag starts to increase by the minute and nothing is captured.

EXTRACT RACTEST Last Started 2012-09-11 17:49 Status RUNNING
Checkpoint Lag 00:00:00 (updated 29:51:34 ago)
Log Read Checkpoint Oracle Integrated Redo Logs
  2012-09-11 16:11:10 Seqno 53379, RBA 15176160
  SCN 2830.2299974777 (12157057422457)

SQL> select sysdate from dual;

SYSDATE
-------------------
2012-09-13 00:31:02

 

Alert log
------------

    knlbmEnq: all subscribers are inactive - stop enqueuing

 

GoldenGate Integrated Capture Healthcheck
------------------------------------------------------------


From the OGG Healthcheck we have the OGG$Q_TAB_RACTEST with the following status.

    CP02 OGG$CAP_RA CTEST 2012-09-11 17:49:10 WAITING FOR INACTIVE DEQUEUERS

 

SQLNET TRACING
------------------------

2012-09-19 10:09:30.427992 :   TRACE_LEVEL_SERVER = 16
2012-09-19 10:09:30.428006 :   TRACE_LEVEL_CLIENT = 16
....
2012-09-19 10:09:30.431932 : niotns:niotns: LOCAL Connection to (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
....
knclpsrow: send logon user (len=6) = OGGSRC
current: 10172788, newly set timer:10172790
knlcsslcr
2012-09-19 10:09:40.523768 : nioqsn:entry
2012-09-19 10:09:40.523786 : nsbasic_bsd:entry
2012-09-19 10:09:40.523802 : nsbasic_bsd:tot=0, plen=8155.
2012-09-19 10:09:40.538742 : nserror:entry
>>2012-09-19 10:09:40.538764 : nserror:nsres: id=0, op=67, ns=12552, ns2=12560; nt[0]=522, nt[1]=4, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
2012-09-19 10:09:40.538781 : nsbasic_bsd:exit (-1)
2012-09-19 10:09:40.538796 : nioqsn:send failed: bl = 1, nicbl = 1
2012-09-19 10:09:40.538812 : nioqper: error from nioqsn
2012-09-19 10:09:40.538827 : nioqper:   ns main err code: 12552
2012-09-19 10:09:40.538842 : nioqper:   ns (2)  err code: 12560
2012-09-19 10:09:40.538857 : nioqper:   nt main err code: 522
2012-09-19 10:09:40.538871 : nioqper:   nt (2)  err code: 4
2012-09-19 10:09:40.538885 : nioqper:   nt OS   err code: 0
2012-09-19 10:09:40.538900 : nioqer:entry
2012-09-19 10:09:40.538915 : nioqer: incoming err = 12150
2012-09-19 10:09:40.538930 : niomapnserror:entry
2012-09-19 10:09:40.538947 : niqme:entry
2012-09-19 10:09:40.538963 : niqme:reporting NS-12552 error as ORA-12552
2012-09-19 10:09:40.538977 : niqme:exit
2012-09-19 10:09:40.538991 : niomapnserror:exit
2012-09-19 10:09:40.539006 : nioqce:entry
2012-09-19 10:09:40.539020 : nioqce:exit
2012-09-19 10:09:40.539035 : nioqer: returning err = 12552
2012-09-19 10:09:40.539049 : nioqer:exit
2012-09-19 10:09:40.539063 : nioqsn: returning error: 12552
2012-09-19 10:09:40.539077 : nioqsn:exit
knlcsslcr-flags failed with ORA-12552
knlcnShouldAbort: examining error stack
ORA-12552: TNS:operation was interrupted
knlcnShouldAbort: examing error 12552
knlcnShouldAbort: returning FALSE
knlctCSTSetRowStatus:
  update status SUCCEED
  OGG$RAC is set to INACTIVE at time  09/19/2012 10:09:40
knlcnIsCSWaitError: examing error 12552
knlcnappterm +
knlcnappterm -
knlcsvUpdateErrorMessage: propagation rowid not populated!

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms