Re: Database link in Oracle8

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 27 Sep 1999 18:59:37 +0200
Message-ID: <938451659.5568.0.pluto.d4ee154e@news.demon.nl>

Hi Miguel,

You have global_names = true and the name of the remote database doesn't match the name of the link.
With global_names = true every database name is expected to be unique, and the link name should equal the database name. You should either set global_names to false, or rename your database. I wouldn't IMO expect using global_names when you don't have a proper db_domain parameter. If you would have db_domain = csi.uned.es and a remote database in a different internet domain, then I would have used global_names.

Hth,

--
Sybrand Bakker, Oracle DBA
Miguel Sánchez <msanchez_at_csi.uned.es> wrote in message news:37ef789e.14457633_at_news.uned.es...
> I have been trying to create a database link for a schema in my
> database. In the creation it doesn't report any error, but when I used
> it the database issues the following message:
>
> "ORA-02085: database link ORAFRODO.WORLD connects to ORACLE.WORLD"
>
> The database link has the same name as the remote service (in
> tnsnames.ora file).
>
> What is wrong in my database configuration?
Received on Mon Sep 27 1999 - 11:59:37 CDT