Re: SID names in Multi-Master Advance replication.

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 15 Nov 2003 04:38:33 GMT
Message-ID: <d5itb.23091$hB5.15679@nwrdny02.gnilink.net>

"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:rn8arvsh5gvgno8uvsjob7clldeabu6jkg_at_4ax.com...
> On Fri, 14 Nov 2003 09:50:30 -0600, "harry smith"
> <hrysmth_at_hotmail.com> wrote:
>
> >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
> >
>
>
> As long as the service names and the global database names are
> different: yes. But probably you'll sooner or later going to confuse
> them and end up in a mess.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Why would he confuse them :)

Just changing the global_name would do too (i.e. just the global_name being different). However, it is advised to keep the service_name (s) also different.

sid can remain the same.

.. and global_names init.ora parameter should also be set to true

Anurag Received on Fri Nov 14 2003 - 22:38:33 CST