Re: ORA-12514: TNS:listener could not resolve SERVICE

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 10 Aug 2001 19:35:03 +0200
Message-ID: <997464922.24669.0.pluto.d4ee154e@news.demon.nl>

"Christophe S. Borg" <chris.borg_at_messageone.com> wrote in message news:9l148e$ks5$1_at_news.jump.net...
> Hi,
>
> I have verified tnsnames.ora,....
>
> XXX =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 123)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = XXX)
> )
> )
>
> I am able to TNSPING to 123
> I am able to create the database link but when I try to connect with
"select
> * from user.tbl_at_XXX" I get the above error.
>
> Thanks in advance for the help
> Chris
>
> Note: Net services and host name conciled for security reasons
>
>

Verify the tnsnames.ora *on the server* (as that one is being used to resolve database links)
also verify you're not using 'service_name=' in tnsnames.ora and 'sid=' in listener.ora.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Aug 10 2001 - 12:35:03 CDT