Re: database links between servers

In article <3415D8C2.41C5_at_fyiowa.infi.net>, Lorri <cole0821_at_fyiowa.infi.net> writes
>I have been attempting to create a database link between 2 servers on my
>network. Here is the stats on the servers and the code that I have been
>entering. Does anyone have any suggestions as to what I am doing wrong.
>
>THANKS IN ADVANCE FOR ANY HELP YOU CAN GIVE !!!
>
>9/9/97
>
>SID TSTA on SUN --
>SQL*Plus: Release 3.3.2.0.2 - Production on Tue Sep 09 16:02:41 1997
 [snip]
>SID PAPR on DEC/ALPHA --
>SQL*Plus: Release 3.3.2.0.2 - Production on Tue Sep 09 16:03:20 1997
 [snip]
>I can connect to both instances from my PC using SQL*PLUS -
>
>logged into the TSTA instance via SQL*PLUS on the SUN & did the
>following:
>SQL> conn lorrif_at_tsta
>Enter password: *****
>Connected.
>SQL> create public database link try2 connect to tele identified by
> telea using '(DESCRIPTION=(ADDRESS_LIST =
> (PROTOCOL=TCP (HOST=128.71.3.19) (PORT=1521)))
> (CONNECT_DATA = SID=PAPR.world) (SERVER=SHARED)))';

Lorri,

The SQL*Net connection string is the bit that you enter after the '@' in your SQL*Plus connections. In your case you have two connections strings: tsta and papr. These can be found in your TNSNAMES.ORA file suffixed with '.world'.

So, the correct database link creation is of the form:

create database link my_link
using 'tsta';

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG