Re: Replication API error

From: Modestas Mockus <modestasm_at_hotmail.com>
Date: Wed, 21 Aug 2002 14:52:41 +0200
Message-ID: <3d638d3b@news.takas.lt>

did you try connect as repadmin and select

select sysdate from dual_at_masterb

"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 - 07:52:41 CDT