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

Oracle LazyDBA home page