I'm having a problem creating a db_link on a WIN2K machine with Oracle 8.1.6. When I create it using the following SQL:

CREATE DATABASE LINK dw_link
CONNECT TO dw1 IDENTIFIED BY dw1
USING 'ORCL';

I get the following error when I try to access it:

select count(*) from user_tables@dw_link;
ORA-02085: database link DW_LINK.LARRY connects to ORCL.LARRY

LARRY is the machine name that I'm doing this on. The Tnsnames.ora file has the following entry for ORCL:

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT=1521)))
(CONNECT_DATA = (SERVICE_NAME = orcl)
)
)

I don't encounter a problem when I do the same thing on solaris.

Thanks in advance!