Home » Server Options » Replication » Oracle 9i Multi-master Replication
Oracle 9i Multi-master Replication [message #277498] Tue, 30 October 2007 06:37 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Oracle Version: 9.2.0.7.0
Operating System: windows server 2003

Dear All,
Did anybody ever implement Advanced Multi-master Replication in oracle 9i ?
For Example
i have two sites site1 and site2
Both sites have two tables tab1 and tab2 with the same specs.
i want to replicate both tables at both sides
If i update tab1 at site1 ,it'll update tab1 at site2 and vice versa.
If i update tab2 at site1 ,it'll update tab2 at site2 and vice versa.

Regards,
M.Shakeel Azeem
Re: Oracle 9i Multi-master Replication [message #277519 is a reply to message #277498] Tue, 30 October 2007 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, I did it.

Regards
Michel
Re: Oracle 9i Multi-master Replication [message #277528 is a reply to message #277519] Tue, 30 October 2007 08:01 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear Michel Cadot
i m newby to Replication
Can u please give me the docs for this ?
i need step-by-step process if u can?

I m very thankful to u

Regards,
M.Shakeel Azeem
s_aazeem@yahoo.com
Re: Oracle 9i Multi-master Replication [message #277534 is a reply to message #277528] Tue, 30 October 2007 08:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle9i Advanced Replication

Regards
Michel
Re: Oracle 9i Multi-master Replication [message #277775 is a reply to message #277498] Wed, 31 October 2007 08:22 Go to previous message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All
i had successfully implement Mutlimaster Replication by using the link
http://www.oracle-base.com/articles/8i/AdvancedReplication.php
i had just added EMP table in Replication Environment and it was working fine .
i had basically done it with two sites
Now i want to add DEPT Table as well but unable to do so

What i had done to do it

1-CONNECT repadmin/repadmin@ABC

2-EXECUTE Dbms_Repcat.Suspend_Master_Activity(gname=>'MYREPGRP');

3-BEGIN
SQL> DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
gname => '"MYREPGRP"',
type => 'TABLE',
oname => '"DEPT"',
sname => '"SCOTT"',
copy_rows => TRUE,
use_existing_object => TRUE);
END;
/
PL/SQL procedure successfully completed.

SQL>BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
sname => '"SCOTT"',
oname => '"DEPT"',
type => 'TABLE',
min_communication => TRUE,
generate_80_compatible => FALSE);
END;
/
PL/SQL procedure successfully completed.

But when i check the status from Enterprise Manager Console "View Administrative Requests"
For first procedure CREATE_MASTER_REPOBJECT
its giving the error
ORA-02292: integrity constraint (SCOTT.FK_DEPTNO) violated - child record found
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

for second procedure GENERATE_REPLICATION_SUPPORT
ORA-23308: object SCOTT.DEPT does not exist or is invalid

DEPTNO is primary key in DEPT Table while its reffered as foriegn Key FK_DEPTNO in EMP table

Both tables DEPT and EMP Contain the same specs and same Data at both sites

I don't think there is any Foreign Key Voilation
what could be the Reasons ?
Can u please help me in this regard?

Regards,
M.Shakeel Azeem
Previous Topic: replication job broken
Next Topic: Issue with creation of a materialized view (merged)
Goto Forum:
  


Current Time: Thu Mar 28 15:13:56 CDT 2024