look in your sqlnet.ora file
for a line that sets the default domain
to 'world'. If it is present,
then all names are assumed to end in world, and
sqlnet would tack it onto any connect string without
a domain. It sounds like it's is not in the
sqlnet.ora file, which means that what you
use for the connect string has to EXACTLY match
what's in the tnsnames.ora file.
> -----Original Message-----
> From: Eric Fang [mailto:eric_fang_at_yahoo.com]
> Sent: Monday, May 01, 2000 4: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:09:23 CDT
