RE: [Spam in Message Body] Re: 10g R2 Streams Question

Hey Ron,

Thanks for the heads up on the script. I ran it and discovered that parallel_max_servers should be at least 3. I had it set to 2, per the docs. I set it to 3, enabled the queue and it works! Thanks for all of the help!!!

Todd

-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org] Sent: Friday, January 06, 2006 1:01 PM
To: Carlson, Todd
Subject: [Spam in Message Body] Re: 10g R2 Streams Question

Todd,
 When I was setting up streams I had problems also. I was informed that the processes=250 was needed.
I also ran the health-check probram to help point to problems (Note 273674.1 Streams Configuration Report and Health Check Script) see also Note:298877.1 10g Streams Recommended Configuration Ron

>>> "Carlson, Todd" 01/06/06 1:29 PM >>>
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 




The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other
use of or taking action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you have
received this email in error please contact the sender and delete the
material from any computer.



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