Hi bazza,
I tried as you told, below is the result, any further advice?
and how can I know If the HOSTS file option is used or not.


Z:\>nslookup s2000d
*** Can't find server name for address 192.168.0.1: Non-existent domain
*** Default servers are not available
Server: UnKnown
Address: 192.168.0.1

Name: s2000d.Software.Arches.com
Address: 192.168.0.24


Z:\>nslookup 192.168.0.24
*** Can't find server name for address 192.168.0.1: Non-existent domain
*** Default servers are not available
Server: UnKnown
Address: 192.168.0.1

*** UnKnown can't find 192.168.0.24: Non-existent domain

Z:\>netstat

Active Connections

Proto Local Address Foreign Address State
.
.
.

TCP w2000z1:3814 IS~S2000D:1748 ESTABLISHED --note the name changed
TCP w2000z1:3815 S2000B:1748 ESTABLISHED
TCP w2000z1:3816 w2000z1.Software.Arches.com:1748 ESTABLISHED
TCP w2000z1:4600 w2000z1.Software.Arches.com:4601 ESTABLISHED
TCP w2000z1:4708 S2000B:microsoft-ds ESTABLISHED
TCP w2000z1:7772 w2000z1.Software.Arches.com:1711 ESTABLISHED
.
.
.

Z:\>tnsping s2000d

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 16-8ÔÂ -2
003 15:13:08

Copyright (c) 1997 Oracle Corporation. All rights reserved.

ÒÑʹÓõIJÎÊýÎļþ:
C:\oracle\ora92\network\admin\sqlnet.ora


ÒÑʹÓà TNSNAMES ÊÊÅäÆ÷À´½âÎö±ðÃû
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = S2000d)(PORT = 1521))) (CONNECT_DATA = (SID = testERP) (SERVER = DEDICAT
ED)))
OK£¨50ºÁÃ룩 --tnsping OK