TNS:could not resolve service name

From: J Gin <jgin_at_nortelnetworks.com>
Date: Fri, 16 Nov 2001 17:39:40 -0500
Message-ID: <9t44d7$an1$1@bcarh8ab.ca.nortel.com>

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 Received on Fri Nov 16 2001 - 16:39:40 CST