Re: DB Links (newbie)

Rob,
Are you able to see 'DBMS_DEFER_SYS.REGISTER_PROPAGATOR'

by doing a describe DBMS_DEFER_SYS.REGISTER_PROPAGATOR ;

May be you have not installed the script that has the package/body definitions for 'DBMS_DEFER_SYS.REGISTER_PROPAGATOR' .

Rob Hough wrote in message ...
>Hi newbie question
>
>Im using oracle 8.0.4.0.0 on sunsparc solaris 2.6.
>Ive problems trying to create a DB link between db1 and db2
>Ive tried metalink for solutions (see below) and have tried their
workaround
>but to no avail.
>I may be going around this the wrong way but Ive tried replication manager
>to establish master and snapshot sites
>but I continue to get Propagator errors. When I goto properties on the
>established but faulty link it will not allow me to assign a propagator and
>since it seems to be an Oracle bug I was wondering if anyone else is having
>the same problem. It seems that Oracle 7 has all the answers and doesnt
>have these probs.
>
>
>Solution ID : 2081690.6For Problem : 1034507.6
>Affected Platforms : Sun SPARC Solaris
>Affected Products : Oracle Server - Enterprise Edition V7
>Affected Components : RDBMS V08.00.03.XXAffected Oracle Vsn : V08.00.03.XX
>Summary:THIS IS A BUG.+=+Solution Description: =====================
>This is BUG 442960. Workaround: You need to execute the following before
>generating replication support:
>execute dbms_defer_sys.register_propagator('user_name'); Example:
>execute dbms_defer_sys.register_propagator('scott');
>
>Attempted in Server manager on db2
>
>
>Connected.
>SVRMGR> execute dbms_defer_sys.register_propagator('testusr');
>dbms_defer_sys.register_propagator('testusr');
>
>ORA-06550: line 2, column 2:
>PLS-00201: identifier 'DBMS_DEFER_SYS.REGISTER_PROPAGATOR' must be declared
>ORA-06550: line 2, column 2:
>PL/SQL: Statement ignored
>SVRMGR> exit
>Server Manager complete.
>
>
>I've also tried standard CREATE DATABASE LINK dbtest
> AUTHENTICATED by testuser
>IDENTIFIED by testpassword etc,etc
>
>Please can anyone shed any light on my dilemma.
>
>Cheers
>
>Rob (DB engineer)
>DBA Dept.
>
>
>
>
Received on Wed Nov 18 1998 - 08:54:13 CST