ORA-01372: Insufficient processes for specified LogMiner operation

The Problem

When using CDC which interfaces with Streams and LogMiner to replicate changes from a source to target destinations, I received serveral errors. There were trace files generated for the DB where the capture process was running.

In the trace file for the capture process, I got this:

Error 1372 : ORA-01372: Insufficient processes for specified LogMiner operation

In the trace file for the apply process I got this:

ORA-16081: insufficient number of processes for APPLY
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process

The Solution

I found that this was related to two different parameters; logmnr_max_persistent_sessions and parallel_max_servers. In this instance, I found the best thing to do was reset the initialisation parameter in the spfile and increase the level of parallelism using the parallel_max_servers parameter.

Like it, share it...

Category: LogMiner