Dias is right. For multimaster replication DO NOT, DO NOT, DO NOT do it any
other way. Sometimes you'll find the quickest way to add a new site to
multimaster is to start by cloning one of the existing sites. In that case
having the same SID at several sites can save you some work.
"dias" <ydias_at_hotmail.com> wrote in message
news:55a68b47.0311141333.7ae28d11_at_posting.google.com...
> Hi,
>
> In a replicated system, it's recommanded the set global_names = true,
> each database is then identified by it's global name, not it's sid.
> You can then have the same sid for both dbs.
>
> Dias
>
>
>
> "harry smith" <hrysmth_at_hotmail.com> wrote in message
news:<bp2tk8$1ju3c0$1_at_ID-135545.news.uni-berlin.de>...
> > hey guys,
> >
> > we are planning to setup Advance Replication(Mult-Master) between TWO
> > different HOSTS.
> > Is it possible to have SAME ORACLESID for both Oracle Instances?
> >
> > TIA
> > -haryy smith
Received on Sat Nov 15 2003 - 16:29:18 CST
