Oracle Database Discussions

I'm trying to create a multimaster replication using two PCs. In both of these PCs Oracle Enterprise Manager 11g is installed.

Cause of my lack of experience in replication, I'm following the steps given in this link:

http://download.oracle.com/docs/cd/B10500_01/server.920/a96568/toc.htm

I'm not interested in materialized views, so I'm skipping steps about them.

Everything seems to be right:

- Create repadmin user
- Grant privileges
- Register propagator and receiver
- Schedule purge
- Creation of public and private links
(These steps were given in both of the nodes)

Only in the first node, following steps were given:

- Creation of master group
- Adition of objects to this master group

The error was found when I tried to add aditional master sites. As documentation says, master group definition implies the node in which the group is defined becomes master definition site by default. To add a new master site, I'm using this code:


BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE (
gname => 'hr_repg',
master => 'orc2',
use_existing_objects => TRUE,
copy_rows => FALSE,
propagation_mode => 'ASYNCHRONOUS');
END;

In documentation in not clear where this code should be executed and which user have to do it. I've tried every possible combination site/user: Two sites and user system/repadmin, getting an error in every case.

In which site should I execute this code? (site in which the master group was created or site to be added)

Which user has to execute the procedure call? (system/repadmin)

Do I have to give a previous step to this code execution?

Depending where/who executes this code, I get different error codes:

repadmin / first site: ORA-23375
repadmin / second site: ORA-23312
system / first site: ORA-23375
system / second site: ORA-23312

Thanks in advance