我的sqlnet.trc文件中有如下跟踪信息: nttbnd2addr: using host IP address: 10.9.169.2 nsopen: opening transport... nttcnp: Validnode Table IN use; err 0x0 nttcni: trying to connect to socket 1444. ntt2err: soc 1444 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0 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 nioqper: error from nscall nioqper: nr err code: 0 nioqper: ns main err code: 12535 nioqper: ns (2) err code: 12560 nioqper: nt main err code: 505 nioqper: nt (2) err code: 60 nioqper: nt OS err code: 0 niqme: reporting NS-12535 error as ORA-12535 niomapnserror: returning error 12535 niotns: Couldn't connect, returning 12535 nigtrm: Count in the NI global area is now 0 nigtrm: Count in the NL global area is now 0
启动后,查看网络连接,好像不只1521端口
但这个防火墙又不能换的。一切工作在unix下是好的。
监听的端口就是默认的1521,连接时oracle是选择不定的端口
比如3012,4320,这是我打开跟踪后看到的。
如果是软件冲突,只能更换防火墙吗?
另外会不会和NT有关系呢?
报错:TNS超时。令人非常疑惑!
nsevwait: 1 newly-posted event(s)
nsevfnt: cxd: 0x16d33d0 stage 0: NT events set:
CONNECTION REQUESTnsevfnt: cxd: 0x16d33d0 stage 0: NS events set:
INCOMING CALLnsevwait: event is 0x1, on 1
nsevwait: 1 posted event(s)
nsevwait: exit (0)
nsglhe: entry
nsglhe: Event on cxd 0x16d33d0.
nsglhc: Allocating cxd 0x16efaf0
nsanswer: entry
nsopen: entry
nsmal: entry
nsmal: 428 bytes at 0x170a498
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 1712 bytes at 0x170a650
nsmal: normal exit
nsopenmplx: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 3
nttcnp: entry
ntvlin: entry
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nttcnp: exit
nttcnr: entry
nttcnr: waiting to accept a connection.
nttvlser: entry
nttvlser: valid node check on incoming node 10.71.13.194
nttvlser: Accepted Entry: 10.71.13.194
nttcnr: exit
nttcon: NT layer TCP/IP connection has been established.
nttcon: exit
nsopen: transport is open
nsnainit: entry
nsnainit: answer
nsnadct: entry
nsnadct: normal exit
nsnasvnainfo: entry
nsnasvnainfo: NA disabled for this connection
nsnasvnainfo: normal exit
nainit: entry
nagblini: entry
nau_gin: entry
nau_gparams: entry
nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
nam_gbp: Parameter not found
nau_gparams: Using default value "FALSE"
nau_gslf: entry
nam_gic: entry
nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
nam_gic: Parameter not found
nam_gic: Found 0 items
nsevfnt: cxd: 0x16d33d0 stage 0: NT events set:
CONNECTION REQUESTnsevfnt: cxd: 0x16d33d0 stage 0: NS events set:
INCOMING CALLnsevwait: event is 0x1, on 1
nsevwait: 1 posted event(s)
nsevwait: exit (0)
nsglhe: entry
nsglhe: Event on cxd 0x16d33d0.
nsglhc: Allocating cxd 0x16efaf0
nsanswer: entry
nsopen: entry
nsmal: entry
nsmal: 428 bytes at 0x170a498
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 1712 bytes at 0x170a650
nsmal: normal exit
nsopenmplx: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 3
nttcnp: entry
ntvlin: entry
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nttcnp: exit
nttcnr: entry
nttcnr: waiting to accept a connection.
nttvlser: entry
nttvlser: valid node check on incoming node 10.71.13.194
nttvlser: Accepted Entry: 10.71.13.194
nttcnr: exit
nttcon: NT layer TCP/IP connection has been established.
nttcon: exit
nsopen: transport is open
nsnainit: entry
nsnainit: answer
nsnadct: entry
nsnadct: normal exit
nsnasvnainfo: entry
nsnasvnainfo: NA disabled for this connection
nsnasvnainfo: normal exit
nainit: entry
nagblini: entry
nau_gin: entry
nau_gparams: entry
nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
nam_gbp: Parameter not found
nau_gparams: Using default value "FALSE"
nau_gslf: entry
nam_gic: entry
nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
nam_gic: Parameter not found
nam_gic: Found 0 items
NA disabled for this connection
是不是和这个有关呢?
防火墙是checkpoint,所有端口打开,没有限制。
大家多帮忙啊!
sun工作站,但我认为不是这个原因。
nttbnd2addr: using host IP address: 10.9.169.2
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 1444.
ntt2err: soc 1444 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
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
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12535
nioqper: ns (2) err code: 12560
nioqper: nt main err code: 505
nioqper: nt (2) err code: 60
nioqper: nt OS err code: 0
niqme: reporting NS-12535 error as ORA-12535
niomapnserror: returning error 12535
niotns: Couldn't connect, returning 12535
nigtrm: Count in the NI global area is now 0
nigtrm: Count in the NL global area is now 0
这也是个令我十分头痛的问题,查找了无数外文资料,还是没有解决,
请高手“该出手时就出手!”