RE: 10g R2 Streams Question

What's the value for parallel_max_servers? Try to increase it.

Igor

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carlson, Todd Sent: Friday, January 06, 2006 2:03 PM
To: oracle-l_at_freelists.org
Subject: RE: 10g R2 Streams Question

Hey Igor,

That is the confusing part. I have just one capture process. It seems that it should have everything it needs...

Thanks,

Todd

-----Original Message-----

From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Friday, January 06, 2006 12:37 PM
To: Carlson, Todd; oracle-l_at_freelists.org Subject: RE: 10g R2 Streams Question

How many capture processes are you running on source db?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carlson, Todd Sent: Friday, January 06, 2006 1:30 PM
To: oracle-l_at_freelists.org
Subject: 10g R2 Streams Question

Hey Guys,

I am working with streams on RHEL4 & EE 10g R2. I have read the docs and setup a capture DB and a apply DB. I built my scripts using the example from Note:224255. However, the capture job will not enable and I get this error message in the alert log: ORA-01372: Insufficient processes for specified LogMiner operation. The dump files basically state the same thing.

The parameters are set to the doc specs. I have processes=150, job_queue_process=10, aq_tm_processes=4, logmnr_max_persistent_sessions=3. Has anyone seen this error message? If so, what did you do to fix it?

Thanks,

Todd

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 06 2006 - 20:21:21 CST