RE: tnsnames.ora

From: French, Bobby (STL) <BFrench_at_slpcapital.com>
Date: Mon, 1 May 2000 15:21:33 -0500
Message-Id: <10484.104608@fatcity.com>

Look at your sqlnet.ora file. I have noticed two ways of setting up tnsnames.ora. One is to do like you have done below using orcl.world, then the sqlnet.ora file must have an entry in it referring to .world. Two, you can remove the .world from tnsnames.ora file and rename the sqlnet.ora to sqlnet.old. Also, you must have an entry in your listener.ora file for the orcl instance.

-----Original Message-----
From: Eric Fang [mailto:eric_fang_at_yahoo.com] Sent: Monday, May 01, 2000 3: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
also send the HELP command for other information (like subscribing).

Received on Mon May 01 2000 - 15:21:33 CDT