Re: replication between to db's with same sid

David,
Advanced Replication does insist that the databases match their database links. You may change the database name if necessary after the database has been created with the follwing info:
-- changing global_name of database
1) Write global_name to database using the format "PROD1.WORLD". Note: No more than one period is allowed, and the name must be in for format of db_name "." db_domain.
2) Then if the global_name needs updated to a non-standard format like "PROD1" (with no db_domain), update the table after step 1 has been completed:
update global_name set global_name = 'PROD1'; commit
or
update global_name set global_name = 'PROD1.NEW'; commit
Note: In all cases, the database link name must exactly match the database global_name because the init.ora global_names parameter must be set to TRUE in order for replication to work correctly.

I have a few tips like this documented clear at the end of the following page on my website:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_example_repdoc1.htm l

There are some example sql scripts here: http://www.dotcomsolutionsinc.net/products/repgen/repgen_files.html

David Simpson
www.dotcomsolutionsinc.net
"Edzard" <edzard_at_volcanomail.com> wrote in message news:5d75e934.0205301123.4fdce223_at_posting.google.com...
> Hello,
>
> This is a mind-expanding question.
>
> I'd first say that the sid's are not relevant. The two databases
> mutually call each other by their global name. Or actually by the name
> of the database link from the one two the other. Oracle has the
> "global_names" initialization parameter which, if set to true, forces
> database link names to be equal to the global name of the destination
> database. So then the two databases are NOT symetrical.
>
> But the two databases are not symetrical anyway, as even with
> multi-master replication, there is only one master DEFINITION site!
>
> Now comes my brainwave: use THREE databases! I don't know how many
> servers you have, but with three databases you can have one master
> definition site and two additional sites. These should be fairly
> identical. Except for their global names may be, but that is not
> difficult to change.
>
> Admittedly I doubt it is practical for your purpose. Replication is
> difficult anyway. You need to take it into account in your database
> triggers, in cascade delete constraints in sequences and for
> long-fields, as far as my experience goes.
>
> Edzard
>
> david_at_healthinsite.gov.au (David Leach) wrote in message
news:<3acf5f2e.0205292311.5f65a55e_at_posting.google.com>...
> > Hi there,
> >
> > Can anyone tell me a) if it's possible, and b) how to setup two Oracle
> > 8i databases to multi-master replicate if they're exactly the same?
> > (well, same sid).
> >
> > I'm trying to failover client connections to a single ip/sid
> > transparently onto multiple back end database instances (not load
> > balance.. more hot standby).
> >
> > Is this possible?
> >
> > thanks,
> >
> > David.
Received on Fri May 31 2002 - 17:17:02 CDT