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

Re: Replication API error

From: Van Messner <vmessner_at_bestweb.net>
Date: Wed, 21 Aug 2002 16:09:48 -0400
Message-ID: <um7srfjqkqi459@corp.supernews.com>


Also, you probably already checked this but you do have public and repadmin links from every master site to every other, right? Usually you'd have a little script to make sure all the links were working at all sites before adding a master database to multimaster replication.

"Alistair Thomson" <thomson_alistair_at_yahoo.co.uk> wrote in message news:1029943702.21466.0.nnrp-07.3e311022_at_news.demon.co.uk...
> Hi
>
> You need to make sure that your database links actually work. Try
selecting
> from a table at the other site. If it doesn't work check that the link
name
> is the same as the global database name and that global_names is set to
> true.
>
> Alistair
>
> "Xyerp" <Xyerp_at_hotmail.com> wrote in message
> news:3d7bc779.0208210330.6a05c685_at_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 - 15:09:48 CDT

Original text of this message

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