OraFAQ Forum: Streams & AQ » How to decomission the Specific streams

Home » Server Options » Streams & AQ » How to decomission the Specific streams (Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit)

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

How to decomission the Specific streams [message #440555]

Mon, 25 January 2010 11:23

tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia

Member

Hi,

We have five Oracle Streams:

Streams Name   CAPTURE PROCESS         APPLY PROCESS       
 1. AE         at AA Database         at AB Database  
 2. AG         at AA Database         at AB Database  
 3. AF         at AA Database         at AB Database  
 4. AT         at AA Database         at AB Database  
 5. AK         at AA Database         at AB Database

All the above five Streams are active.

How to decomission the AT & AK streams only i.e. (i.e. removal of streams from AA Database (CAPTURE PROCESS) and the AB Database (APPLY PROCESS)).

Please suggest.

[Updated on: Mon, 25 January 2010 11:24]

Report message to a moderator

Re: How to decomission the Specific streams [message #490763 is a reply to message #440555]

Thu, 27 January 2011 04:01

sureshchauhan
Messages: 2
Registered: January 2011
Location: Gurgaon

Junior Member

Hi

I am also facing similar problem. I wanted to decommission the Streams. I deleted Capture Process using OEM. Then I deleted the Propagation without success. Then I deleted the apply process from the destination DB.
Since Propagation hanged, now it does not allow me clear it. I tried to drop the Streams Admin Schema, but it hangs.

Please guide me what to do now, and what is the process to decommission the Streams.

regards
Suresh Chauhan

Report message to a moderator

Re: How to decomission the Specific streams [message #490831 is a reply to message #490763]

Thu, 27 January 2011 10:25

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

Senior Member
Account Moderator

In 9i, it is not possible. You suppress all or none of Streams configuration.
I recommend to NOT use Streams in 9i, it is not reliable (at least upgrade to 9.2.0.8 ).

Regards
Michel

[Updated on: Thu, 27 January 2011 10:25]

Report message to a moderator

Re: How to decomission the Specific streams [message #492573 is a reply to message #490763]

Tue, 01 February 2011 03:59

sureshchauhan
Messages: 2
Registered: January 2011
Location: Gurgaon

Junior Member

Hi Michel,

I am using Oracle 10.2.

regards
Suresh

Report message to a moderator

Re: How to decomission the Specific streams [message #492576 is a reply to message #492573]

Tue, 01 February 2011 04:08

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

Senior Member
Account Moderator

The title says: "Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit".

Use DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION to remove Streams.
But as you are now in the middle of the process I don't know how it will behave.

Regards
Michel

Report message to a moderator

Previous Topic:	Capture process does not start
Next Topic:	Change Data Capture

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:02:23 CST 2024