Check the sqlnet.ora for each clients you'll see:
Those with MSP.CORP.HILLIPS.COM has
NAMES.DEFAULT_DOMAIN = CORP.HILLIPS.COM

And those with MSP has NAMES.DEFAULT_DOMAIN commented out

Regards,
Regis

-----Original Message-----
From: Mathias Awundaga [mailto:[Email Address Removed]
Sent: 26 February 2004 15:59
To: LazyDBA.com Discussion
Subject: tnsnames.ora - Why a Net Service Name format difference?

I am running oracle9i, and have not been able to explain why within the
same company, on some client stations the Net Service Name or alias
MSP.CORP.HILLIPS.COM and on others it is simply MSP.
When I switch them I get a login error: ORA-12154: TNS:could not resolve
service name

i.e.
MSP.CORP.HILLIPS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tobi)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = msp)
)
)

or

MSP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tobi)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MSP)
)
)

CAn someone explain the reason for this service name difference:
MSP.CORP.HILLIPS.COM & MSP



Thank You.

Mathias

*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

Oracle LazyDBA home page