please advise on seting up MASTER GROUP THRU REPLCATION MANAGER...

From: Henry Kam <hkskam_at_worldnet.att.net>
Date: Sun, 04 Mar 2001 02:42:45 GMT
Message-ID: <FYho6.3348$mM2.204311@bgtnsc04-news.ops.worldnet.att.net>

Have two NT 4.0 servers with O816 release 2; OEM 2.1

    service_names are db1.site1.dom and db2.site2.dom     databases Ok; tnsnames.ora ...OK;

was able to create master sites db1.site1.dom and db2.site2.dom thru Replication Manager Setup Wizard ... database links were set up automatically...worked OK too...
user repadmin were created on both sites......

But error occured when creating MASTER GROUP when lgoined to db1.site1.dom as system..

The error occured when executing the following PL/SQL block...

PLEASE ADVISE.......Thanks.....Henry.......

BEGIN
   DBMS_REPCAT.CREATE_MASTER_REPGROUP(

     gname => '"GROUPEMP"',
     qualifier => '',
     group_comment => '');

END;
/
--Stack Trace:-------
--ORA-04052: error occurred when looking up remote object
SYSTEM.SYS_at_remote_sid.remote_domain
--ORA-00604: error occurred at recursive SQL Level 2
--ORA-01017: invalid username/password: logon denied
--ORA-02063: preceding line from db2.site2.dom
--ORA-06512: at "SYS.DBMS_REPCAT_UTL",line 3743
--ORA-06512: at "SYS.DBMS_REPCAT_MAS",line 1901
--ORA-06512: at "SYS.DBMS_REPCAT",line 121
--ORA-06512: at line 2

   DBMS_REPCAT.ADD_MASTER_DATABASE(

     gname => '"GROUPEMP"',
     master => 'db2.site2.dom',
     use_existing_objects => TRUE,
     copy_rows => TRUE,
     propagation_mode => 'ASYNCHRONOUS');

END;
/
BEGIN
   DBMS_REPCAT.CREATE_MASTER_REPOBJECT(

     gname => '"GROUPEMP"',
     type => 'TABLE',
     oname => '"DEPT"',
     sname => '"SCOTT"',
     copy_rows => TRUE,
     use_existing_object => TRUE);

END;
/
BEGIN
   DBMS_REPCAT.CREATE_MASTER_REPOBJECT(

     gname => '"GROUPEMP"',
     type => 'TABLE',
     oname => '"EMP"',
     sname => '"SCOTT"',
     copy_rows => TRUE,
     use_existing_object => TRUE);

END;
/ Received on Sat Mar 03 2001 - 20:42:45 CST