Re: Oracle replication

In article <7b3oqp$ttg$1_at_nnrp1.dejanews.com>,   Fred Hillebrandt <frederick.r.hillebrandt_at_monsanto.com> wrote:
> 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.
> >

I do, but result the same:
ORA-02085: database link DEN.WORLD.COM connects to ORACLE.WORLD

DEN.WORLD.COM - public database link

???
The problem still in force.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 01:20:58 CST