Have you looked at the sqlnet.ora file on these boxes?
You may need to play with the default_domains
parameter...

HTH,

Kelly
--- Mathias Awundaga <[Email Address Removed] wrote:
> 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
>
>


=====
....Yeah...my other account is down...so, using this again.......

__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools
Oracle LazyDBA home page