WINDOW2008下无法TNSPING通监听？

2019年过年前 发生数据库监听死掉了,最后重启了数据库所在的机器!
过完年后初七上班,问题再发生了.后期每个7天数据库的监听就死掉了.
然后这几周,我把数据库 ORACLE 11.2.0.1 WINDOWS2008上 各种应用给删出来了,卸掉了!
不过都没有效果,还是每个7天来一次,要么是周五,要么是周一. 怀疑是FTP 上传备份数据库,导致WINDOWS CACHE 占用不释放导致的.然后写个清楚脚本的EXE定时清理,好像也没有用. 最后发现WINDOWS 服务器上的LISTENER 重启就好了,我一般喜欢在CMD 上 LISTENER STOP START 方式.

所以做了个BAT脚本,每天定时重启监听,清理缓存.

7天后 依旧发生问题, 不过这次,监听好好的,在本地TNSPING 也能通, SQLPLUS 也能登录进去,使用外面的机器也可以TNSPING 通,SQLPLUS XXX/XXX@DB 也可以,

应用服务器就是TNSPING不通 只好重启WINDOWS服务器.

下面是TNSPING 的TRAC

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 11-3月 -2019 08:50:23

Copyright (c) 1997, 2010, Oracle. All rights reserved.

--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is D:\\DB\\tnsping.trc
New trace level is 16
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source D:\\DB\\app\\Administrator\\product\\11.2.0\\dbhome_1\\network\\admin\\sqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TNSPING.TRACE_LEVEL = SUPPORT
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
TNSPING.TRACE_DIRECTORY = D:\\DB
SQLNET.AUTHENTICATION_SERVICES = (NTS)
--- PARAMETER SOURCE INFORMATION ENDS ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nlstdipi: entry
nlstdipi: exit
nnfun2awanm: entry
nnfgiinit: entry
nncpcin_maybe_init: default name server domain is [root]
nnfgiinit: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrdp: entry
nnfgsrdp: Setting path:
nnfgsrdp: checking element TNSNAMES
nnfgsrdp: checking element EZCONNECT
nnfgsrdp: Path set
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnftboot: entry
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_local_addrfile: exit
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is D:\\DB\\app\\Administrator\\product\\11.2.0\\dbhome_1\\network\\admin\\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftboot: exit
nnftrne: entry
nnftrne: Original name: jxnc
nnfttran: entry
nncpdpt_dump_ptable: --- D:\\DB\\app\\Administrator\\product\\11.2.0\\dbhome_1\\network\\admin\\tnsnames.ora TABLE HAS THE FOLLOWING CONTENTS ---
nncpdpt_dump_ptable: ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO)))
nncpdpt_dump_ptable: orcl = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.8.5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
nncpdpt_dump_ptable: --- END D:\\DB\\app\\Administrator\\product\\11.2.0\\dbhome_1\\network\\admin\\tnsnames.ora TABLE ---
nnfttran: exit
nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.8.5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))) for name orcl
nnftrne: exit
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnftgav: entry
nnftgav: exit
nnfgfrm: entry
nnftfrm: entry
nnftfrm: exit
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
nscall: entry
nsmal: entry
nsmal: 280 bytes at 0x62237d0
nsmal: normal exit
nscall: connecting...
nlad_expand_hst: Adding an ADDRESS_LIST binding
nlad_expand_hst: Expanding 10.0.8.5
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nlad_expand_hst: Already an IP address
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nlad_expand_hst: Result: (DESCRIPTION=(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.8.5)(PORT=1521))))
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsmal: entry
nsmal: 119 bytes at 0x6224ab0
nsmal: normal exit
nsc2addr: entry
nsc2addr: (DESCRIPTION=(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.8.5)(PORT=1521)))
nttbnd2addr: entry
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nttbnd2addr: using host IP address: 10.0.8.5
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 1496 bytes at 0x6224b30
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 2944 bytes at 0x6225110
nsmal: normal exit
nsiorini: entry
nsbal: entry
nsbgetfl: entry
nsbgetfl: normal exit
nsmal: entry
nsmal: 168 bytes at 0x6225ed0
nsmal: normal exit
nsbal: normal exit
nsiorini: exit (0)
nscpxget: entry
nscpxget: normal exit
nsopenalloc_nsntx: nlhthput on mplx_ht_nsgbu:ctx=6224b30, nsntx=6225110
nsopenmplx: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
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 436.
nttcni: connection refused - trying again in 2 seconds.
nttcni: creating a new socket to retry with.
nttcni: TCP Connect TO enabled. Switching to NB
nttctl: entry
nttctl: Setting connection into non-blocking mode
nttcni: trying to connect to socket 436.
nttcni: connection refused - trying again in 4 seconds.
nttcni: creating a new socket to retry with.
nttcni: TCP Connect TO enabled. Switching to NB
nttctl: entry
nttctl: Setting connection into non-blocking mode
nttcni: trying to connect to socket 436.
nttcni: connection refused - trying again in 8 seconds.
nttcni: creating a new socket to retry with.
nttcni: TCP Connect TO enabled. Switching to NB
nttctl: entry
nttctl: Setting connection into non-blocking mode
nttcni: trying to connect to socket 436.
nttcni: connection refused - trying again in 16 seconds.
nttcni: creating a new socket to retry with.
nttcni: TCP Connect TO enabled. Switching to NB
nttctl: entry
nttctl: Setting connection into non-blocking mode
nttcni: trying to connect to socket 436.
nttcni: connection refused - retry timeout of 8 seconds has expired.
ntt2err: entry
ntt2err: soc 436 error - operation=1, ntresnt[0]=530, ntresnt[1]=55, ntresnt[2]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=55, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nsiocancel: entry
nsiofrrg: entry
nsiofrrg: cur = 6225e48
nsbfr: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfr: normal exit
nsiofrrg: exit
nsiocancel: exit
nsvntx_dei: entry
nsvntx_dei: exit
nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=6224b30 nsntx=6225110
nsiocancel: entry
nsiofrrg: entry
nsiofrrg: exit
nsiocancel: exit
nsmfr: entry
nsmfr: 2944 bytes at 0x6225110
nsmfr: normal exit
nsmfr: entry
nsmfr: 1496 bytes at 0x6224b30
nsmfr: normal exit
nsopen: error exit
nsmfr: entry
nsmfr: 119 bytes at 0x6224ab0
nsmfr: normal exit
nscall: error exit
nscall: entry
nscall: connecting...
nsclose: entry
nsclose: normal exit
nladget: entry
nladget: exit
nsmfr: entry
nsmfr: 280 bytes at 0x62237d0
nsmfr: normal exit
nladtrm: entry
nladtrm: exit
nscall: error exit
nlse_term_audit: entry
nlse_term_audit: exit