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 -> Replication API error

Replication API error

From: Xyerp <Xyerp_at_hotmail.com>
Date: 21 Aug 2002 04:30:18 -0700
Message-ID: <3d7bc779.0208210330.6a05c685@posting.google.com>


Hi,

Just running through the tutorial on using the replcation API, but seem to have hit a brick wall. Everything runs smooooothly until I get to this part:

SQL> connect repadmin/repadmin_at_MASTERA
Connected
SQL> BEGIN
  2 DBMS_REPCAT.ADD_MASTER_DATABASE (

      gname => 'SCOTT_MG',
      master => 'MASTERB',
      use_existing_objects => TRUE,
      copy_rows => TRUE,
      propagation_mode => 'ASYNCHRONOUS');
  3 END;
  4 /
BEGIN
*
ERROR:
ORA-04054: database link MASTERB does not exist
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 3671
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 1896
ORA-06512: at "SYS.DBMS_REPCAT", line 121
ORA-06512: at line 2

Hm. So I do a little check:

SQL> select * from DBA_DB_LINKS;

OWNER



DB_LINK

USERNAME

HOST

CREATED

PUBLIC
MASTERB
REPADMIN 20-AUG-02 REPADMIN
MASTERB
REPADMIN 20-AUG-02 Yup. There are the links. One owned by public and one by repadmin. Fine. So why does the API call give me an error?

Thanks in advance!

Russell Packer Received on Wed Aug 21 2002 - 06:30:18 CDT

Original text of this message

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