使用命令 tnsping 10.254.89.186 100

下面是出错部分的日志

该window服务器防火墙已经关闭

nttcni: Tcp conn timeout = 60000 (ms)

nttcni: TCP Connect TO enabled. Switching to NB

nttctl: entry

nttctl: Setting connection into non-blocking mode

nttcni: trying to connect to socket 440.

ntt2err: entry

ntt2err: exit

ntctst: size of NTTEST list is 1 - not calling poll

sntseltst: Testing for WRITE on socket 440

sntseltst: FOUND: write request on socket 440

ntt2err: entry

ntt2err: soc 440 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0

ntt2err: exit

nttcni: exit

nttcon: exit

nserror: entry

nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0

nsopen: unable to open transport

nsiocancel: entry

请问10.254.89.186是tnsnames.ora里面的服务名吗？

nnftmlf_make_system_addrfile: entry

nnftmlf_make_system_addrfile: system names file is D:\app\Administrator\product\11.2.0\client_1\network\admin\tnsnames.ora

nnftmlf_make_system_addrfile: exit

nnftboot: exit

nnftrne: entry

nnftrne: Original name: 10.254.89.186

nnfttran: entry

nnfttran: Error querying 10.254.89.186 of attribute A.SMD errcode 408

nnfgrne: Query unsuccessful, skipping to next adapter

nnfgrne: Switching to EZCONNECT adapter

是tnsnames.ora的内容

重新建一份tnsnames.ora文件试试，现在是不能识别这个服务名，直接切换到EZCONNECT了

使用ezconnect连接也不应该出现连不上的情况吧？

ezconnect的格式是：

IP:PORT/SID

感觉还是网络层面的问题，跟格式没关系

我将tnsnames.ora文件删除，再tnsping ip还是一样的现象