Re: Re: Help needed with database links

Try setting the parameter in the init.ora file global_names = FALSE and restart your instances then name the link somethin else but ORCL.WORLD

The link is picking up the local database and trying to perform a loopback on it, I would guess that you have two databases on different machines both with a name of ORCL and global names set to true. With this option the link MUST be the same as the database name and therefore it will attempt a loopback

Gary Waldrom
Amonra Insight Ltd.
Authors of Q-file IT Quick Reference Guides http://www.q-file.com  

-----Original Message-----
From: Jan [mailto:jan_gerards_at_hotmail.com] Posted At: Monday, January 10, 2000 5:27 PM Posted To: server
Conversation: Help needed with database links Subject: Re: Help needed with database links

I have tried it, but now I get the next error: ORA-02082: a loopback database link must have a connection qualifier ????

thanks in advance,
Jan

david_g wrote in message
<26f15c5e.a00a3318_at_usw-ex0106-048.remarq.com>...
>create database link mylinkname -
>connect to schemaname identified by schemapassword -
>using 'tnsnamesdbname'
>
>where tnsnamesdbname is the name of the database as is included in
>your tnsnames.ora file
>
>you can then try it out with
>select * from v$database_at_mylinkname;
Received on Mon Jan 10 2000 - 15:05:41 CST