DB Links and snaphot replication (newbie)

From: Rob Hough <robert_at_u-net.net>
Date: Wed, 18 Nov 1998 14:25:56 -0000
Message-ID: <QRA42.135$qf.235_at_newsr2.u-net.net>

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 - 15:25:56 CET