Starting more than 100 Apply Processes Fails with ORA-26650 on Apply 100th (Doc ID 1280466.1)

Last updated on FEBRUARY 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms


Streams Apply background process 100th aborted with:

ORA-26650: Capture or apply background process might not be started successfully
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process


Trying to start the process using:

execute dbms_apply_adm.start_apply('APPLY_100');

ERROR at line 1:
ORA-26650: Apply background process APPLY_100 might not be started successfully
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 743
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 28
ORA-06512: at line 1

There are more than 100 apply processes in the database; the number of possible apply processes was increased in 10.2x from 99 to 999. 

Changes

We have more than one hundred apply processes in this database, all the other work correctly but unable to start apply process 100.

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