Re: ORA-12154 : TNS: could not reslove service name

[Quoted] Perhaps is the zone/domain located in sqlnet.ora different as in your tnsnames.ora
Look at the zone/domain called "WORLD" in this example.

example sqlnet.ora

NAMES.DEFAULT_DOMAIN=WORLD
NAME.DEFAULT_ZONE=WORLD example listener.ora

TCPEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))     )
    (CONNECT_DATA = (SID = ORCL))
  )

cosmin_ioan_at_msn.com wrote:

> I have been running in the same problem and no matter what I did, I
> could not get it to work. I followed practically every post on this
> newsgroup regarding this issue and with no luck. In the end, it came
> down to CAPITALIZATION of the entries in the tnsnames.ora file.
> supposedly, you should have everything in caps.... it worked for me.
> this is perhaps one of the most weird problems I have faced so far
> (btw, I am working on an WinNT/Intel platform).
>
> Hope this helps,
>
> Cosmin
>
> In article <387EC831.CD07BA05_at_acm.org>,
> Narayana Mahankali <nmahankali_at_acm.org> wrote:
> > hi ,
> > i was trying to logon to server containing Oracle 8i from a
> client
> > machine containing 8.0.5 client software. i was getting the following
> > error.
> >
> > " ORA : 12154 : TNS: Could not resolve the service name"
> >
> > I checked the host name and the instance name. they were correct.
> >
> > Can someone tell me as to what the problem might be and how i'm
> > supposed to configure the client system. do i need to reinstall
> client
> > 8.1.5 s/w on that machine?
> >
> > -roopa.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
-------------------------------------
ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
-------------------------------------