应用偶尔报ORA-12170
应用偶尔报 ORA-12170: TNS:Connect timeout occurred，我在客户端写了一个脚本定时做TNSPING，下面是报错时TNSPING的Trace，看不懂，大神儿们帮忙看看吧：OS: Solaris 10 SPARC
Version：11.2.0.1.5
================================================================================================
TNS Ping Utility for Solaris: Version 11.2.0.1.0 - Production on 09-MAY-2014 09:37:13
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/app/oracle/product/11.2.0/client_2/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ldds.example.com)))
TNS-12535: TNS:operation timed out
======== TNSPING TRACE ========
TNS Ping Utility for Solaris: Version 11.2.0.1.0 - Production on 09-MAY-2014 09:37:13
Copyright (c) 1997, 2009, Oracle. All rights reserved.
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is /app/oracle/product/11.2.0/client_2/network/trace/tnsping.trc
New trace level is 16
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source /app/oracle/product/11.2.0/client_2/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)
--- 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
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 /app/oracle/product/11.2.0/client_2/network/admin/tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftboot: exit
nnftrne: entry
nnftrne: Original name: ldds
nnfttran: entry
nncpdpt_dump_ptable: --- /app/oracle/product/11.2.0/client_2/network/admin/tnsnames.ora TABLE HAS THE FOLLOWING CONTENTS ---
nncpdpt_dump_ptable: FPDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.177.102)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.177.101)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = fpdb.example.com) (FAILOVER_MODE= (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 100) (DELAY = 5))))
nncpdpt_dump_ptable: LDDS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ldds.example.com)))
nncpdpt_dump_ptable: rep = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = rep.example.com)))
nncpdpt_dump_ptable: tjdb_tgt = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.100)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = tjdb.example.com)))
nncpdpt_dump_ptable: tjdb_src = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.130)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ads.example.com)))
nncpdpt_dump_ptable: DIS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dis.example.com)))
nncpdpt_dump_ptable: ARDS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ards.example.com)))
nncpdpt_dump_ptable: HIS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = his.example.com)))
nncpdpt_dump_ptable: OPDS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = opds.example.com)))
nncpdpt_dump_ptable: ads = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.130)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ads.example.com)))
nncpdpt_dump_ptable: eds_851 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.85.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = eds.example.com)))
nncpdpt_dump_ptable: DIS_100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.100)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dis.example.com)))
nncpdpt_dump_ptable: --- END /app/oracle/product/11.2.0/client_2/network/admin/tnsnames.ora TABLE ---
nnfttran: exit
nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.165.110)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ldds.example.com))) for name ldds
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
snsgblini: Max no of descriptors supported is 65536
snsgblini: exit
nscall: entry
nsmal: entry
nsmal: 272 bytes at 0x10016ce80
nsmal: normal exit
nscall: connecting...
nlad_expand_hst: Expanding 10.11.165.110
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nlad_expand_hst: Already an IP address
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nlad_expand_hst: Result: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.165.110)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ldds.example.com)))
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsmal: entry
nsmal: 121 bytes at 0x10027f7e0
nsmal: normal exit
nsc2addr: entry
nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.165.110)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ldds.example.com)))
nttbnd2addr: entry
snlinGetAddrInfo: entry
snlinGetAddrInfo: exit
nttbnd2addr: using host IP address: 10.11.165.110
snlinFreeAddrInfo: entry
snlinFreeAddrInfo: exit
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 1528 bytes at 0x100280be0
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 2648 bytes at 0x1002811f0
nsmal: normal exit
nsiorini: entry
nsbal: entry
nsbgetfl: entry
nsbgetfl: normal exit
nsmal: entry
nsmal: 168 bytes at 0x10027fa20
nsmal: normal exit
nsbal: normal exit
nsiorini: exit (0)
nscpxget: entry
nscpxget: normal exit
nsopenalloc_nsntx: nlhthput on mplx_ht_nsgbu:ctx=280be0, nsntx=2811f0
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 5.
ntt2err: entry
ntt2err: exit
ntctst: size of NTTEST list is 1 - not calling poll
sntpoltst: No of conn to test 1, wait time 60
sntpoltst: fd 5 need 1 readiness events
sntpoltst: exit
nttcni: TImeout or Error on this socket
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt=505, nt=0, nt=0; ora=0, ora=0, ora=0
nsopen: unable to open transport
nsiocancel: entry
nsiofrrg: entry
nsiofrrg: cur = 27f9a8
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=280be0 nsntx=2811f0
nsiocancel: entry
nsiofrrg: entry
nsiofrrg: exit
nsiocancel: exit
nsmfr: entry
nsmfr: 2648 bytes at 0x1002811f0
nsmfr: normal exit
nsmfr: entry
nsmfr: 1528 bytes at 0x100280be0
nsmfr: normal exit
nsopen: error exit
nsmfr: entry
nsmfr: 121 bytes at 0x10027f7e0
nsmfr: normal exit
nscall: error exit
nscall: entry
nscall: connecting...
nsclose: entry
nsclose: normal exit
nladget: entry
nladget: exit
nsmfr: entry
nsmfr: 272 bytes at 0x10016ce80
nsmfr: normal exit
nladtrm: entry
nladtrm: exit
nscall: error exit
nlse_term_audit: entry
nlse_term_audit: exit
================================================================================================
页:
[1]