No question at this time
DBA Top 10
1 M. Cadot 17000
2 A. Kavsek 14300
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4900
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48097
Total active users1702
Act. users last 24h1
Act. users last hour0
Registered user hits last week237
Registered user hits last month1339
Go up

Oracle streams multiway configuration
Next thread: SGA & PGA size
Prev thread: Please help - how to replace wmsys.wm_concat in 12c

Message Score Author Date
Hello, Can some one share steps and commands to...... Ashish R Sep 25, 2015, 06:53
Hi, I don't have the steps (<i>fortunately</i>)...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Ales Kavsek Sep 25, 2015, 11:31
Did you read the Oracle provided documentation to ...... Tim Boles Sep 28, 2015, 18:29

Follow up by mail Click here


Subject: Oracle streams multiway configuration
Author: Ashish R, India
Date: Sep 25, 2015, 06:53, 814 days ago
Os info: Linux
Oracle info: 11.2.0.4.0
Message: Hello,

Can some one share steps and commands to configure multiway streams replication between 6 databases. Also I am looking for - how to add new nodes in existing environment.

I have find few document for two way replication configuration but they seems not be appropriate for my requirement. I am strictly looking out for configure 6 way replication using streams. There is requirement of adding new nodes in existing environment and remove later those.

please help to suggest this with steps and commands.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle streams multiway configuration
Author: Ales Kavsek, Slovenia
Date: Sep 25, 2015, 11:31, 814 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi,

I don't have the steps (fortunately) for 6 way stream replication, but I can share the steps I would follow if I would get such task....

0) I would try to convince customer that feature (streams) is deprecated and as such it's not wise to start new development with streams.

1) I would search and hire some Oracle streams expert. A really, really good one (not an easy task!). Depending on the complexity, 6 way stream replication story can go from the nightmare to the horror (->Texas Chainsaw Massacre).

2) I would let him implement the solution (including properly setting up sequences on 6+ databases;)

3) As a DBA, I would then start looking for a good physician that could help me stay sane. Again, a really, really good one, because this step would be even trickier than step 1.

But that's me and my steps. I hope someone more optimistic on this site can help you.

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle streams multiway configuration
Author: Tim Boles, United States
Date: Sep 28, 2015, 18:29, 810 days ago
Message: Did you read the Oracle provided documentation to see if the given description and example meets your needs?

http://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_repextend.htm#BEBHDEHC

About Extending an Oracle Streams Replication Environment

It is at least a starting point. When you have exhausted that resource tell us what was missing from it that you still think you need.

Regards
Tim
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here