Re: Oracle replication !!!

stas_at_terraspace.ru schrieb in Nachricht <7blhoa$t6r$1_at_nnrp1.dejanews.com>...
>Guys!
>
>After long discussion, I collect a lot of different advices.

indeed... You got

>But the problem is still ... actual.
>
>I made
>
>CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger;
>or
>CREATE DATABASE LINK den.world.com CONNECT TO scott IDENTIFIED BY tiger;
>etc ...
>

provide a connect string in Your create command as

CREATE DATABASE LINK SCOTTS_HOME CONNECT TO scott IDENTIFIED BY tiger USING 'SCOTTS_HOME'; to be on really safe side make sure that SCOTTS_HOME is

1. the global name of the remote DB (global names can be set with 'alter database ...' command)
2. the alias (connect string) in the TNSNAMES.ORA file Your local DB accesses
3. the DB link name matches the connect string (SCOTTS_HOME) as the global_names parameter in init(SID).ora could be set, as Lothar explained in the previous thread.

before doing anything else try

select * from dual_at_scotts_home;

man, this really MUST work now §;^)

good luck!
--marcus

>Also entering Schema Manager (in Enterprise Manager)
>choosing Database link DEN, I see that it hasn't "Service name".
>Is it correct?
>Pressing Test button I get message "The Database Link is not active"
>???
>
>All what I did described in "Oracle Server Replication" documentation.
>I got several mail from other users with the same problem.
>I'm not alone.
>
>The problem still the same:
>
>
>CREATE SNAPSHOT scott.par AS SELECT * FROM scott.par_at_den
> *
>ORA-02019: connection description for remote database not found
>
>But connect scott/tiger_at_den works.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 04 1999 - 13:04:28 CST