| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tnsnames.ora
you probably have the domain set to "world" in the sql*net.ora .. comment it
and you should be fine !!
deepAk
-----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)
)
)
-- 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:15:05 CDT
 |
 |