Re: Database Link HELP

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/03/18
Message-ID: <5glgjt$3f@mtinsc03.worldnet.att.net>#1/1

The problem may be the .WORLD. Create the database link without the .WORLD. Check the sqlnet.ora for a paramater called something like '..domain_name...' and whose value is 'world'. When sqlnetV2 tries to resolve database link names (or service names, for that matter), it automatically appends the .<value> of the parameter in sqlnet.ora; therefore, as far as sqlnetV2 is concerned, your database link name is III.WORLD.WORLD, hence the error message.

I hope this helps.

Michael Serbanescu
Senior Consultant, MIACO Corporation

---

mickg71_at_aol.com (Mickg71) wrote:
>Windows WorkGroup Server 7.3.2.2 on two Windows NT 4.0 workstations in
>peer to peer network using Named Pipes. SQLPLUS after a connect says that
>the distributed option has been installed.
>
> CONNECT USERID/PASSWORD_at_III.WORLD
>
>Why can't I use the following database link
> CREATE PUBLIC DATABASE LINK III.WORLD
> CONNECT TO SYSTEM IDENTIFIED BY MANAGER
> USING 'III.WORLD';
>
>The link gets created, but when I exercise it with
> SELECT table_name from tabs_at_III.WORLD;
>
>The system responds with an UNABLE to CONNECT message.
>
Received on Tue Mar 18 1997 - 00:00:00 CST