Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Ora 3113 - Windows Authentication Services? - trace files
System 8.1.7.4 on Windows
A customer is running some old software on 8.1.7.4. (I know this is
ancient, sorry upgrade no option) Monday morning clients got ora-3113
and I cannot find the reason.
Nothing special in alertlog. Instance running fine. Can log on via
svrmgrl. Cannot log on in svrmgrl if using tnsname(Get ORA-3113). So
the problem is only there if logging in via tcp/ip. Listener running
fine. Server has been restarted several times before I was involved.
I suspect problem has something to do with Windows Authentication
Services. SQLNET.AUTHENTICATION_SERVICES = (NTS) is in use.I have
traced listener and sqlnet client and serverside but found nothing
usefull in the tracefiles. I attach trace from listener and sqlnet
server and client.
Can you read something usefull from these? If not what would be the
next step in finding the reason for the ora3113?
CLIENT TRACE
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is C:\oracle\ora81\network\ADMIN\cli.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---
Attempted load of local pfile source C:\oracle\ora81\network\ADMIN
\sqlnet.ora
Parameter source loaded successfully
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_CLIENT = ADMIN
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DEFAULT_DOMAIN = egj.local
--- PARAMETER SOURCE INFORMATION ENDS ---
nigini: entry nigini: Count in NI global area now: 1 nigini: Count in NI global area now: 1 nrigbi: entry nrigbni: entry
niotns: entry niotns: niotns: setting up interrupt handler... niotns: Not trying to enable dead connection detection. niotns: Calling address:
nladini: entry nladini: exit nladget: entry nladget: exit nlpcaini: entry nlpcaini: prg = nlpcaini: arg[0] =
nsopen: opening transport... ntpcon: entry ntpcon: toc = 1
nladtrm: entry nladtrm: exit nioqper: error from nscall nioqper: nr err code: 0 nioqper: ns main err code: 12560 nioqper: ns (2) err code: 0 nioqper: nt main err code: 530 nioqper: nt (2) err code: 126 nioqper: nt OS err code: 0
niqme: entry niqme: reporting NS-12560 error as ORA-12560 niqme: exit
niotns: Couldn't connect, returning 12560 niotns: exit nigtrm: Count in the NI global area is now 0 nrigbd: entry nrigbd: exit nigtrm: Count in the NL global area is now 0
SERVER TRACE
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_SERVER = ADMIN
TRCAE_LEVEL_CLIENT = ADMIN
NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES = (NTS)
--- PARAMETER SOURCE INFORMATION ENDS ---
nigini: entry nigini: Count in NI global area now: 1 nigini: Count in NI global area now: 1 nrigbi: entry nrigbni: entry
niotns: entry niotns: Not enabling dead connection detection. niotns: niotns: LOCAL Connection to (DESCRIPTION=(LOCAL=YES)
nlpcaini: entry nlpcaini: No process parameters set nlpcaini: exit
nsopen: opening transport... ntpcon: entry ntpcon: toc = 6 ntpcon: exit ntpcon: entry ntpcon: toc = 4 sntpinherit: entry sntpinherit: Attempting to make pipe \\.\PIPE\ORANTPF14.B04 sntpinherit: Listening on pipe \\.\PIPE\ORANTPF14.B04sntpinherit: Successfully established pipe 576 to parent sntpinherit: exit
ntpcon: NT layer IPC connection has been established ntpcon: exit nsopen: transport is open
nau_gin: entry nau_gparams: entry nam_gbp: Reading parameter "sqlnet.authentication_required" fromparameter 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: Found 1 items nam_gic: exit nam_gnsp: Reading parameter "sqlnet.authentication_services" fromparameter file
nau_gslf: exit nau_gparams: exit nau_gin: exit
nas_init: entry nas_init: exit nau_ini: entry
nau_gettab: entry nau_tadv: entry nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_tadv: exit nau_gettab: exit nau_sini: entry nau_sini: exit nau_ini: exit
nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file nam_gbp: Parameter not found nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameterfile
naequad: Using default value "ACCEPTED" nam_gic: entry nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER"parameter
naeeinit: exit naecinit: entry nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" fromparameter file
naequad: Using default value "ACCEPTED" nam_gic: entry nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER"parameter
nsnainit: NS Connection version: 310 nsnainit: inf->nsinfflg[0]: 0x21 inf->nsinfflg[1]: 0x21 nsnainit: "or" info flags: 0x21 Translations follow: native service(s) is (are) wanted 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
nsoptions: lcl[0]=0x0, lcl[1]=0x0, gbl[0]=0x0, gbl[1]=0x0, cha=0x0 nsoptions: lcl[0]=0x1fe9ff, lcl[1]=0x0, gbl[0]=0x783f, gbl[1]=0x0 nsopen: global context check-in (to slot 0) complete nsopen: lcl[0]=0x1fe9ff, lcl[1]=0x0, gbl[0]=0x783f, gbl[1]=0x0, tdu=4096, sdu=2048
nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=7, flg=0x4200, mvd=0
nsdo: nsctxrnk=0 nsdo: cid=0, opcode=68, *bl=2048, *what=8, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=14, flg=0x4204, mvd=0 nsdo: gtn=0, gtc=0, ptn=10, ptc=2047 nscon: doing connect handshake...
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 288 bytes sntpread: exit
nsdo: cid=0, opcode=67, *bl=0, *what=9, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=2, flg=0x4204, mvd=0 nsdo: gtn=288, gtc=288, ptn=10, ptc=2047nscon: sending NSPTAC packet
sntpwrite: entry sntpwrite: Attempting to write 32 bytes to 576 sntpwrite: Write returned 32 bytes sntpwrite: exit
nsnainconn: "or" info flags: 0x21 Translations follow: native service(s) is (are) wanted nsnainconn: "or" info flags: 0x21 Translations follow: native service(s) is (are) wanted "and" info flags: 0x21 Translations follow: native service(s) is (are) wanted
naconnect: entry
snauiinit: entry
na_info: entry
nas_version: entry
nas_version: exit
nacomsu: entry
nacomfsd: entry
nacomfsd: exit
nacomdp: entry nacomdp: exit nacomsu: exit
nacomdp: entry nacomdp: exit nacomsu: exit nacomsu: entry
nacomdp: entry nacomdp: exit nacomsu: exit nacomsu: entry
nacomdp: entry nacomdp: exit nacomsu: exit na_info: exit
nsdo: cid=0, opcode=68, *bl=2048, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x2420c, mvd=0 nsdo: gtn=288, gtc=288, ptn=10, ptc=2047nsrdr: recving a packet
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 155 bytes sntpread: exit
nsdo: *what=1, *bl=2048 nsdo: 145 bytes from NS buffer nsdo: nsctxrnk=0 nsnareceive: received 145 bytes
nacomus: entry nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomus: exit nacomus: entry nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomus: exit nacomus: entry nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomus: exit nacomus: entry nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomus: exit nacomrc: exit
na_csrd: entry nas_scn: entry nacomrp: entry nacomrp: exit nacomrp: entry nacomrp: exit
nacomra: entry nacomrp: entry nacomrp: exit nacomra: exit nas_svsl: entry nas_svsl: exit
nacomdp: entry nacomdp: exit nacomsu: exit nacomsa: entry
nacomdp: entry nacomdp: exit nacomsa: exit nas_sval: exit nas_gusl: exit nas_scn: exit nau_scn: entry nau_gpl: entry nau_csl: entry nau_csl: exit nau_grl: entry nau_rsp: entry nau_rsp: exit nau_grl: exit nau_gpl: exit
nau_rpv: entry nacomrp: entry nacomrp: exit nau_rpv: exit nau_sgl: entry nau_srl: entry nacomrp: entry nacomrp: exit
nacomrp: entry nacomrp: exit nacomrp: entry nacomrp: exit
nacomdp: entry nacomdp: exit nacomsu: exit nacomsu: entry
nacomdp: entry nacomdp: exit nacomsu: exit nacomsd: entry
nacomdp: entry nacomdp: exit nacomsd: exit nau_gse: entry nau_fad: entry nau_fad: exit nau_fad: exit
nauninit: entry nauninit: exit nau_tadv: exit nau_tadv: exit nau_gse: exit
nacomdp: entry nacomdp: exit nacomsu: exit nacomsu: entry
nacomdp: entry nacomdp: exit nacomsu: exit
nacomdp: entry nacomdp: exit nacomsu: exit
nau_gsai: exit nau_sgci: exit nau_scn: exit
nacomrp: entry nacomrp: exit nacomrp: entry nacomrp: exit naeshow: entry naeshow: exit nacomsu: entry
nacomdp: entry nacomdp: exit nacomsu: exit
nacomrp: entry nacomrp: exit nacomrp: entry nacomrp: exit naeshow: entry naeshow: exit nacomsu: entry
nacomdp: entry nacomdp: exit nacomsu: exit
na_csrd: exit nacomsn: entry nacomap: entry nacomps: entry nacomps: exit nacomap: exit
nsdo: cid=0, opcode=67, *bl=153, *what=1, uflgs=0x22, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x2420c, mvd=0 nsdo: gtn=155, gtc=155, ptn=10, ptc=2047 nsdo: 153 bytes to NS buffer nsdofls: DATA flags: 0x0
sntpwrite: entry sntpwrite: Attempting to write 163 bytes to 576 sntpwrite: Write returned 163 bytes sntpwrite: exit
nacompd: entry nacompd: exit nacomsn: exit
nacomrc: entry nacompd: entry nacompd: exit
nsdo: cid=0, opcode=68, *bl=2048, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x2420c, mvd=0 nsdo: gtn=155, gtc=155, ptn=10, ptc=2047nsrdr: recving a packet
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 87 bytes sntpread: exit
nsdo: *what=1, *bl=2048 nsdo: 77 bytes from NS buffer nsdo: nsctxrnk=0 nsnareceive: received 77 bytes
nacomus: entry nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomus: exit nacomrc: exit
na_csrd: entry nau_scn: entry nau_rai: entry nacomrp: entry nacomrp: exit nacomrp: entry nacomrp: exit
nau_rai: exit naunval: entry nacomrp: entry nacomrp: exit nacomrp: entry nacomrp: exit nacomsd: entry
nacomdp: entry nacomdp: exit nacomsd: exit nacomsd: entry
nacomdp: entry nacomdp: exit nacomsd: exit naunval: exit nau_scn: exit na_csrd: exit nacomsn: entry nacomap: entry nacomps: entry nacomps: exit nacomap: exit
nsdo: cid=0, opcode=67, *bl=59, *what=1, uflgs=0x22, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x2420c, mvd=0 nsdo: gtn=87, gtc=87, ptn=10, ptc=2047 nsdo: 59 bytes to NS buffer nsdofls: DATA flags: 0x0
sntpwrite: entry sntpwrite: Attempting to write 69 bytes to 576 sntpwrite: Write returned 69 bytes sntpwrite: exit
nacompd: entry nacompd: exit nacomsn: exit
nacomrc: entry nacompd: entry nacompd: exit
nsdo: cid=0, opcode=68, *bl=2048, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x2420c, mvd=0 nsdo: gtn=87, gtc=87, ptn=10, ptc=2047
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 1183 bytes sntpread: exit
nsdo: *what=1, *bl=2048 nsdo: 1173 bytes from NS buffer nsdo: nsctxrnk=0 nsnareceive: received 1173 bytes
nacomus: entry nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomus: exit nacomrc: exit
na_csrd: entry nau_scn: entry naunval: entry nacomrp: entry nacomrp: exit nacomrp: entry nacomrp: exit nacomsd: entry
nacomdp: entry nacomdp: exit nacomsd: exit nacomsd: entry
nacomdp: entry nacomdp: exit nacomsd: exit naunval: exit nau_scn: exit na_csrd: exit nacomsn: entry nacomap: entry nacomps: entry nacomps: exit nacomap: exit
nsdo: cid=0, opcode=67, *bl=166, *what=1, uflgs=0x22, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x2420c, mvd=0 nsdo: gtn=1183, gtc=1183, ptn=10, ptc=2047 nsdo: 166 bytes to NS buffer nsdofls: DATA flags: 0x0
sntpwrite: entry sntpwrite: Attempting to write 176 bytes to 576 sntpwrite: Write returned 176 bytes sntpwrite: exit
nacompd: entry nacompd: exit nacomsn: exit
nacomrc: entry nacompd: entry nacompd: exit
nsdo: cid=0, opcode=68, *bl=2048, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x2420c, mvd=0 nsdo: gtn=1183, gtc=1183, ptn=10, ptc=2047nsrdr: recving a packet
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 80 bytes sntpread: exit
nsprecv: 80 bytes from transport nsprecv: tlen=80, plen=43, type=6 nsprecv: 37 bytes to leftover
nsdo: *what=1, *bl=2048 nsdo: 33 bytes from NS buffer nsdo: nsctxrnk=0 nsnareceive: received 33 bytes
nacomus: entry nacomdp: entry nacomdp: exit nacomdp: entry nacomdp: exit nacomus: exit nacomrc: exit
na_csrd: entry nau_scn: entry naunval: entry naunval: exit nau_scn: exit na_csrd: exit
na_coco: entry nau_cco: entry nau_cco: exit naeecom: entry naeecom: exit naeccom: entry naeccom: exit
na_tns: authentication is active, using NTS na_tns: encryption is not active na_tns: crypto-checksumming is not active na_tns: exit na_coco: exit
nabagmn: entry nabagmn: exit nabaget: entry nau_info: entry nau_info: exit nau_adi: entry
nau_ctl: entry nau_ctl: exit nau_gnm: entry naungun: entry
nsznamefree: entry nsznamefree: exit nsznamefree: entry nsznamefree: exit nsznamefree: entry nsznamefree: exit
nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x420c, mvd=0 nsdo: gtn=43, gtc=43, ptn=10, ptc=2047 nsdo: switching to application buffer
nioqrc: exit nioqsn: entry nioqrc: entry nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3 nsdo: rank=64, nsctxrnk=0
nsdofls: DATA flags: 0x0 nsdofls: sending NSPTDA packet nspsend: plen=145, type=6
sntpwrite: entry sntpwrite: Attempting to write 145 bytes to 576 sntpwrite: Write returned 145 bytes sntpwrite: exit
nsdo: nsctxrnk=0 nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x420c, mvd=0 nsdo: gtn=43, gtc=43, ptn=10, ptc=2047 nsdo: switching to application buffer
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 33 bytes sntpread: exit
nioqrc: exit nioqsn: entry nioqrc: entry nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3 nsdo: rank=64, nsctxrnk=0
nsdofls: DATA flags: 0x0 nsdofls: sending NSPTDA packet nspsend: plen=22, type=6
sntpwrite: entry sntpwrite: Attempting to write 22 bytes to 576 sntpwrite: Write returned 22 bytes sntpwrite: exit
nsdo: nsctxrnk=0 nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x420c, mvd=0 nsdo: gtn=43, gtc=43, ptn=10, ptc=2047 nsdo: switching to application buffer
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 33 bytes sntpread: exit
nioqrc: exit nioqsn: entry nioqrc: entry nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3 nsdo: rank=64, nsctxrnk=0
nsdofls: DATA flags: 0x0 nsdofls: sending NSPTDA packet nspsend: plen=62, type=6
sntpwrite: entry sntpwrite: Attempting to write 62 bytes to 576 sntpwrite: Write returned 62 bytes sntpwrite: exit
nsdo: nsctxrnk=0 nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=8, flg=0x420c, mvd=0 nsdo: gtn=43, gtc=43, ptn=10, ptc=2047 nsdo: switching to application buffer
sntpread: entry sntpread: Attempting to read 2064 bytes from 576 sntpread: Read returned 10 bytes sntpread: exit
nsdo: cid=0, opcode=85, *bl=2037, *what=0, uflgs=0x0, cflgs=0x1 nsdo: nsctx: state=6, flg=0x620c, mvd=0 nsdo: gtn=43, gtc=43, ptn=10, ptc=2047 nsdo: nsctxrnk=0 nioqer: entry nioqce: entry nioqce: exit nioqer: exit nioqrc: exit
nsdo: cid=0, opcode=67, *bl=0, *what=1, uflgs=0x2, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=3, flg=0x420c, mvd=0 nsdo: nsctxrnk=0
nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x40, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=3, flg=0x4208, mvd=0 nsdo: nsctxrnk=0
sntpclose: entry sntpclose: Closing pipe 576 sntpclose: exit
nacomtm: entry nacompd: entry nacompd: exit nacompd: entry nacompd: exit nacomtm: exit nas_dis: entry nas_dis: exit nau_dis: entry
nau_fad: exit nau_dis: exit naeetrm: entry naeetrm: exit naectrm: entry naectrm: exit
nioqds: exit nigtrm: Count in the NI global area is now 0 nsbrfr: nsbfs at 0x221a1f8, data at 0x221de80. nsbrfr: nsbfs at 0x221a1bc, data at 0x221d658. nsbrfr: nsbfs at 0x2219764, data at 0x22186d8. nsbrfr: nsbfs at 0x2218f00, data at 0x2218f3c. nsbrfr: nsbfs at 0x221869c, data at 0x22197a0. nrigbd: entry nrigbd: exit nigtrm: Count in the NL global area is now 0
LISTENER TRACE
TNSLSNR for 32-bit Windows: Version 8.1.7.4.0 - Production on 03-
JUL-2007 11:27:09
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Attempted load of command line source
Parameter source was not loaded
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_LISTENER = ADMIN
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL =
TCP)(HOST = 192.168.***)(PORT = 1521))) (DESCRIPTION = (ADDRESS =
(PROTOCOL = IPC)(KEY = EXTPROC0))) (DESCRIPTION = (ADDRESS = (PROTOCOL
= TCP)(HOST = 192.168.***)(PORT = 2481)) (PROTOCOL_STACK =
(PRESENTATION = GIOP) (SESSION = RAW))))
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (PROGRAM = extproc)
(SID_NAME = HBMS) (ORACLE_HOME = c:\oracle\ora81)) (SID_DESC =
(PROGRAM = extproc) (SID_NAME = TEST) (ORACLE_HOME = c:\oracle\ora81))
(SID_DESC = (PROGRAM = extproc) (SID_NAME = EGJ2007) (ORACLE_HOME = c:
\oracle\ora81)) (SID_DESC = (PROGRAM = extproc) (SID_NAME = EM2007)
(ORACLE_HOME = c:\oracle\ora81)) (SID_DESC = (PROGRAM = extproc)
(SID_NAME = DE2007) (ORACLE_HOME = c:\oracle\ora81)) (SID_DESC =
(GLOBAL_DBNAME = TEST) (ORACLE_HOME = c:\oracle\ora81) (SID_NAME =
TEST)) (SID_DESC = (GLOBAL_DBNAME = EGJ2007) (ORACLE_HOME = c:\oracle
\ora81) (SID_NAME = EGJ2007)) (SID_DESC = (GLOBAL_DBNAME = EM2007)
(ORACLE_HOME = c:\oracle\ora81) (SID_NAME = EM2007)) (SID_DESC =
(GLOBAL_DBNAME = DE2007) (ORACLE_HOME = c:\oracle\ora81) (SID_NAME =
DE2007)))
--- PARAMETER SOURCE INFORMATION ENDS ---
nladini: entry nladini: exit nladget: entry nladget: exit nsgllsn: LSNDSC==>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
nttbnd2addr: entry nttbnd2addr: port resolved to 1521 nttbnd2addr: using host IP address: 192.168.*** nttbnd2addr: exit
nttcon: entry nttcon: toc = 6 nttcnp: entry ntvlin: entry ntvllt: entry ntvllt: No PROTOCOL.ORA file is found ntvllt: exit ntvlin: exit nttcnp: Validnode Table IN use; err 0x0 nttcnp: exit nttcon: exit nsopen: opening transport... nttcon: entry nttcon: toc = 2 nttcnp: entry ntvlin: entry ntvlin: exit nttcnp: Validnode Table IN use; err 0x0 nttcnp: getting sockname nttcnp: exit nttcon: exit nsopen: transport is open
nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=7, flg=0x4202, mvd=0
nsevreg: begin registration process for 0 nsevreg: sgt=0, evn=1, evt[2]=0x0 nsevreg: begin notification process for 0 nsevreg: rdm=0, sgt=0, evt[0]=0x1, [1]=0x1, [2]=0x0, nrg=0 nsevreg: registering for 0x1
nsopen: opening transport... ntnlsn: entry ntnlsn: creating pipe \\.\pipe\NTN_DD4_8DF0C298.ORA ntnlsn: listening on pipe 296 nsopen: transport is open
nsdo: cid=1, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=7, flg=0x4202, mvd=0 nsdo: nsctxrnk=0 nladget: entry
nsopen: opening transport... ntnlsn: entry ntnlsn: creating pipe \\.\pipe\EXTPROC0ipc ntnlsn: listening on pipe 288 nsopen: transport is open
nsdo: cid=2, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=7, flg=0x4202, mvd=0 nsdo: nsctxrnk=0
nsevreg: begin registration process for 2 nsevreg: sgt=0, evn=1, evt[2]=0x0 nsevreg: begin notification process for 2 nsevreg: rdm=0, sgt=0, evt[0]=0x1, [1]=0x1, [2]=0x0, nrg=0 nsevreg: registering for 0x1
nladget: entry nladget: exit nsgllsn: LSNDSC==>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
nttbnd2addr: entry nttbnd2addr: port resolved to 2481 nttbnd2addr: using host IP address: 192.168.*** nttbnd2addr: exit
nsopen: opening transport... nttcon: entry nttcon: toc = 2 nttcnp: entry ntvlin: entry ntvlin: exit nttcnp: Validnode Table IN use; err 0x0 nttcnp: getting sockname nttcnp: exit nttcon: exit nsopen: transport is open
nsdo: cid=3, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=7, flg=0x4202, mvd=0 nsdo: nsctxrnk=0
nsevreg: begin registration process for 3 nsevreg: sgt=0, evn=1, evt[2]=0x0 nsevreg: begin notification process for 3 nsevreg: rdm=0, sgt=0, evt[0]=0x1, [1]=0x1, [2]=0x0, nrg=0 nsevreg: registering for 0x1
nladget: entry nladget: exit nladtrm: entry nladtrm: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsglhcrt: entry nsglhcrt: exit nsglhins: entry nsglhins: exit nsevwait: 3 registered connection(s) nsevwait: 0 added to NT list for 0x8 nsevwait: 2 added to NT list for 0x8 nsevwait: 3 added to NT list for 0x8
CONNECTION REQUEST nsevfnt: cxd: 0x118ebb0 stage 0: NS events set:
INCOMING CALL
nsevwait: event is 0x1, on 0
nsevwait: 1 posted event(s)
nsglhe: entry
nsmal: 420 bytes at 0x1195bb8
nsmal: 1712 bytes at 0x122a300
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. nttcnr: getting sockname nttvlser: entry
nttcnr: exit nttcon: set TCP_NODELAY on 312 nttcon: exit nsopen: transport is open
nau_gin: entry nau_gparams: entry nam_gbp: Reading parameter "sqlnet.authentication_required" fromparameter 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 nam_gic: exit nau_gslf: Using default value "all available adapters"nauss_set_state: entry
nau_gslf: exit nau_gparams: exit nau_gin: exit
nas_init: entry nas_init: exit nau_ini: entry
nau_gettab: entry nau_tadv: entry nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_fad: entry nau_fad: exit nau_tadv: exit nau_gettab: exit nau_sini: entry nau_sini: exit nau_ini: exit
nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file nam_gbp: Parameter not found nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameterfile
naequad: Using default value "ACCEPTED" nam_gic: entry nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER"parameter
naeeinit: exit naecinit: entry nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" fromparameter file
naequad: Using default value "ACCEPTED" nam_gic: entry nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER"parameter
nacomtm: entry nacompd: entry nacompd: exit nacompd: entry nacompd: exit nacomtm: exit nas_dis: entry nas_dis: exit nau_dis: entry nau_fad: exit nau_dis: exit naeetrm: entry naeetrm: exit naectrm: entry naectrm: exit
nsnainit: NS Connection version: 310 nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd nsnainit: "or" info flags: 0xd Translations follow: native service(s) is (are) wanted NA disabled remotely for this connection NA services unavailable on both processes - negotiation not needed nsnainit: "or" info flags: 0xd Translations follow: native service(s) is (are) wanted NA disabled remotely for this connection NA services unavailable on both processes - negotiation not needed "and" info flags: 0xd Translations follow: native service(s) is (are) wanted NA disabled remotely for this connection NA services unavailable on both processes - negotiation not needed
nsopen: global context check-in (to slot 4) complete nsopen: lcl[0]=0x1fefff, lcl[1]=0x12003, gbl[0]=0x783f, gbl[1]=0x2001, tdu=32767, sdu=8192
nsdo: cid=4, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=7, flg=0x4200, mvd=0
nsevreg: begin registration process for 4 nsevreg: sgt=0, evn=1, evt[2]=0x0 nsevreg: begin notification process for 4 nsevreg: rdm=0, sgt=0, evt[0]=0x20, [1]=0x20, [2]=0x0, nrg=0 nsevreg: registering for 0x20
nsevwait: 4 registered connection(s) nsevwait: 0 added to NT list for 0x8 nsevwait: 2 added to NT list for 0x8 nsevwait: 3 added to NT list for 0x8 nsevwait: 4 added to NT list for 0x2 nsevwait: 0 pre-posted event(s) nsevwait: waiting for transport event (0 thru 4)...ntctst: size of NTTEST list is 2 - calling poll ntctspoll: Testing for 3 cxds on protocol select ntctspoll: Testing for 1 cxds on protocol Windows NT Named Pipes NT Protocol Adapter
READ nsevfnt: cxd: 0x118e7b8 stage 5: NS events set:
OUTGOING CALL COMPLETE
nsmal: 44 bytes at 0x118f0b8
nsprecv: reading from transport...
nttrd: entry nttrd: socket 312 had bytes read=226 nttrd: exit nsprecv: 226 bytes from transport
READ nsevfnt: cxd: 0x118e7b8 stage 5: NS events set:
OUTGOING CALL COMPLETE nsevdansw: at STAGE 5
nsdo: cid=4, opcode=68, *bl=2040, *what=8, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=14, flg=0x4204, mvd=0 nsdo: gtn=0, gtc=0, ptn=10, ptc=8191
nsglhe: entry nsglfc: Assume establishing a connection: look for SID nsglfc: command = establish
nlpcaini: entry nlpcaini: prg = nlpcaini: arg[0] = nlpcaini: arg[1] = nlpcaini: exit
sntpcall: Attempting to open pipe \\.\PIPE\ORANTPD8C.DCC sntpcall: Successfully established pipe 332 to child sntpcall: exit
sntpwrite: entry sntpwrite: Attempting to write 4 bytes to 332 sntpwrite: Write returned 4 bytes sntpwrite: exit
sntpwrite: entry sntpwrite: Attempting to write 65 bytes to 332 sntpwrite: Write returned 65 bytes sntpwrite: exit
sntpwrite: entry sntpwrite: Attempting to write 4 bytes to 332 sntpwrite: Write returned 4 bytes sntpwrite: exit
sntpread: entry sntpread: Attempting to read 4 bytes from 332 sntpread: Read returned 4 bytes sntpread: exit
sntpread: entry sntpread: Attempting to read 56 bytes from 332 sntpread: Read returned 56 bytes sntpread: exit
sntpclose: entry sntpclose: Closing pipe 332 sntpclose: exit
nsdo: cid=4, opcode=67, *bl=56, *what=11, uflgs=0x0, cflgs=0x3 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=2, flg=0x4204, mvd=0 nsdo: gtn=226, gtc=226, ptn=10, ptc=2047nscon: sending NSPTRD packet
nttwr: entry nttwr: socket 312 had bytes written=66 nttwr: exit
nsdo: cid=4, opcode=66, *bl=0, *what=0, uflgs=0x0, cflgs=0x2 nsdo: rank=64, nsctxrnk=0 nsdo: nsctx: state=2, flg=0x4200, mvd=0
nsclose: closing transport nttdisc: entry nttdisc: Closed socket 312 nttdisc: exit nsclose: global context check-out (from slot 4) completensmfr: 1712 bytes at 0x122a300
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]tnslsnr: exit
nsevwait: 3 registered connection(s) nsevwait: 0 added to NT list for 0x8 nsevwait: 2 added to NT list for 0x8 nsevwait: 3 added to NT list for 0x8 nsevwait: 0 pre-posted event(s) nsevwait: waiting for transport event (0 thru 3)...ntctst: size of NTTEST list is 2 - calling poll ntctspoll: Testing for 2 cxds on protocol select ntctspoll: Testing for 1 cxds on protocol Windows NT Named Pipes NT Protocol Adapter
TIA
Peter Laursen
Received on Tue Jul 03 2007 - 06:39:27 CDT
![]() |
![]() |