Streams Capture Process Aborts With Errors ORA-01280, ORA-447, PLS-306 Caused by Problems With LOGMNR_KRVRDA_TEST_APPLY Procedure (Doc ID 315509.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 07-Jan-2013***


Symptoms

Streams has been successfully configured and seems to work okay, except that after a few minutes the capture process aborts.

 Trace files show errors -

*** SERVICE NAME:(SYS$USERS) 2005-06-21 10:40:41.577
    *** SESSION ID:(203.405) 2005-06-21 10:40:41.577
    knlc.c:2091: KRVX_CHECK_ERROR retval 205
    error 1280 in STREAMS process
    ORA-01280: Fatal LogMiner Error.
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-01280: Fatal LogMiner Error.

 
or -
   

    *** SERVICE NAME:(SYS$USERS) 2005-06-21 10:45:18.592
    *** SESSION ID:(186.5910) 2005-06-21 10:45:18.592
    ORA-00604: error occurred at recursive SQL level 1
    ORA-06550: line 1, column 250:
    PLS-00306: wrong number or types of arguments in call to 'LOGMNR_KRVRDA_TEST_APPLY'
    ORA-06550: line 1, column 250:
    PL/SQL: Statement ignored


   

Changes

The database was upgraded to from an earlier version to a later version.

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