Re: Using remote database link

> The tns service_name needs to be defined in tnsnames.ora *on the > database server* hosting the source database.

Hi I collected my data below (changes a domain into x for privacy) can anyone understand why it doesn't work?

This is what I use for the dblink:

create database link fmpro3 using 'LSRNO4.LSRNO0011S.x.y.z'

/

select count(*) from documentmemos_at_fmpro

/

this is the feedback from TOAD:

create database link fmpro3 using 'LSRNO'

External database created

select count(*) from documentmemos_at_fmpro

ORA-12154: TNS:could not resolve service name

This is my tnsnames.ora on the server:

lsrno_lsrno0010s.x.y.z =

(description =

(ADDRESS_LIST =

(address =

(community= tcp.x.y.z)

(protocol = tcp)

(host = lsrno0010s)

# (host = lsrno0010s.x.y.z)

(port = 1521)

)

)

(connect_data =

(sid = lsrno)

)

)

lsrno_lsrno0011s.x.y.z =

(description =

(ADDRESS_LIST =

(address =

(community= tcp.x.y.z)

(protocol = tcp)

(host = lsrno0011s)

# (host = lsrno0011s.x.y.z)

(port = 1521)

)

)

(connect_data =

(sid = lsrno)

)

)

lsrno_lsrno0012s.x.y.z =

(description =

(ADDRESS_LIST =

(address =

(community= tcp.x.y.z)

(protocol = tcp)

(host = lsrno0012s)

# (host = lsrno0012s.x.y.z)

(port = 1521)

)

)

(connect_data =

(sid = lsrno)

)

)

LSRNO11_4.X.Y.Z =
(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = lsrno0011s)

(PORT = 1521)
)

)

(CONNECT_DATA =

(SERVICE_NAME = LSRNO4.LSRNO0011S.x.Y.Z)

)

) Received on Wed Sep 29 2004 - 03:07:34 CDT