Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

On Fri, 10 Aug 2001 12:04:41 -0500, "Christophe S. Borg" <chris.borg_at_messageone.com> wrote:

Shouldn't it bee select from table_at_dblink. XXX in your example is the next service name. If you named it the same in both places I would check my SQLNET.ORA to review my domain setting.

>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
>
>
  Received on Fri Aug 10 2001 - 15:17:10 CDT