Home » Server Options » Streams & AQ » Capture process does not start (Oracle 11g, Rel-1,windows 2003 server)
Capture process does not start [message #490505] Tue, 25 January 2011 05:43 Go to next message
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

Re: Capture process does not start [message #490515 is a reply to message #490505] Tue, 25 January 2011 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
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 Go to previous message
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........
Previous Topic: 10gR2 Streams Configuration error
Next Topic: How to decomission the Specific streams
Goto Forum:
  


Current Time: Wed Dec 04 12:54:23 CST 2024