Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TNS:could not resolve service name

Re: TNS:could not resolve service name

From: Ed Stevens <Ed_Stevens_at_nospam.noway.nohow>
Date: Sat, 17 Nov 2001 23:18:18 GMT
Message-ID: <3bf6effd.941593@ausnews.austin.ibm.com>


What are you using for your connect string? What is the value of DEFAULT_DOMAIN in your sqlnet.ora file?

On Fri, 16 Nov 2001 17:39:40 -0500, "J Gin" <jgin_at_nortelnetworks.com> wrote:

>I'm having problems trying to establish an sqlplus session. The error
>message returned is:
>
>ERROR:
>ORA-12154: TNS:could not resolve service name
>
>I'm running Oracle version 8.1.5.0.0 and running the same sqlplus release on
>Solaris 2.6.
>
>I've checked the tnsnames.ora file entry and included below:
>
>isd =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp_corwan.world)
> (PROTOCOL = TCP)
> (Host = 55.55.55.55)
> (PORT = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = ISD)
> (GLOBAL_NAME = ISD.ott.can.world)
> )
> )
>
>
>
>
>Thanks,
>Jeannine
>
>
>

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)
Received on Sat Nov 17 2001 - 17:18:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US