Re: Oracle Database Link Won't work

On 12 May 2005 13:46:24 -0700, nkunkov_at_plusfunds.com wrote:

>When I select form my_DATA I get the following error:
>TNS: could not resolve service name.
>
>
>Can you help?
>This is very confusing for me so please elaborate in your explanations.

the problem here is that both database2.mycompany.com = constitutes a service name and the service_name in connect_data also. When the former is incorrect you get ora-12154, and when the latter is incorrect you get ora-12514. You don't specify the error number, and you mangle the error text, so the only thing I could respond is that the first alternative should be correct, and your post doesn't contain any clue to your failure.

--
Sybrand Bakker, Senior Oracle DBA