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
Comments (1)
Trackback URL | Comments RSS Feed