Oracle replication

[st...@terraspace.ru]

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@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@den;
CREATE SNAPSHOT LOG ON scott.par;

Then trying to create snapshot at snapshot site

CONNECT system/manager@snap;
CREATE SNAPSHOT scott.par AS SELECT * FROM scott.par@den;

got message:
ORA-02019: connection description for remote database not found

Any variations with names (scot...@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@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

[Fred Hillebrandt]

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...@nnrp1.dejanews.com>,

[st...@terraspace.ru]

In article <7b3oqp$ttg$1...@nnrp1.dejanews.com>,

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.

[Lothar Dickhoff]

Just Try:
CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger using den;

should work, if you can connect to den with sqlplus.
Regs, Lothar

[Marcus N Hofer]

This is right.
if the name of the DB link matches the name of the valid connect string
(as in this case 'den')
the DB link will work. But if it does not you get

ORA-02085: database link DEN.WORLD.COM connects to given_connectstring

accessing the link. somehow the name of the DB link seems to be bound to the
connect string.
I know this but I do definitly not understand this :-)
do You?

regards
--marcus

Lothar Dickhoff schrieb in Nachricht <7b6b1p$si8$1...@news.ecrc.de>...

[Lothar Dickhoff]

Hi marcus,
the name is bound to Database Instance name if Parameter "global_names =
TRUE"
in init<sid>.ora.
If it is set to FALSE you can use different names.

Regs. Lothar

Marcus N Hofer schrieb in Nachricht ...

[st...@terraspace.ru]

In article <7b6b1p$si8$1...@news.ecrc.de>,

"Lothar Dickhoff" <dick...@ada.de> wrote:
> Just Try:
> CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger using den;
>
> should work, if you can connect to den with sqlplus.
> Regs, Lothar
>
>

I can connect to den with sqlplus (scott/tiger@den), but

CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger using den;

CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger using den;

*
ORA-02010: missing host connect string

???

[Lothar Dickhoff]

Hi Stas,

sorry, my mistake
you should write:CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY
tiger using 'den';

I扉e forgotten the quotas in database name, it is a string.

Regs. Lothar

[Shaju Francis]

Just try this.

The USING clause should be within quotes and also the connect string
should be defined inthe TNSNAMES.ORA inthe server.

CREATE DATABASE LINK den CONNECT TO scott IDENTIFIED BY tiger using
'den';