My Oracle Support Banner

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 JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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



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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.