Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!prodigy.*.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr28.news.prodigy.com.POSTED!not-for-mail
From: "Randy Harris" <randy.harris@nospam.net>
Newsgroups: comp.databases.oracle.misc
Subject: Net8 confusion - need help
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <IFB49.389$2E6.258031@newssvr28.news.prodigy.com>
NNTP-Posting-Host: 66.73.210.154
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr28.news.prodigy.com 1028843240 ST000 66.73.210.154 (Thu, 08 Aug 2002 16:47:20 CDT)
NNTP-Posting-Date: Thu, 08 Aug 2002 16:47:20 CDT
Organization: Prodigy Internet http://www.prodigy.com
X-UserInfo1: [[PAPDCAOPRQBQXYWBIFO_\B\RXFBE\LG@PTOO]MGH\TCDYG^WHUQBKZQLYJX\_ITFD_KFVLUN[DOM_A_NSYNWPFWNS[XV\I]PZ@BQ[@CDQDPCL^FKCBIPC@KLGEZEFNMDYMKHRL_YYYGDSSODXYN@[\BK[LVTWI@AXGQCOA_SAH@TPD^\AL\RLGRFWEARBM
Date: Thu, 08 Aug 2002 21:47:20 GMT
Xref: easynews comp.databases.oracle.misc:85345
X-Received-Date: Thu, 08 Aug 2002 14:45:08 MST (news.easynews.com)

I've been trying to understand this using the Net8 Admin Guide, but am just
too dense to figure it out.

I created a database, this entry was created in tnsnames.ora:

ES1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = DETESPC2)
          (Port = 1521)
        )
    )
    (CONNECT_DATA =
       (SID = ES1)
       (GLOBAL_NAME = ES1.world)
    )
  )

When I attempt to connect to it with sqlplus on the local system, I get an
error - TNS:could not resolve service name.  If I change the first line to:

ES1 =

(simply removing the .world), it works.  I see other systems work just fine
with the .world.

I would be grateful if someone could explain this to me.

--
Randy Harris