{"id":967,"date":"2008-11-21T06:30:35","date_gmt":"2008-11-21T10:30:35","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/"},"modified":"2009-01-28T10:14:56","modified_gmt":"2009-01-28T14:14:56","slug":"oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/","title":{"rendered":"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting"},"content":{"rendered":"

Objective:<\/u>
\n<\/strong>This paper is related to the Multi Master Replication setup, testing and troubleshooting.<\/p>\n

Introduction:
\n<\/u><\/strong>In this Multi Master Replication testing two machines are being used.
\nThere will be two databases on the two different machines i.e.<\/p>\n

a) Master1 (Master definition Site)<\/strong><\/p>\n

This site will be used for the administration of the Replication setup.<\/p>\n

b) Master2
\n<\/strong>
\nThis will act as a second Master site in the Replication.<\/p>\n

Replication Setup Procedure:<\/u><\/strong><\/p>\n

On Master1 Database:<\/strong><\/p>\n

1- Check the init parameters<\/strong><\/p>\n

a) SQL> show parameter compatible<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ncompatible string 9.2.0.0.0<\/p>\n

It should be same as the Oracle 9i Release which is being used for the Replication<\/p>\n

b) SQL> show parameter shared_pool_size<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nshared_pool_size big integer 50331648<\/p>\n

Add 110MB in the shared_pool_size<\/p>\n

c) SQL> show parameter processes<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\naq_tm_processes integer 1
\ndb_writer_processes integer 1
\njob_queue_processes integer 10
\nlog_archive_max_processes integer 2
\nprocesses integer 150<\/p>\n

Add 12 to the processes<\/p>\n

d) SQL> show parameter global_names<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nglobal_names boolean FALSE<\/p>\n

It should be TRUE<\/p>\n

e) SQL> show parameter db_domain<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_domain string<\/p>\n

It is the extension component of the local databases Global Name<\/p>\n

f) SQL> show parameter open_links<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nopen_links integer 4
\nopen_links_per_instance integer 4<\/p>\n

Add 2 for each master site into open_links<\/p>\n

g) distributed_transaction * need to be clarify<\/p>\n

h) SQL> show parameter replication<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nreplication_dependency_tracking boolean TRUE<\/p>\n

i) NAME TYPE VALUE
\n———————————— ———– ——————————
\njob_queue_processes integer 10<\/p>\n

Add 1 per additional Master<\/p>\n

k) SQL> show parameter servers<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nparallel_max_servers integer 5
\nparallel_min_servers integer 0<\/p>\n

set parallel_max_servers to 10
\nset parallel_min_servers to 2<\/p>\n

2- Check the init parameters after modifications<\/strong><\/p>\n

a) SQL> show parameter compatible<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ncompatible string 9.2.0.0.0<\/p>\n

b) SQL> show parameter shared_pool_size<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nshared_pool_size big integer 167772160<\/p>\n

c) SQL> show parameter processes<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\naq_tm_processes integer 1
\ndb_writer_processes integer 1
\njob_queue_processes integer 11
\nlog_archive_max_processes integer 2
\nprocesses integer 170<\/p>\n

d) SQL> show parameter global_names<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nglobal_names boolean TRUE<\/p>\n

e) SQL> show parameter db_domain<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_domain string world<\/p>\n

f) SQL> show parameter open_links<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nopen_links integer 6
\nopen_links_per_instance integer 4<\/p>\n

g) SQL> show parameter replication<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nreplication_dependency_tracking boolean TRUE<\/p>\n

h) SQL> show parameter job<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\njob_queue_processes integer 11<\/p>\n

i) SQL> show parameter parallel_max_servers<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nparallel_max_servers integer 10
\nSQL> show parameter parallel_min_servers<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nparallel_min_servers integer 2<\/p>\n

3- Check the Tablespace Free Space<\/strong><\/p>\n

1 select tablespace_name,sum(bytes)\/1024\/1024 Free_Space
\n2 from dba_free_space
\n3* group by tablespace_name
\nSQL> \/<\/p>\n

TABLESPACE_NAME FREE_SPACE
\n—————————— ———-
\nCWMLITE 10.625
\nDRSYS 10.3125
\nEXAMPLE .125
\nINDX 24.9375
\nODM 10.6875
\nSYSTEM 4.25
\nTOOLS 3.9375
\nUNDOTBS1 189.9375
\nUSERS 24.9375
\nXDB .1875<\/p>\n

System Tablespace should have 80MB free space
\nUndo Tablespace should have 60 MB free space<\/p>\n

3.1) Increase the required space<\/p>\n

a) Check the total space for each tablespace in database<\/p>\n

SQL> l
\n1 select file_name,bytes\/1024\/1024
\n2* from dba_data_files
\nSQL> \/<\/p>\n

FILE_NAME BYTES\/1024\/1024
\n——————————————————- —————
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\SYSTEM01.DBF 400
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\UNDOTBS01.DBF 200
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\CWMLITE01.DBF 20
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\DRSYS01.DBF 20
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\EXAMPLE01.DBF 148.75
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\INDX01.DBF 25<\/p>\n

G:\\ORACLEPDB\\ORADATA\\MASTER1\\ODM01.DBF 20
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\TOOLS01.DBF 10
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\USERS01.DBF 25
\nG:\\ORACLEPDB\\ORADATA\\MASTER1\\XDB01.DBF 38.125<\/p>\n

b) Increase the system tablespace<\/p>\n

1* alter database datafile ‘G:\\ORACLEPDB\\ORADATA\\MASTER1\\SYSTEM01.DBF’ resize 600m
\nSQL> \/<\/p>\n

Database altered.<\/p>\n

c) Check the Free space again.<\/p>\n

1 select tablespace_name,sum(bytes)\/1024\/1024 Free_Space
\n2 from dba_free_space
\n3* group by tablespace_name
\nSQL> \/<\/p>\n

TABLESPACE_NAME FREE_SPACE
\n—————————— ———-
\nCWMLITE 10.625
\nDRSYS 10.3125
\nEXAMPLE .125
\nINDX 24.9375
\nODM 10.6875
\nSYSTEM 204.25
\nTOOLS 3.9375
\nUNDOTBS1 189.8125
\nUSERS 24.9375
\nXDB .1875<\/p>\n

4- Install the Replication catalog:<\/strong><\/p>\n

Oracle 9i does not required to install the Replication Catalog<\/p>\n

5- Net9 configuration:<\/strong><\/p>\n

MASTER1 =
\n(DESCRIPTION =
\n(ADDRESS_LIST =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
\n)
\n(CONNECT_DATA =
\n(SERVER = DEDICATED)
\n(SERVICE_NAME = master1)
\n)
\n)<\/p>\n

MASTER2 =
\n(DESCRIPTION =
\n(ADDRESS_LIST =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.0.200)(PORT = 1521))
\n)
\n(CONNECT_DATA =
\n(SERVER = DEDICATED)
\n(SERVICE_NAME = master2)
\n)
\n)<\/p>\n

6- Creation of Replication Administrator (REPADMIN):<\/strong><\/p>\n

SQL> create user repadmin identified by repadmin
\n2 default tablespace tools
\n3 temporary tablespace temp
\n4 quota unlimited on tools
\n5 quota unlimited on temp
\n6 quota 0 on system;<\/p>\n

User created.<\/p>\n

SQL> grant connect, resource to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

SQL> exec dbms_repcat_admin.grant_admin_any_schema(‘REPADMIN’)<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

SQL> grant comment any table to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

SQL> grant lock any table to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

7- Creation of Replication Propagator \/ Receiver:<\/strong><\/p>\n

The propagator user is responsible to forward the deferred transactions from the source master site to the destination master site.<\/p>\n

The receiver user is responsible for applying these transactions at the destination master site.<\/p>\n

The replication administrator, propagator and receiver are normally the same user i.e. REPADMIN<\/p>\n

Register the REPADMIN as the propagator<\/p>\n

SQL> execute dbms_defer_sys.register_propagator(‘REPADMIN’)<\/p>\n

PL\/SQL procedure successfully completed. SQL> grant execute any procedure to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

8- Creation of Schema Owner<\/strong><\/p>\n

This user is usually responsible for the day-to-day administration of the schema that replication objects are created upon and can be the same user or a separate user from REPADMIN.
\nSQL> ed
\nWrote file afiedt.buf
\n1 create user repdba identified by repdba
\n2 default tablespace users
\n3 temporary tablespace temp
\n4 quota unlimited on users
\n5 quota unlimited on temp
\n6* quota 0 on system
\nSQL> \/
\nUser created.<\/p>\n

9- Create Database Links<\/strong><\/p>\n

All databases participating in the Replication must have a unique global name. The global name should be the same as the database name.
\na) Check the global_name<\/p>\n

SQL> select *
\n2 from global_name
\n3 ;<\/p>\n

GLOBAL_NAME
\n——————————————————–
\nMASTER1.US.ORACLE.COM<\/p>\n

b) Change the global_name<\/p>\n

SQL> update global_name
\n2 set global_name=’MASTER1′;
\n1 row updated.<\/p>\n

SQL> commit;
\nCommit complete.
\nc) Check the global_name
\nSQL> select *
\n2 from global_name;<\/p>\n

GLOBAL_NAME
\n—————————————
\nMASTER1<\/p>\n

10- Create the Public Database Link<\/strong><\/p>\n

a) Check the database links in the database
\nSQL> select *
\n2 from dba_db_links;
\nno rows selected<\/p>\n

b) Create the public database link
\n1 create public database link master2
\n2* using ‘master2’
\nSQL> \/
\nDatabase link created.<\/p>\n

c) Check the database link
\n1 select *
\n2* from dba_db_links<\/p>\n

SQL> \/<\/p>\n

OWNER DB_LINK USERNAME HOST CREATED
\n—————————— ——————– —————————— ———- ———
\nPUBLIC MASTER2 master2 15-MAY-04<\/p>\n

11- Create the Private Database Link for REPADMIN<\/p>\n

a) Create the private database link by connecting as REPADMIN<\/p>\n

1 create database link master2
\n2* connect to repadmin identified by repadmin
\n3 \/<\/p>\n

Database link created.<\/p>\n

b) Check the database link<\/p>\n

SQL> l
\n1 select *
\n2* from dba_db_links
\nSQL> \/<\/p>\n

OWNER DB_LINK USERNAME HOST CREATED
\n———- ——————– —————————— ———- ———
\nPUBLIC MASTER2 master2 17-MAY-04
\nREPADMIN MASTER2 REPADMIN 17-MAY-04<\/p>\n

12- Schedule \u201cpush\u201d and \u201cpurge\u201d jobs:<\/strong><\/p>\n

a) Connect with REPADMIN<\/p>\n

b) Set up the \u201cpush\u201d job to push the deferred queue automatically.<\/p>\n

1 begin
\n2 dbms_defer_sys.schedule_push (
\n3 DESTINATION => ‘master2’,
\n4 INTERVAL => ‘\/*1:Mins*\/ sysdate + 10\/(60*24)’,
\n5 NEXT_DATE => sysdate,
\n6 STOP_ON_ERROR => FALSE,
\n7 delay_seconds => 0,
\n8 PARALLELISM => 1);
\n9* end;<\/p>\n

SQL> \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

c) Set up the \u201cpurge\u201d job to purge the deferred queue automatically.<\/p>\n

SQL> begin
\n2 dbms_defer_sys.schedule_purge(
\n3 next_date => sysdate,
\n4 interval => ‘\/*1:Hr*\/ sysdate + 1\/24’,
\n5 delay_seconds => 0,
\n6 rollback_segment => ”);
\n7 end;
\n8 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

On Master2 Database:<\/strong><\/p>\n

1- Check the init parameters<\/p>\n

SQL> show parameter compatible<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ncompatible string 9.2.0.0.0
\nIt should be same as the Oracle 9i Release which is being used for the Replication<\/p>\n

b) SQL> show parameter shared_pool_size<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nshared_pool_size big integer 50331648<\/p>\n

Add 110MB in the shared_pool_size<\/p>\n

c) SQL> SQL> show parameter processes<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\naq_tm_processes integer 1
\ndb_writer_processes integer 1
\njob_queue_processes integer 10
\nlog_archive_max_processes integer 2
\nprocesses integer 150<\/p>\n

Add 12 to the processes<\/p>\n

d) SQL> SQL> show parameter global_names<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nglobal_names boolean FALSE<\/p>\n

It should be TRUE<\/p>\n

e) SQL> SQL> show parameter db_domain<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_domain string world<\/p>\n

It is the extension component of the local databases Global Name<\/p>\n

f) SQL> SQL> show parameter open_links<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nopen_links integer 4
\nopen_links_per_instance integer 4<\/p>\n

Add 2 for each master site into open_links<\/p>\n

g) distributed_transaction * need to be clarify<\/p>\n

h) SQL> SQL> show parameter replication<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nreplication_dependency_tracking boolean TRUE<\/p>\n

i) SQL> show parameter job_queue<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\njob_queue_processes integer 10<\/p>\n

Add 1 per additional Master
\nk) SQL> SQL> show parameter servers<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nparallel_max_servers integer 5
\nparallel_min_servers integer 0<\/p>\n

set parallel_max_servers to 10
\nset parallel_min_servers to 2<\/p>\n

2- Check the init parameters after modifications<\/strong><\/p>\n

a) SQL> show parameter compatible<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ncompatible string 9.2.0.0.0<\/p>\n

b) SQL> SQL> show parameter shared_pool_size<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nshared_pool_size big integer 167772160<\/p>\n

c) SQL> SQL> show parameter processes<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\naq_tm_processes integer 1
\ndb_writer_processes integer 1
\njob_queue_processes integer 11
\nlog_archive_max_processes integer 2
\nprocesses integer 170<\/p>\n

d) SQL> SQL> show parameter global_names<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nglobal_names boolean TRUE<\/p>\n

e) SQL> SQL> show parameter db_domain ***<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_domain string<\/p>\n

f) SQL> SQL> show parameter open_links<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nopen_links integer 6
\nopen_links_per_instance integer 4<\/p>\n

g) SQL> SQL> show parameter replication<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nreplication_dependency_tracking boolean TRUE<\/p>\n

h) SQL> SQL> show parameter job<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\njob_queue_processes integer 11<\/p>\n

i) SQL> SQL> show parameter parallel_max_servers<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nparallel_max_servers integer 10
\nSQL> SQL> show parameter parallel_min_servers<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\nparallel_min_servers integer 2<\/p>\n

3- Check the Tablespace Free Space<\/strong><\/p>\n

1 select tablespace_name,sum(bytes)\/1024\/1024 Free_Space
\n2 from dba_free_space
\n3* group by tablespace_name
\nSQL> \/<\/p>\n

TABLESPACE_NAME FREE_SPACE
\n—————————— ———-
\nCWMLITE 10.625
\nDRSYS 10.3125
\nEXAMPLE .125
\nINDX 24.9375
\nODM 10.6875
\nSYSTEM 4.25
\nTOOLS 3.9375
\nUNDOTBS1 194.375
\nUSERS 24.9375
\nXDB .1875<\/p>\n

System Tablespace should have 80MB free space
\nUndo Tablespace should have 60 MB free space
\n3.1) Increase the required space
\nb) Check the total space for each tablespace in database<\/p>\n

SQL> l
\n1 1 select file_name,bytes\/1024\/1024
\n2* from dba_data_files
\nSQL> \/<\/p>\n

FILE_NAME BYTES\/1024\/1024
\n——————————————————- —————
\nF:\\ORACLESB\\ORADATA\\MASTER2\\SYSTEM01.DBF 400
\nF:\\ORACLESB\\ORADATA\\MASTER2\\UNDOTBS01.DBF 200
\nF:\\ORACLESB\\ORADATA\\MASTER2\\CWMLITE01.DBF 20
\nF:\\ORACLESB\\ORADATA\\MASTER2\\DRSYS01.DBF 20
\nF:\\ORACLESB\\ORADATA\\MASTER2\\EXAMPLE01.DBF 148.75
\nF:\\ORACLESB\\ORADATA\\MASTER2\\INDX01.DBF 25
\nF:\\ORACLESB\\ORADATA\\MASTER2\\ODM01.DBF 20
\nF:\\ORACLESB\\ORADATA\\MASTER2\\TOOLS01.DBF 10
\nF:\\ORACLESB\\ORADATA\\MASTER2\\USERS01.DBF 25
\nF:\\ORACLESB\\ORADATA\\MASTER2\\XDB01.DBF 38.125<\/p>\n

b) Increase the system tablespace
\nSQL> alter database datafile ‘F:\\ORACLESB\\ORADATA\\MASTER2\\SYSTEM01.DBF’ resize 600m;<\/p>\n

Database altered.<\/p>\n

c) SQL> select tablespace_name,sum(bytes)\/1024\/1024 Free_Space
\n2 from dba_free_space
\n3 group by tablespace_name
\n4 \/<\/p>\n

TABLESPACE_NAME FREE_SPACE
\n—————————— ———-
\nCWMLITE 10.625
\nDRSYS 10.3125
\nEXAMPLE .125
\nINDX 24.9375
\nODM 10.6875
\nSYSTEM 204.25
\nTOOLS 3.9375
\nUNDOTBS1 194.375
\nUSERS 24.9375
\nXDB .1875<\/p>\n

4- Install the Replication catalog:<\/strong><\/p>\n

Oracle 9i does not required to install the Replication Catalog<\/p>\n

5- Net9 configuration:
\n<\/strong>
\nMASTER2 =
\n(DESCRIPTION =
\n(ADDRESS_LIST =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.0.200)(PORT = 1521))
\n)
\n(CONNECT_DATA =
\n(SERVICE_NAME = master2)
\n)
\n)<\/p>\n

MASTER1 =
\n(DESCRIPTION =
\n(ADDRESS_LIST =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.0.71)(PORT = 1526))
\n)
\n(CONNECT_DATA =
\n(SERVICE_NAME = master1)
\n)
\n)<\/p>\n

6- Creation of Replication Administrator (REPADMIN):<\/strong><\/p>\n

1 create user repadmin identified by repadmin
\n2 default tablespace tools
\n3 temporary tablespace temp
\n4 quota unlimited on tools
\n5 quota unlimited on temp
\n6* quota 0 on system
\nSQL> \/<\/p>\n

User created.
\nSQL> grant connect, resource to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

SQL> exec dbms_repcat_admin.grant_admin_any_schema(‘REPADMIN’)<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

SQL> grant comment any table to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

SQL> grant lock any table to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

7- Creation of Replication Propagator \/ Receiver:<\/strong><\/p>\n

The propagator user is responsible to forward the deferred transactions from the source master site to the destination master site.<\/p>\n

The receiver user is responsible for applying these transactions at the destination master site.<\/p>\n

The replication administrator, propagator and receiver are normally the same user i.e. REPADMIN
\nRegister the REPADMIN as the propagator<\/p>\n

SQL> execute dbms_defer_sys.register_propagator(‘REPADMIN’)<\/p>\n

PL\/SQL procedure successfully completed. SQL> grant execute any procedure to repadmin;<\/p>\n

Grant succeeded.<\/p>\n

8- Creation of Schema Owner<\/strong><\/p>\n

This user is usually responsible for the day-to-day administration of the schema that replication objects are created upon and can be the same user or a separate user from REPADMIN.<\/p>\n

SQL> ed
\nWrote file afiedt.buf<\/p>\n

1 create user repdba identified by repdba
\n2 default tablespace users
\n3 temporary tablespace temp
\n4 quota unlimited on users
\n5 quota unlimited on temp
\n6* quota 0 on system
\nSQL> \/<\/p>\n

User created.<\/p>\n

9- Create Database Links<\/strong><\/p>\n

All databases participating in the Replication must have a unique global name. The global name should be the same as the database name.
\na) Check the global_name<\/p>\n

SQL> select *
\n2 from global_name
\n3 ;<\/p>\n

GLOBAL_NAME
\n——————————————————–
\nMASTER2<\/p>\n

10-Create the Public Database Link<\/strong><\/p>\n

a) Check the database links in the database<\/p>\n

SQL> select *
\n2 from dba_db_links;<\/p>\n

no rows selected<\/p>\n

b) Create the public database link<\/p>\n

1 create public database link master1
\n2* using ‘master1’
\nSQL> \/<\/p>\n

Database link created.<\/p>\n

c) Check the database link<\/p>\n

1 select *
\n2* from dba_db_links
\nSQL> \/<\/p>\n

OWNER DB_LINK USERNAME HOST CREATED
\n———- —————————— —————————— ———- ———
\nPUBLIC MASTER1 master1 03-DEC-04<\/p>\n

11-Create the Private Database Link for REPADMIN<\/strong><\/p>\n

a) Create the private database link by connecting as REPADMIN<\/p>\n

1 create database link master1
\n2* connect to repadmin identified by repadmin
\n3 \/<\/p>\n

Database link created.<\/p>\n

b) Check the database link<\/p>\n

SQL> l
\n1 SQL> select *
\n2 from dba_db_links;<\/p>\n

OWNER DB_LINK USERNAME HOST CREATED
\n———- —————————— —————————— ———- ———
\nPUBLIC MASTER1 master1 03-DEC-04
\nREPADMIN MASTER1 REPADMIN 17-MAY-04<\/p>\n

12-Schedule \u201cpush\u201d and \u201cpurge\u201d jobs:<\/strong><\/p>\n

a) Connect with REPADMIN<\/p>\n

b) Set up the \u201cpush\u201d job to push the deferred queue automatically.<\/p>\n

1 begin
\n2 dbms_defer_sys.schedule_push (
\n3 DESTINATION => ‘master1’,
\n4 INTERVAL => ‘\/*10:Mins*\/ sysdate + 10\/(60*24)’,
\n5 NEXT_DATE => sysdate,
\n6 STOP_ON_ERROR => FALSE,
\n7 delay_seconds => 0,
\n8 PARALLELISM => 1);
\n9* end;
\nSQL> \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

c) Set up the \u201cpurge\u201d job to purge the deferred queue automatically.<\/p>\n

SQL> begin
\n2 dbms_defer_sys.schedule_purge(
\n3 next_date => sysdate,
\n4 interval => ‘\/*1:Hr*\/ sysdate + 1\/24’,
\n5 delay_seconds => 0,
\n6 rollback_segment => ”);
\n7 end;
\n8 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

Object Creation on Master1<\/u>
\n<\/strong>
\na) Connect with REPDBA and create the following objects<\/strong><\/p>\n

DROP TABLE DEPT; CREATE TABLE DEPT (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY, DNAME VARCHAR2(14) , LOC VARCHAR2(13) ) ; DROP TABLE EMP; CREATE TABLE EMP (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);SQL> conn repdba\/repdba@master1
\nConnected.
\nSQL> show user
\nUSER is “REPDBA”
\nSQL> DROP TABLE DEPT;
\nDROP TABLE DEPT
\n*
\nERROR at line 1:
\nORA-00942: table or view does not exist<\/p>\n

SQL> CREATE TABLE DEPT
\n2 (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,
\n3 DNAME VARCHAR2(14) ,
\n4 LOC VARCHAR2(13) ) ;<\/p>\n

Table created.<\/p>\n

SQL> DROP TABLE EMP;
\nDROP TABLE EMP
\n*
\nERROR at line 1:
\nORA-00942: table or view does not exist<\/p>\n

SQL> CREATE TABLE EMP
\n2 (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
\n3 ENAME VARCHAR2(10),
\n4 JOB VARCHAR2(9),
\n5 MGR NUMBER(4),
\n6 HIREDATE DATE,
\n7 SAL NUMBER(7,2),
\n8 COMM NUMBER(7,2),
\n9 DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);<\/p>\n

Table created.<\/p>\n

b) Create Master Replication Object Group at Master1 by connecting as REPADMIN<\/strong><\/p>\n

1 begin
\n2 dbms_repcat.create_master_repgroup(
\n3 gname => ‘”GROUP1″‘,
\n4 qualifier => ”,
\n5 group_comment => ”);
\n6* end;
\nSQL> \/
\nPL\/SQL procedure successfully completed.<\/p>\n

c) Add Master Database<\/strong><\/p>\n

SQL> begin
\n2 dbms_repcat.add_master_database(
\n3 gname => ‘”GROUP1″‘,
\n4 master => ‘master2’,
\n5 use_existing_objects => TRUE,
\n6 copy_rows => TRUE,
\n7 propagation_mode => ‘ASYNCHRONOUS’);
\n8 end;
\n9 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

d) Create Objects into Group i.e. \u201cgroup1\u201d<\/strong>
\n1 begin
\n2 dbms_repcat.create_master_repobject(
\n3 gname => ‘”GROUP1″‘,
\n4 type => ‘TABLE’,
\n5 oname => ‘DEPT’,
\n6 sname => ‘”REPDBA”‘,
\n7 copy_rows => TRUE,
\n8 use_existing_object => TRUE);
\n9* end;
\nSQL> \/
\nPL\/SQL procedure successfully completed.<\/p>\n

1 begin
\n2 dbms_repcat.create_master_repobject(
\n3 gname => ‘”GROUP1″‘,
\n4 type => ‘TABLE’,
\n5 oname => ‘EMP’,
\n6 sname => ‘”REPDBA”‘,
\n7 copy_rows => TRUE,<\/p>\n

8 use_existing_object => TRUE);
\n9* end;
\nSQL> \/
\nPL\/SQL procedure successfully completed.<\/p>\n

e) Generate the Replication support<\/strong><\/p>\n

SQL> begin
\n2 dbms_repcat.generate_replication_support(
\n3 sname => ‘”REPDBA”‘,
\n4 oname => ‘”DEPT”‘,
\n5 type => ‘TABLE’,
\n6 min_communication => TRUE);
\n7 end;
\n8 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

1 begin
\n2 dbms_repcat.generate_replication_support(
\n3 sname => ‘”REPDBA”‘,
\n4 oname => ‘”EMP”‘,
\n5 type => ‘TABLE’,
\n6 min_communication => TRUE);
\n7* end;
\nSQL> \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

f) Resume activity on the Master1<\/strong><\/p>\n

SQL> begin
\n2 dbms_repcat.resume_master_activity(
\n3 gname => ‘”GROUP1″‘);
\n4 END;
\n5 \/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

Test the Replication<\/u><\/strong><\/p>\n

a) Insert rows into DEPT at Master1 site, by connecting REPDBA<\/p>\n

INSERT INTO DEPT VALUES (10,’ACCOUNTING’,’NEW YORK’); INSERT INTO DEPT VALUES (20,’RESEARCH’,’DALLAS’); INSERT INTO DEPT VALUES (30,’SALES’,’CHICAGO’); INSERT INTO DEPT VALUES (40,’OPERATIONS’,’BOSTON’);<\/p>\n

b) As soon as the \u201cpush\u201d job executes at Master1 site, these inserted records will be pushed into the Master2 site. This behavior is vice versa as this is Multi Master Replication setup.<\/p>\n

c) Insert rows into EMP at Master1 site, by connecting REPDBA<\/p>\n

SQL> conn repdba\/repdba@master1
\nConnected.<\/p>\n

SQL> INSERT INTO EMP VALUES (7499,’ALLEN’,’SALESMAN’,7698,
\nto_date(’20-2-1981′,’dd-mm-yyyy’),1600,300,30);<\/p>\n

1 row created.<\/p>\n

SQL> commit;<\/p>\n

SQL> select *
\n2 from emp;<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

d) Check the EMP table in Master2 site by connecting REPDBA
\nSQL> conn repdba\/repdba@master2
\nConnected.
\nSQL> select *
\n2 from emp;<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20<\/p>\n

After 10 minutes again apply the SELECT statement.<\/p>\n

SQL> select *
\n2 from emp;<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

The same records have been pushed to site Master2. So the Multi Master Replication
\nis working fine.
\n<\/u>
\nThe same thing can be applied vice versa as well.<\/p>\n

f) connect repdba\/repdba@master2
\nSQL> conn repdba\/repdba@master2
\nConnected.<\/p>\n

g) SELECT the rows from the EMP table<\/p>\n

SQL> select *
\n2 from emp;<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

h) Insert one new record into EMP table<\/p>\n

1 INSERT INTO EMP VALUES (7521,’WARD’,’SALESMAN’,
\n2* 7698,to_date(’22-2-1981′,’dd-mm-yyyy’),1250,500,30)
\nSQL> \/<\/p>\n

1 row created.<\/p>\n

SQL> commit;<\/p>\n

Commit complete.
\ni) Again SELECT from emp<\/p>\n

SQL> select *
\n2 from emp;<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

j) Now connect repdba\/repdba@master1<\/p>\n

SQL> conn repdba\/repdba@master1
\nConnected.<\/p>\n

k) SELECT records from the emp table<\/p>\n

SQL> select *
\n2 from emp;<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

The third record has yet not been pushed to Master1 site. This will be pushed as soon as the \u201cpush\u201d job is executed at Master2 site.<\/p>\n

Again SELECT the records from EMP table.<\/p>\n

SQL> select *
\n2 from emp
\n3 \/<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

Now the same records have been pushed to site Master1 from Master2 site. So the Multi Master Replication is working fine from both the ends.<\/u>
\n\u00a0check the status of the propagated transaction:<\/strong><\/p>\n

<\/u>a) Connect to Master1 as REPDBA<\/p>\n

SQL> conn repdba\/repdba@master1
\nConnected.<\/p>\n

b) Insert one record into EMP<\/p>\n

SQL> INSERT INTO EMP VALUES (7566,’JONES’,’MANAGER’,7839, to_date(‘2-4-1981′,’dd-mm-yyyy’),2975,NULL,20);<\/p>\n

1 row created.<\/p>\n

SQL> commit;<\/p>\n

c) Select the table EMP<\/p>\n

SQL> select *
\n2 from emp;<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
\n7566 JONES MANAGER 7839 02-APR-81 2975 20
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

d) Check the view \u201cdefcall\u201d<\/p>\n

SQL> select *
\n2 from defcall;<\/p>\n

CALLNO DEFERRED_TRAN_ID SCHEMANAME PACKAGENAME PROCNAME ARGCOUNT
\n———- —————————— —————————— —————————— —————————— ———-
\n0 10.13.263 REPDBA EMP$RP REP_INSERT 10<\/p>\n

e) Check the view \u201cdeftrandest\u201d<\/p>\n

SQL> select *
\n2 from deftrandest;
\nDEFERRED_TRAN_ID DELIVERY_ORDER DBLINK
\n—————————— ————– ————–
\n10.13.263 302468 MASTER2<\/p>\n

f) connect to Master2 as REPDBA<\/p>\n

SQL> conn repdba\/repdba@master2
\nConnected.<\/p>\n

g) Check the EMP Table<\/p>\n

SQL> select *
\n2 from emp;
\nEMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n

h) connect to Master1 as REPADMIN and execute the following procedure to push the transaction to the Master2<\/p>\n

SQL> execute dbms_defer_sys.execute(‘master2’);
\nPL\/SQL procedure successfully completed.<\/p>\n

i) Connect to Master 2 as REPDBA
\nSQL> conn repdba\/repdba@master2
\nConnected.<\/p>\n

j) Check the EMP table
\nSQL> \/<\/p>\n

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
\n———- ———- ——— ———- ——— ———- ———- ———-
\n7369 SMITH CLERK 7902 17-DEC-80 800 20
\n7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
\n7566 JONES MANAGER 7839 02-APR-81 2975 20
\n7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30<\/p>\n","protected":false},"excerpt":{"rendered":"

Objective: This paper is related to the Multi Master Replication setup, testing and troubleshooting. Introduction: In this Multi Master Replication […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[424],"tags":[],"class_list":["post-967","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"\nOracle 9i Multi Master Advance Replication setup, testing and troubleshooting -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting -\" \/>\n<meta property=\"og:description\" content=\"Objective: This paper is related to the Multi Master Replication setup, testing and troubleshooting. Introduction: In this Multi Master Replication […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-11-21T10:30:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-01-28T14:14:56+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"19 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/\",\"name\":\"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-11-21T10:30:35+00:00\",\"dateModified\":\"2009-01-28T14:14:56+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting -","og_description":"Objective: This paper is related to the Multi Master Replication setup, testing and troubleshooting. Introduction: In this Multi Master Replication […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/","article_published_time":"2008-11-21T10:30:35+00:00","article_modified_time":"2009-01-28T14:14:56+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"19 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/","name":"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-11-21T10:30:35+00:00","dateModified":"2009-01-28T14:14:56+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/11\/21\/oracle-9i-multi-master-advance-replication-setup-testing-and-troubleshooting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Oracle 9i Multi Master Advance Replication setup, testing and troubleshooting"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=967"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/967\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}