Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle replication
I would make sure that you are specifying the master instance's global_name
in a public database link. e.g.
create public database link global_name
using 'tnsname.domain.com';
In article <7b32lo$bnb$1_at_nnrp1.dejanews.com>,
stas_at_terraspace.ru wrote:
> Trying to make simple replication I followed the Server Replication Guide
> in Oracle 8.0 doc. And I faced with problem trying to create SNAPSHOT.
> I created database link at snapshot site:
>
> CONNECT scott/tiger_at_snap;
> CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger;
>
> "den" - master site name made by Oracle Net8 easy config.
> "snap" - snapshot site name made by Oracle Net8 easy config.
>
> "par" - table on "den" site.
>
> Then I made snapshot log at master site:
>
> CONNECT system/manager_at_den;
> CREATE SNAPSHOT LOG ON scott.par;
>
> Then trying to create snapshot at snapshot site
>
> CONNECT system/manager_at_snap;
> CREATE SNAPSHOT scott.par AS SELECT * FROM scott.par_at_den;
>
> got message:
> ORA-02019: connection description for remote database not found
>
> Any variations with names (scott.par_at_den.world) didn't furnish
> the desired result.
> The variations with names in Oracle Net8 easy config
> and with database link names resulted in
> appearance of another message:
>
> ORA-02085: database link DEN.WORLD connects to ORACLE.WORLD
>
> May be I do something wrong with Net or ???
> But connect scott/tiger_at_den passes correct.
>
> Thanks in advance.
> Stas.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 09:05:05 CST