|
#########################开始跟踪tnsping过程##############################
nlstdipi: entry
nlstdipi: exit
nnfun2awanm: entry
nnfgiinit: entry
nncpcin_maybe_init: first request sent to name
server will have ID 0
nncpcin_maybe_init: initial retry timeout for all
name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name
server is 1
nngsini_init_streams: initializing stream subsystem,
cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial
pool size is 2
nncpcin_maybe_init: default name server domain is
[root]
nnfgiinit: Installing read path
nnfgsrsp: entry
####################读取本地tnsnames.ora文件##############################
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:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftboot: exit
nnftrne: entry
####获取本次需tnsping的连接串名，扫描整个tnsnames.ora文件匹配该连接串名####
nnftrne: Original name: oracle_157
nnfttran: entry
nncpdpt_dump_ptable: ---
D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora TABLE HAS THE
FOLLOWING CONTENTS ---
nncpdpt_dump_ptable: load_balance = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.10.157)(PORT = 1521)) (ADDRESS =
(PROTOCOL = TCP)(HOST = 10.20.10.63)(PORT = 1521)) (LOAD_BALANCE = yes)
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = credit_server_taf)
(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY =
5))))
nncpdpt_dump_ptable: balance = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.10.157)(PORT = 1521)) (ADDRESS =
(PROTOCOL = TCP)(HOST = 10.20.10.63)(PORT = 1521)) (LOAD_BALANCE = yes)
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = creditmanager)
(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY =
5))))
nncpdpt_dump_ptable: --- END
D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora TABLE ---
nnfttran: exit
############################结果正常获取##################################
nnftrne: Using tnsnames.ora address (DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.10.155)(PORT =
1521))) (CONNECT_DATA = (SID = credit1))) for name oracle_157
######################解析连接串结果并开始跟踪############################
nsmal: 212 bytes at 0xee81d8
nsmal: normal exit
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsc2addr: entry
nsc2addr:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.20.10.155)(PORT=1521))(CONNECT_DATA=(SID=credit1)))
nttbnd2addr: entry
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nttbnd2addr: using host
IP address: 10.20.10.155（此处可以看到，配置的是实际地址，所以不用在去解析DNS或者分析hosts文件）
nsmal: normal exit
nsbal: normal exit
nsiorini: exit (0)
nscpxget: entry
nscpxget: normal exit
nsopenalloc_nsntx: nlhthput on
mplx_ht_nsgbu:ctx=f32ef0, nsntx=f331d8
nsopenmplx: normal exit
########################开始创建连接######################################
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 1808.
snlinGetNameInfo: entry
snlinGetNameInfo: Using numeric form of host's
address 10.20.10.131
snlinGetNameInfo: exit
nttcni: connected on
ipaddr 10.20.10.131（解析本地IP地址）
nttcni: exit
nttcon: NT layer TCP/IP
connection has been established.（TCP/IP协议）
nttcon: set TCP_NODELAY on 1808
nttcon: exit
####################以下开始发包过程，发送87字节的包#######################
nsdo: cid=0, opcode=67, *bl=29, *what=8, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=14, flg=0x4005, mvd=0
nsdo: gtn=10, gtc=10, ptn=10, ptc=2011
nscon: entry
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nspsend: entry
nspsend: plen=87, type=1
nttwr: entry
nttwr: socket 1808 had bytes written=87
nttwr: exit
nspsend: packet dump
nspsend: 00 57 00 00 01 00 00 00 |.W......|
nspsend: 01 39 01 2C 00 00 08 00 |.9.,....|
nspsend: 7F FF C6 0E 00 00 01 00 |........|
nspsend: 00 1D 00 3A 00 00 00 00 |...:....|
nspsend: 00 00 00 00 00 00 00 00 |........|
nspsend: 00 00 00 00 00 00 00 00 |........|
nspsend: 00 00 00 00 00 00 00 00 |........|
nspsend: 00 00 28 43 4F 4E 4E 45 |..(CONNE|
nspsend: 43 54 5F 44 41 54 41 3D |CT_DATA=|
nspsend: 28 43 4F 4D 4D 41 4E 44 |(COMMAND|
nspsend: 3D 70 69 6E 67 29 29 |=ping)) |
nspsend: 87 bytes to transport（发包成功返回）
nspsend: normal exit
nscon: exit (0)
nsdo: nsctxrnk=0
nsdo: normal exit
nsdo: entry
nsdo: cid=0, opcode=68, *bl=1024, *what=9,
uflgs=0x2000, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4005, mvd=0
nsdo: gtn=10, gtc=10, ptn=10, ptc=2011
nscon: entry
############################开始回包过程##################################
nscon: recving a packet
nsprecv: entry
nsprecv: reading from transport...
nttrd: entry
ntt2err: entry
ntt2err: soc 1808 error -
operation=5, ntresnt[0]=530, ntresnt[1]=53, ntresnt[2]=0
ntt2err: exit
nttrd: exit
nsprecv: error exit
nserror: entry
nserror: nsres: id=0, op=68, ns=12570, ns2=12560;
nt[0]=530, nt[1]=53, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nscon: error exit
nsdo: nsctxrnk=0
nsdo: error exit
nscall: unexpected response
我们详细分析上面的报错过程，从目前来看，整个的发包过程没有问题，但是在包返回过程中，直接报错，返回错误ntt2err: soc 1808 error - operation=5,
ntresnt[0]=530, ntresnt[1]=53, ntresnt[2]=0
从错误的信息看，应该是在网络层面出了问题，据此我们搜索了MOS相关文档：
ORA-3113 reported when using NitroSecurity Firewall. (文档
ID 1388804.1)
该文档报错信息一致，原因是NitroSecurity防火墙的阻隔
通过对以上结果的分析，我们有理由确信在中间的网络层面出现了阻隔导致返回包的过程中出现了问题，就此将问题提交网络工程师
|
