OraFAQ Forum: Streams & AQ » Capture process does not start

Home » Server Options » Streams & AQ » Capture process does not start (Oracle 11g, Rel-1,windows 2003 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Capture process does not start [message #490505]

Tue, 25 January 2011 05:43

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

I made streams replication two databases(db1 & db2).I worked last 6 months properly ,last 2 days capture process did not start any way. I configure streams_pool_size properly .

db1 database is ok and db2 database capture process does not work. but apply process is ok for (db1,db2 database).

when I made transaction for db2 database from db1 database ,that data propagate to db2 properly but when I made transaction at db2 it does not propagate to db1 ,

1. Process are ok at db2 database (apply process,propagation process,dblink)

looking forward

Report message to a moderator

Re: Capture process does not start [message #490515 is a reply to message #490505]

Tue, 25 January 2011 06:16

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try what is explained in:
Streams Concepts and Administration
Chapter 20 Troubleshooting an Oracle Streams Environment
and come back with your results.

Regards
Michel

[Updated on: Tue, 25 January 2011 06:17]

Report message to a moderator

Re: Capture process does not start [message #490597 is a reply to message #490515]

Wed, 26 January 2011 00:17

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Thanks a lot to give me a guide line to solve problem.
I caught the problem and solve it.may be there are some transaction pending long time and switch logfile then capture process start.

db1 & db2 are testing environment. and these two databases are non-RAC(real application cluster,I have configured oracle RAC 10g,11g). Now I will configure streams with oracle RAC 11g. db1 database will be configured Oracle RAC 11g & db2 will be non-RAC database.plz give me a guide line.

already I have configured streams 10 databases( last 8 months) & all are working well. now I want to streams with Oracle RAC.

looking forward........

Report message to a moderator

Previous Topic:	10gR2 Streams Configuration error
Next Topic:	How to decomission the Specific streams

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 13 06:27:48 CST 2025