Database link from 8.1.6 to 8.0.5 - error ORA-12505

Hi All

I have created a database link :

CREATE DATABASE LINK TESTREMOTE USING 'FW01.43P'; TNSNAMES.ORA contains the following entry :

FW01.43P =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fw_sw_rs11)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID=FW01)
(SERVICE_NAME = FW01.43P)

    )
  )

When I try to do select * from user.table_at_TESTREMOTE I get the following error :

ORA-12505: TNS:listener could not resolve SID given in connect descriptor

What am I missing? Received on Wed Jan 24 2001 - 10:36:28 CST