Re: Database link definition problem

What is happening is that oracle is looking at the name of your database as defined in the init.ora file. You cannot use aliases with the link unless you set global_names to false. The problem is that advanced replication processes, needs this value to be true. You can try setting global_names to false and see if the replication processes you are performing will still work. If not, I'm afraid you may have to rename your database, or change the domain name in one of the databases.

-Sheilah Scheurich
DBA Panagiotis Kotsilas wrote:

> Hi,
>
> I have a problem with the Oracle Replication.
> I am using the ORACLE Replication Manager
> and I can't add a destination to a master
> group. I allways get the error:
>
> ORA-02085: database link hausarchiv.world
> connects to oracle.world
>
> hausarchiv.world is the alias name of the remote database
> in the tnsnames.ora.
> oracle.world is the default database global_name on both sites.
>
> The server messages book says:
> Caution: The database link attempted to connect to a database
> with a different name. The name of the database link
> must be the same as the name of the database.
> Action: Create a database link with the same name as the database
> to which it connects.
>
> How can I define such a destination link?
> What I have done is:
>
> "create public database link hausarchiv.world
> using hausarchiv.world"
> "create database link hausarchiv.world connect to repadmin
> identified by passwd"
>
> Is it OK, the way I did it?
>
> I would appriciate any help!!!!!!!!!!!!!
Received on Wed Nov 19 1997 - 00:00:00 CET