RE: tnsnames.ora

From: Hilger, Trisha <THilger_at_DEPOSITSOFT.com>
Date: Mon, 1 May 2000 12:43:06 -0700
Message-Id: <10484.104594@fatcity.com>

Try this at the connect data line

(CONNECT_DATA = (SID = ORCL)
Here's a copy of mine

ORCL.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = <connect string>)

          (Port = <port name>)

        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = <connect string>)

          (Port = <port name>)

        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
then log on with only the sid name
system/manager_at_orcl
-----Original Message-----
From: Eric Fang [mailto:eric_fang_at_yahoo.com] Sent: Monday, May 01, 2000 1:01 PM
To: Multiple recipients of list ORACLE-L Subject: tnsnames.ora

I have a wierd problem to access the database today. If I use the following
sqlplusw system/manager_at_orcl.world, it is ok to connect to the database. But if I use
sqlplusw system/manager_at_orcl
I have the ORA-12154: TNS:could not resolve service name error.
I can change the service name to whatever like orcl.c, then I am still able to connect to the database by using sqlplusw system/manager_at_orcl.c
I don't what's wrong with the service name. Any advice? The tnsnames.ora is listed as the follwing(the database is Oracle 8.1) :

ORCL.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ticket.company.com)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

-- 
Author: Eric Fang
  INET: eric_fang_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Mon May 01 2000 - 14:43:06 CDT