Net8 confusion - need help

From: Randy Harris <randy.harris_at_nospam.net>
Date: Thu, 08 Aug 2002 21:47:20 GMT
Message-ID: <IFB49.389$2E6.258031@newssvr28.news.prodigy.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

Received on Thu Aug 08 2002 - 16:47:20 CDT