BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE (
gname => '"SCOTT_MG"',
master => 'MASTERB',
use_existing_objects => TRUE,
copy_rows => TRUE,
propagation_mode => 'ASYNCHRONOUS');
END;
for me the some error disapeared then i put aditional "" : '"SCOTT_MG"',
also you can try 'masterdb'
"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 - 08:09:03 CDT
