- 论坛徽章:
- 0
|
数据库的连接问题，出现错误ORA-12535: TNS: 操作超时
tnsping OK;
TRACE:
[02-12月-2004 09]
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[02-12月-2004 09] New trace stream is d:\oracle\ora92\network\admin\tracelog.txt_1676.trc
[02-12月-2004 09] New trace level is 6
[02-12月-2004 09] --- TRACE CONFIGURATION INFORMATION ENDS ---
[02-12月-2004 09]
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
[02-12月-2004 09] Attempted load of system pfile source d:\oracle\ora92\network\admin\sqlnet.ora
[02-12月-2004 09] Parameter source loaded successfully
[02-12月-2004 09]
[02-12月-2004 09] Attempted load of local pfile source d:\oracle\ora92\bin\sqlnet.ora
[02-12月-2004 09] Parameter source was not loaded
[02-12月-2004 09]
[02-12月-2004 09] ->; PARAMETER TABLE LOAD RESULTS FOLLOW <-
[02-12月-2004 09] Successful parameter table load
[02-12月-2004 09] ->; PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
[02-12月-2004 09] TRACE_LEVEL_SERVER = ADMIN
[02-12月-2004 09] TRACE_DIRECTORY_CLIENT = d:\oracle\ora92\network\admin
[02-12月-2004 09] NAMES.DIRECTORY_PATH = (HOSTNAME, TNSNAMES, ONAMES)
[02-12月-2004 09] TRACE_FILE_CLIENT = tracelog.txt
[02-12月-2004 09] SQLNET.AUTHENTICATION_SERVICES = (NTS)
[02-12月-2004 09] TRACE_UNIQUE_CLIENT = on
[02-12月-2004 09] TRACE_LEVEL_CLIENT = ADMIN
[02-12月-2004 09] --- PARAMETER SOURCE INFORMATION ENDS ---
[02-12月-2004 09]
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
[02-12月-2004 09] Log stream will be "d:\oracle\ora92\bin\sqlnet.log"
[02-12月-2004 09] Log stream validation not requested
[02-12月-2004 09] --- LOG CONFIGURATION INFORMATION ENDS ---
[02-12月-2004 09] nigini: entry
[02-12月-2004 09] nigini: Count in NI global area now: 1
[02-12月-2004 09] nigini: Count in NI global area now: 1
[02-12月-2004 09] nrigbi: entry
[02-12月-2004 09] nrigbni: entry
[02-12月-2004 09] nrigbni: Unable to get data from navigation file tnsnav.ora
[02-12月-2004 09] nrigbni: exit
[02-12月-2004 09] nrigbi: exit
[02-12月-2004 09] nigini: exit
[02-12月-2004 09] niqname: Hst is already an NVstring.
[02-12月-2004 09] niqname: Inserting CID.
[02-12月-2004 09] niotns: entry
[02-12月-2004 09] niotns: niotns: setting up interrupt handler...
[02-12月-2004 09] niotns: Not trying to enable dead connection detection.
[02-12月-2004 09] niotns: Calling address: (DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.31.173)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=Ora92)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=IPRD_NIEXY)(USER=Administrator))))
[02-12月-2004 09] nsmal: 164 bytes at 0x5755390
[02-12月-2004 09] nscall: connecting...
[02-12月-2004 09] nladini: entry
[02-12月-2004 09] nladini: exit
[02-12月-2004 09] nladget: entry
[02-12月-2004 09] nladget: exit
[02-12月-2004 09] nttbnd2addr: entry
[02-12月-2004 09] nttgetport: entry
[02-12月-2004 09] nttgetport: port resolved to 1521
[02-12月-2004 09] nttgetport: exit
[02-12月-2004 09] nttbnd2addr: using host IP address: 172.16.31.173
[02-12月-2004 09] nttbnd2addr: exit
[02-12月-2004 09] nsmal: 492 bytes at 0x2ea18a0
[02-12月-2004 09] nsmal: 2348 bytes at 0x57b7008
[02-12月-2004 09] nsopen: opening transport...
[02-12月-2004 09] nttcon: entry
[02-12月-2004 09] nttcon: toc = 1
[02-12月-2004 09] nttcnp: entry
[02-12月-2004 09] ntvlin: entry
[02-12月-2004 09] ntvllt: entry
[02-12月-2004 09] ntvllt: tcp.validnode_checking not turned on
[02-12月-2004 09] ntvllt: exit
[02-12月-2004 09] ntvlin: exit
[02-12月-2004 09] nttcnp: Validnode Table IN use; err 0x0
[02-12月-2004 09] nttcnp: exit
[02-12月-2004 09] nttcni: entry
[02-12月-2004 09] nttcni: trying to connect to socket 1548.
[02-12月-2004 09] nttcni: connected on ipaddr 172.16.31.105
[02-12月-2004 09] nttcni: exit
[02-12月-2004 09] nttcon: set TCP_NODELAY on 1548
[02-12月-2004 09] nttcon: exit
[02-12月-2004 09] nsopen: transport is open
[02-12月-2004 09] nsnainit: call
[02-12月-2004 09] nainit: entry
[02-12月-2004 09] nagblini: entry
[02-12月-2004 09] nau_gin: entry
[02-12月-2004 09] nau_gparams: entry
[02-12月-2004 09] nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
[02-12月-2004 09] nam_gbp: Parameter not found
[02-12月-2004 09] nau_gparams: Using default value "FALSE"
[02-12月-2004 09] nau_gslf: entry
[02-12月-2004 09] nam_gic: entry
[02-12月-2004 09] nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
[02-12月-2004 09] nam_gic: Found 1 items
[02-12月-2004 09] nam_gic: exit
[02-12月-2004 09] nam_gnsp: Reading parameter "sqlnet.authentication_services" from parameter file
[02-12月-2004 09] nam_gnsp: Found value "NTS"
[02-12月-2004 09] nauss_set_state: entry
[02-12月-2004 09] nauss_set_state: exit
[02-12月-2004 09] nau_gslf: exit
[02-12月-2004 09] nau_gparams: exit
[02-12月-2004 09] nau_gin: exit
[02-12月-2004 09] nagblini: exit
[02-12月-2004 09] na_saveprot: entry
[02-12月-2004 09] na_saveprot: exit
[02-12月-2004 09] nacomin: entry
[02-12月-2004 09] nas_init: entry
[02-12月-2004 09] nas_init: exit
[02-12月-2004 09] nau_ini: entry
[02-12月-2004 09] naugcp_get_connect_parameters: entry
[02-12月-2004 09] nauss_set_state: entry
[02-12月-2004 09] nauss_set_state: exit
[02-12月-2004 09] naugcp_get_connect_parameters: exit
[02-12月-2004 09] nau_gettab: entry
[02-12月-2004 09] nau_tadv: entry
[02-12月-2004 09] nau_fad: entry
[02-12月-2004 09] nau_fad: exit
[02-12月-2004 09] nau_fad: entry
[02-12月-2004 09] nau_fad: exit
[02-12月-2004 09] nau_fad: entry
[02-12月-2004 09] nau_fad: exit
[02-12月-2004 09] nau_fad: entry
[02-12月-2004 09] nau_fad: exit
[02-12月-2004 09] nau_tadv: exit
[02-12月-2004 09] nau_gettab: exit
[02-12月-2004 09] nau_sini: entry
[02-12月-2004 09] nau_sini: exit
[02-12月-2004 09] nau_ini: exit
[02-12月-2004 09] naeeinit: entry
[02-12月-2004 09] nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
[02-12月-2004 09] nam_gbp: Parameter not found
[02-12月-2004 09] nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_CLIENT" from parameter file
[02-12月-2004 09] nam_gnsp: Parameter not found
[02-12月-2004 09] naequad: Using default value "ACCEPTED"
[02-12月-2004 09] nam_gic: entry
[02-12月-2004 09] nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_CLIENT" parameter
[02-12月-2004 09] nam_gic: Parameter not found
[02-12月-2004 09] nam_gic: exit
[02-12月-2004 09] naesno: Using default value "all available algorithms"
[02-12月-2004 09] naeshow: entry
[02-12月-2004 09] naeshow: exit
[02-12月-2004 09] naeeinit: exit
[02-12月-2004 09] naecinit: entry
[02-12月-2004 09] nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_CLIENT" from parameter file
[02-12月-2004 09] nam_gnsp: Parameter not found
[02-12月-2004 09] naequad: Using default value "ACCEPTED"
[02-12月-2004 09] nam_gic: entry
[02-12月-2004 09] nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT" parameter
[02-12月-2004 09] nam_gic: Parameter not found
[02-12月-2004 09] nam_gic: exit
[02-12月-2004 09] naesno: Using default value "all available algorithms"
[02-12月-2004 09] naeshow: entry
[02-12月-2004 09] naeshow: exit
[02-12月-2004 09] naecinit: exit
[02-12月-2004 09] nainit: exit
[02-12月-2004 09] nagetctxinfo: entry
[02-12月-2004 09] nagetctxinfo: exit
[02-12月-2004 09] nsnainit: NS Connection version: 312
[02-12月-2004 09] nsnainit: inf->;nsinfflg[0]: 0x21 inf->;nsinfflg[1]: 0x21
[02-12月-2004 09] nsnainit: "or" info flags: 0x21 Translations follow:
native service(s) is (are) wanted
[02-12月-2004 09] nsnainit: "or" info flags: 0x21 Translations follow:
native service(s) is (are) wanted
"and" info flags: 0x21 Translations follow:
native service(s) is (are) wanted
[02-12月-2004 09] nsoptions: lcl[0]=0x0, lcl[1]=0x100000, gbl[0]=0x0, gbl[1]=0x0, cha=0x0
[02-12月-2004 09] nsoptions: lcl[0]=0xffefff, lcl[1]=0x100000, gbl[0]=0xfe3f, gbl[1]=0x0
[02-12月-2004 09] nsopen: global context check-in (to slot 0) complete
[02-12月-2004 09] nsopen: lcl[0]=0xffefff, lcl[1]=0x100000, gbl[0]=0xfe3f, gbl[1]=0x0, tdu=32767, sdu=2048
[02-12月-2004 09] nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
[02-12月-2004 09] nsdo: rank=64, nsctxrnk=0
[02-12月-2004 09] nsdo: nsctx: state=7, flg=0x4201, mvd=0
[02-12月-2004 09] nsmal: 48 bytes at 0x2efeb98
[02-12月-2004 09] nsmal: 48 bytes at 0x57b8cc8
[02-12月-2004 09] nlidg8: entry
[02-12月-2004 09] nlidg8: exit
[02-12月-2004 09] nsdo: nsctxrnk=0
[02-12月-2004 09] nsdo: cid=0, opcode=67, *bl=239, *what=8, uflgs=0x0, cflgs=0x3
[02-12月-2004 09] nsdo: rank=64, nsctxrnk=0
[02-12月-2004 09] nsdo: nsctx: state=14, flg=0x4205, mvd=0
[02-12月-2004 09] nsdo: gtn=0, gtc=0, ptn=10, ptc=2047
[02-12月-2004 09] nscon: doing connect handshake...
[02-12月-2004 09] nscon: sending NSPTCN packet
[02-12月-2004 09] nspsend: plen=58, type=1
[02-12月-2004 09] nttwr: entry
[02-12月-2004 09] nttwr: socket 1548 had bytes written=58
[02-12月-2004 09] nttwr: exit
[02-12月-2004 09] nspsend: 58 bytes to transport
[02-12月-2004 09] nscon: sending 239 bytes connect data
[02-12月-2004 09] nsdo: cid=0, opcode=67, *bl=239, *what=1, uflgs=0x4002, cflgs=0x0
[02-12月-2004 09] nsdo: nsctx: state=2, flg=0x4205, mvd=0
[02-12月-2004 09] nsdo: gtn=0, gtc=0, ptn=10, ptc=511
[02-12月-2004 09] nsdo: 239 bytes to NS buffer
[02-12月-2004 09] nsdofls: DATA flags: 0x0
[02-12月-2004 09] nsdofls: sending NSPTDA packet
[02-12月-2004 09] nspsend: plen=249, type=6
[02-12月-2004 09] nttwr: entry
[02-12月-2004 09] nttwr: socket 1548 had bytes written=249
[02-12月-2004 09] nttwr: exit
[02-12月-2004 09] nspsend: 249 bytes to transport
[02-12月-2004 09] nsdoacts: flushing transport
[02-12月-2004 09] nttctl: entry
[02-12月-2004 09] nsdo: nsctxrnk=0
[02-12月-2004 09] nsdo: cid=0, opcode=68, *bl=512, *what=9, uflgs=0x0, cflgs=0x3
[02-12月-2004 09] nsdo: rank=64, nsctxrnk=0
[02-12月-2004 09] nsdo: nsctx: state=2, flg=0x4205, mvd=0
[02-12月-2004 09] nsdo: gtn=0, gtc=0, ptn=10, ptc=2047
[02-12月-2004 09] nscon: recving a packet
[02-12月-2004 09] nsmal: 48 bytes at 0x57b8d00
[02-12月-2004 09] nsprecv: reading from transport...
[02-12月-2004 09] nttrd: entry
[02-12月-2004 09] nttrd: socket 1548 had bytes read=65
[02-12月-2004 09] nttrd: exit
[02-12月-2004 09] nsprecv: 65 bytes from transport
[02-12月-2004 09] nsprecv: tlen=65, plen=65, type=5
[02-12月-2004 09] nscon: got NSPTRD packet
[02-12月-2004 09] nscon: got 55 bytes connect data
[02-12月-2004 09] nsdo: nsctxrnk=0
[02-12月-2004 09] nscall: redirected
[02-12月-2004 09] nstimarmed: no timer allocated
[02-12月-2004 09] nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x440, cflgs=0x2
[02-12月-2004 09] nsdo: rank=64, nsctxrnk=0
[02-12月-2004 09] nsdo: nsctx: state=3, flg=0x4201, mvd=0
[02-12月-2004 09] nsdo: nsctxrnk=0
[02-12月-2004 09] nsclose: closing transport
[02-12月-2004 09] nttdisc: entry
[02-12月-2004 09] nttdisc: Closed socket 1548
[02-12月-2004 09] nttdisc: exit
[02-12月-2004 09] nsclose: global context check-out (from slot 0) complete
[02-12月-2004 09] nadisc: entry
[02-12月-2004 09] nacomtm: entry
[02-12月-2004 09] nacompd: entry
[02-12月-2004 09] nacompd: exit
[02-12月-2004 09] nacompd: entry
[02-12月-2004 09] nacompd: exit
[02-12月-2004 09] nacomtm: exit
[02-12月-2004 09] nas_dis: entry
[02-12月-2004 09] nas_dis: exit
[02-12月-2004 09] nau_dis: entry
[02-12月-2004 09] nau_fad: exit
[02-12月-2004 09] nau_dis: exit
[02-12月-2004 09] naeetrm: entry
[02-12月-2004 09] naeetrm: exit
[02-12月-2004 09] naectrm: entry
[02-12月-2004 09] naectrm: exit
[02-12月-2004 09] nagbltrm: entry
[02-12月-2004 09] nau_gtm: entry
[02-12月-2004 09] nau_gtm: exit
[02-12月-2004 09] nagbltrm: exit
[02-12月-2004 09] nadisc: exit
[02-12月-2004 09] nsmfr: 2348 bytes at 0x57b7008
[02-12月-2004 09] nsmfr: 492 bytes at 0x2ea18a0
[02-12月-2004 09] nscall: connecting...
[02-12月-2004 09] nttbnd2addr: entry
[02-12月-2004 09] nttgetport: entry
[02-12月-2004 09] nttgetport: port resolved to 2131
[02-12月-2004 09] nttgetport: exit
[02-12月-2004 09] nttbnd2addr: using host IP address: 172.16.31.173
[02-12月-2004 09] nttbnd2addr: exit
[02-12月-2004 09] nsmal: 492 bytes at 0x2ea18a0
[02-12月-2004 09] nsmal: 2348 bytes at 0x57b7008
[02-12月-2004 09] nsopen: opening transport...
[02-12月-2004 09] nttcon: entry
[02-12月-2004 09] nttcon: toc = 1
[02-12月-2004 09] nttcnp: entry
[02-12月-2004 09] ntvlin: entry
[02-12月-2004 09] ntvlin: exit
[02-12月-2004 09] nttcnp: Validnode Table IN use; err 0x0
[02-12月-2004 09] nttcnp: exit
[02-12月-2004 09] nttcni: entry
[02-12月-2004 09] nttcni: trying to connect to socket 1560.
[02-12月-2004 09] ntt2err: entry
[02-12月-2004 09] ntt2err: soc 1560 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
[02-12月-2004 09] ntt2err: exit
[02-12月-2004 09] nttcni: exit
[02-12月-2004 09] nttcon: exit
[02-12月-2004 09] 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
[02-12月-2004 09] nsopen: unable to open transport
[02-12月-2004 09] nsmfr: 2348 bytes at 0x57b7008
[02-12月-2004 09] nsmfr: 492 bytes at 0x2ea18a0
[02-12月-2004 09] nsmfr: 239 bytes at 0x2d16708
[02-12月-2004 09] nsmfr: 164 bytes at 0x5755390
[02-12月-2004 09] nladtrm: entry
[02-12月-2004 09] nladtrm: exit
[02-12月-2004 09] nioqper: error from nscall
[02-12月-2004 09] nioqper: nr err code: 0
[02-12月-2004 09] nioqper: ns main err code: 12535
[02-12月-2004 09] nioqper: ns (2) err code: 12560
[02-12月-2004 09] nioqper: nt main err code: 505
[02-12月-2004 09] nioqper: nt (2) err code: 60
[02-12月-2004 09] nioqper: nt OS err code: 0
[02-12月-2004 09] niomapnserror: entry
[02-12月-2004 09] niqme: entry
[02-12月-2004 09] niqme: reporting NS-12535 error as ORA-12535
[02-12月-2004 09] niqme: exit
[02-12月-2004 09] niomapnserror: returning error 12535
[02-12月-2004 09] niomapnserror: exit
[02-12月-2004 09] niotns: Couldn't connect, returning 12535
[02-12月-2004 09] niotns: exit
[02-12月-2004 09] nsbrfr: nsbfs at 0x57b8d00, data at 0x57e5a80.
[02-12月-2004 09] nsbrfr: nsbfs at 0x57b8cc8, data at 0x57e62a8.
[02-12月-2004 09] nsbrfr: nsbfs at 0x2efeb98, data at 0x57e6ad0.
[02-12月-2004 09] nigtrm: Count in the NI global area is now 0
[02-12月-2004 09] nrigbd: entry
[02-12月-2004 09] nrigbd: exit
[02-12月-2004 09] nigtrm: Count in the NL global area is now 0 |
|
免费注册
发表于 2004-12-01 16:12
