Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Replication Function Problem

Oracle Replication Function Problem

From: <puiman_at_webhk.com>
Date: 1997/07/09
Message-ID: <868506238.25530@dejanews.com>#1/1

Oracle Replication Function Problem

I am trying to create the snapshot replicated object group at a snapshot site by the following command (generated by the oracle replication manager) :
  dbms_repcat.create_snapshot_repgroup(

	  gname => '"ENTERTAINMENT"', master => 'SID1.WORLD_at_NS1',
	  propagation_mode => 'ASYNCHRONOUS',
	  comment => '');

after creating the master group at the site sid1.world_at_ns1.

But the error messages arise:
ORA-23378: connection qualifier "@NS1" is not valid for object group ENTERTAINMENT

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 92
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 599
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 176
ORA-06512: at "SYS.DBMS_REPCAT", line 424
ORA-06512: at line 2

The connection qualifier should be correct since I can retrieve the master group from 'SID1.WORLD_at_NS1' in the snapshot site but error occur when I create the snapshot object.

Does anyone know the solution of this problem?

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Wed Jul 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US