Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i TNS Listener Problem
Hi
I have got a next problem with TNS Listener.
I have two servers in LAN. When I connect to remote server by SQL
Navigator, Oracle Enterprise Manager - all is ok.
When I connect to my local server - connection established, by TNS
Listener crashes with Application Error:
"The instruction at "0x61915732" referenced memory at "0x00000578". The memory could not be "read"".
Below are fragments of log and trace files. Thanks ahead for any idea, how to cope with this problem.
Fragment of listener.log during connect and crash:
System parameter file is E:\oracle\ora92\network\admin\listener.ora Log messages written to E:\oracle\ora92\network\log\listener.log Trace information written to E:\oracle\ora92\network\trace\listener.trc Trace level is currently 16
Started with pid=2140
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=boston.softservecom.com)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
25-NOV-2003 19:00:51 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=INVERTIX.SOFTSERVECOM.COM)(CID=(PROGRAM=D:\Program
Files\Quest Software\SQL Navigator
4\SQLNav4.exe)(HOST=BOSTON)(USER=sbryt))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.19)(PORT=3014)) * establish *
INVERTIX.SOFTSERVECOM.COM * 0
Fragment of listener.trc:
CONNECTION REQUEST
[25-NOV-2003 19:03:15:656] nsevfnt: cxd: 0xe9f830 stage 0: NS events set:
INCOMING CALL
[25-NOV-2003 19:03:15:656] nsevwait: event is 0x1, on 0
[25-NOV-2003 19:03:15:656] nsevwait: 1 posted event(s)
[25-NOV-2003 19:03:15:656] nsevwait: exit (0)
[25-NOV-2003 19:03:15:656] nsglhe: entry
[25-NOV-2003 19:03:15:656] nsglhe: Event on cxd 0xe9f830.
[25-NOV-2003 19:03:15:656] nsglhc: Allocating cxd 0xe9f578
[25-NOV-2003 19:03:15:656] nsanswer: entry
[25-NOV-2003 19:03:15:656] nsopen: entry
[25-NOV-2003 19:03:15:656] nsmal: entry
[25-NOV-2003 19:03:15:656] nsmal: 492 bytes at 0xea8ae8
[25-NOV-2003 19:03:15:656] nsmal: normal exit
[25-NOV-2003 19:03:15:656] nsopenmplx: entry
[25-NOV-2003 19:03:15:656] nsmal: entry
[25-NOV-2003 19:03:15:656] nsmal: 2348 bytes at 0xeb68b8
[25-NOV-2003 19:03:15:656] nsmal: normal exit
[25-NOV-2003 19:03:15:656] nsopenmplx: normal exit
[25-NOV-2003 19:03:15:656] nsopen: opening transport...
[25-NOV-2003 19:03:15:656] nttcon: entry
[25-NOV-2003 19:03:15:656] nttcon: toc = 3
[25-NOV-2003 19:03:15:656] nttcnp: entry
[25-NOV-2003 19:03:15:656] ntvlin: entry
[25-NOV-2003 19:03:15:656] ntvlin: exit
[25-NOV-2003 19:03:15:656] nttcnp: Validnode Table IN use; err 0x0
[25-NOV-2003 19:03:15:656] nttcnp: getting sockname
[25-NOV-2003 19:03:15:656] nttcnp: exit
[25-NOV-2003 19:03:15:656] nttcnr: entry
[25-NOV-2003 19:03:15:656] nttcnr: waiting to accept a connection.
[25-NOV-2003 19:03:15:656] nttcnr: getting sockname
[25-NOV-2003 19:03:15:656] nttcnr: connected on ipaddr 192.168.8.19
[25-NOV-2003 19:03:15:656] nttvlser: entry
[25-NOV-2003 19:03:15:656] nttvlser: valid node check on incoming node
192.168.8.19
[25-NOV-2003 19:03:15:656] nttvlser: Accepted Entry: 192.168.8.19
[25-NOV-2003 19:03:15:656] nttcnr: exit
[25-NOV-2003 19:03:15:656] nttcon: NT layer TCP/IP connection has been
established.
[25-NOV-2003 19:03:15:656] nttcon: set TCP_NODELAY on 468
[25-NOV-2003 19:03:15:656] nttcon: exit
[25-NOV-2003 19:03:15:656] nsrah: entry
[25-NOV-2003 19:03:15:656] nserror: entry
[25-NOV-2003 19:03:15:656] nserror: nsres: id=0, op=78, ns=12612, ns2=0;
nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[25-NOV-2003 19:03:15:656] nsrah: exit (-1)
[25-NOV-2003 19:03:15:656] nsopen: transport is open
[25-NOV-2003 19:03:15:656] nsnainit: entry
[25-NOV-2003 19:03:15:656] nsnainit: answer
[25-NOV-2003 19:03:15:656] nsnadct: entry
[25-NOV-2003 19:03:15:656] nsnadct: normal exit
[25-NOV-2003 19:03:15:656] nsnasvnainfo: entry
[25-NOV-2003 19:03:15:656] nsnasvnainfo: NA disabled for this connection
[25-NOV-2003 19:03:15:656] nsnasvnainfo: normal exit
[25-NOV-2003 19:03:15:656] nainit: entry
[25-NOV-2003 19:03:15:656] nagblini: entry
[25-NOV-2003 19:03:15:656] nau_gin: entry
[25-NOV-2003 19:03:15:656] nau_gparams: entry
[25-NOV-2003 19:03:15:656] nam_gbp: Reading parameter
"sqlnet.authentication_required" from parameter file
[25-NOV-2003 19:03:15:656] nam_gbp: Parameter not found
[25-NOV-2003 19:03:15:656] nau_gparams: Using default value "FALSE"
[25-NOV-2003 19:03:15:656] nau_gslf: entry
[25-NOV-2003 19:03:15:656] nam_gic: entry
[25-NOV-2003 19:03:15:656] nam_gic: Counting # of items in
"sqlnet.authentication_services" parameter
[25-NOV-2003 19:03:15:656] nam_gic: Parameter not found
[25-NOV-2003 19:03:15:656] nam_gic: Found 0 items
[25-NOV-2003 19:03:15:656] nam_gic: exit
[25-NOV-2003 19:03:15:656] nau_gslf: Using default value "all available
adapters"
[25-NOV-2003 19:03:15:656] nauss_set_state: entry
[25-NOV-2003 19:03:15:656] nauss_set_state: exit
[25-NOV-2003 19:03:15:656] nau_gslf: exit
[25-NOV-2003 19:03:15:656] nau_gparams: exit
[25-NOV-2003 19:03:15:656] nau_gin: exit
[25-NOV-2003 19:03:15:656] nagblini: exit
[25-NOV-2003 19:03:15:656] na_saveprot: entry
[25-NOV-2003 19:03:15:656] na_saveprot: exit
[25-NOV-2003 19:03:15:656] nacomin: entry
[25-NOV-2003 19:03:15:656] nas_init: entry
[25-NOV-2003 19:03:15:656] nas_init: exit
[25-NOV-2003 19:03:15:656] nau_ini: entry
[25-NOV-2003 19:03:15:656] naugcp_get_connect_parameters: entry
[25-NOV-2003 19:03:15:656] nauss_set_state: entry
[25-NOV-2003 19:03:15:656] nauss_set_state: exit
[25-NOV-2003 19:03:15:656] naugcp_get_connect_parameters: exit
[25-NOV-2003 19:03:15:656] nau_gettab: entry
[25-NOV-2003 19:03:15:656] nau_tadv: entry
[25-NOV-2003 19:03:15:656] nau_fad: entry
[25-NOV-2003 19:03:15:656] nau_fad: exit
[25-NOV-2003 19:03:15:656] nau_fad: entry
[25-NOV-2003 19:03:15:656] nau_fad: exit
[25-NOV-2003 19:03:15:656] nau_fad: entry
[25-NOV-2003 19:03:15:656] nau_fad: exit
[25-NOV-2003 19:03:15:656] nau_fad: entry
[25-NOV-2003 19:03:15:656] nau_fad: exit
[25-NOV-2003 19:03:15:656] nau_tadv: All entries in table are valid
[25-NOV-2003 19:03:15:656] nau_tadv: exit
[25-NOV-2003 19:03:15:656] nau_gettab: using authentication adapter
table "nautab"
[25-NOV-2003 19:03:15:656] nau_gettab: nautab contains the following
services:
[25-NOV-2003 19:03:15:656] nau_gettab: KERBEROS5
[25-NOV-2003 19:03:15:656] nau_gettab: CYBERSAFE
[25-NOV-2003 19:03:15:656] nau_gettab: NTS
[25-NOV-2003 19:03:15:656] nau_gettab: RADIUS
[25-NOV-2003 19:03:15:656] nau_gettab: exit
[25-NOV-2003 19:03:15:656] nau_sini: entry
[25-NOV-2003 19:03:15:656] nau_sini: exit
[25-NOV-2003 19:03:15:656] nau_ini: connection type: "standard"
[25-NOV-2003 19:03:15:656] nau_ini: exit
[25-NOV-2003 19:03:15:656] naeeinit: entry
[25-NOV-2003 19:03:15:656] nam_gbp: Reading parameter "SQLNET.FIPS_140"
from parameter file
[25-NOV-2003 19:03:15:666] nam_gbp: Parameter not found
[25-NOV-2003 19:03:15:666] nam_gnsp: Reading parameter
"SQLNET.ENCRYPTION_SERVER" from parameter file
[25-NOV-2003 19:03:15:666] nam_gnsp: Parameter not found
[25-NOV-2003 19:03:15:666] naequad: Using default value "ACCEPTED"
[25-NOV-2003 19:03:15:666] nam_gic: entry
[25-NOV-2003 19:03:15:666] nam_gic: Counting # of items in
"SQLNET.ENCRYPTION_TYPES_SERVER" parameter
[25-NOV-2003 19:03:15:666] nam_gic: Parameter not found
[25-NOV-2003 19:03:15:666] nam_gic: exit
[25-NOV-2003 19:03:15:666] naesno: Using default value "all available
algorithms"
[25-NOV-2003 19:03:15:666] naeshow: entry
[25-NOV-2003 19:03:15:666] naeshow: These are the encryption algorithms
that the server will accept, in decreasing order of preference:
[25-NOV-2003 19:03:15:666] naeshow: Choice 0: no algorithm; encryption
inactive
[25-NOV-2003 19:03:15:666] naeshow: Choice 1: 'AES256' (ID 17)
[25-NOV-2003 19:03:15:666] naeshow: Choice 2: 'RC4_256' (ID 6)
[25-NOV-2003 19:03:15:666] naeshow: Choice 3: 'AES192' (ID 16)
[25-NOV-2003 19:03:15:666] naeshow: Choice 4: '3DES168' (ID 12)
[25-NOV-2003 19:03:15:666] naeshow: Choice 5: 'AES128' (ID 15)
[25-NOV-2003 19:03:15:666] naeshow: Choice 6: 'RC4_128' (ID 10)
[25-NOV-2003 19:03:15:666] naeshow: Choice 7: '3DES112' (ID 11)
[25-NOV-2003 19:03:15:666] naeshow: Choice 8: 'RC4_56' (ID 8)
[25-NOV-2003 19:03:15:666] naeshow: Choice 9: 'DES' (ID 2)
[25-NOV-2003 19:03:15:666] naeshow: Choice 10: 'RC4_40' (ID 1)
[25-NOV-2003 19:03:15:666] naeshow: Choice 11: 'DES40' (ID 3)
[25-NOV-2003 19:03:15:666] naeshow: exit
[25-NOV-2003 19:03:15:666] naeeinit: exit
[25-NOV-2003 19:03:15:666] naecinit: entry
[25-NOV-2003 19:03:15:666] nam_gnsp: Reading parameter
"SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file
[25-NOV-2003 19:03:15:666] nam_gnsp: Parameter not found
[25-NOV-2003 19:03:15:666] naequad: Using default value "ACCEPTED"
[25-NOV-2003 19:03:15:666] nam_gic: entry
[25-NOV-2003 19:03:15:666] nam_gic: Counting # of items in
"SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter
[25-NOV-2003 19:03:15:666] nam_gic: Parameter not found
[25-NOV-2003 19:03:15:666] nam_gic: exit
[25-NOV-2003 19:03:15:666] naesno: Using default value "all available
algorithms"
[25-NOV-2003 19:03:15:666] naeshow: entry
[25-NOV-2003 19:03:15:666] naeshow: These are the checksumming
algorithms that the server will accept, in decreasing order of preference:
[25-NOV-2003 19:03:15:666] naeshow: Choice 0: no algorithm; checksumming
inactive
[25-NOV-2003 19:03:15:666] naeshow: Choice 1: 'SHA1' (ID 3)
[25-NOV-2003 19:03:15:666] naeshow: Choice 2: 'MD5' (ID 1)
[25-NOV-2003 19:03:15:666] naeshow: exit
[25-NOV-2003 19:03:15:666] naecinit: exit
[25-NOV-2003 19:03:15:666] nainit: native services disabled - disconnecting
[25-NOV-2003 19:03:15:666] nadisc: entry
[25-NOV-2003 19:03:15:666] nacomtm: entry
[25-NOV-2003 19:03:15:666] nacompd: entry
[25-NOV-2003 19:03:15:666] nacompd: exit
[25-NOV-2003 19:03:15:666] nacompd: entry
[25-NOV-2003 19:03:15:666] nacompd: exit
[25-NOV-2003 19:03:15:666] nacomtm: exit
[25-NOV-2003 19:03:15:666] nas_dis: entry
[25-NOV-2003 19:03:15:666] nas_dis: exit
[25-NOV-2003 19:03:15:666] nau_dis: entry
[25-NOV-2003 19:03:15:666] nau_fad: exit
[25-NOV-2003 19:03:15:666] nau_dis: exit
[25-NOV-2003 19:03:15:666] naeetrm: entry
[25-NOV-2003 19:03:15:666] naeetrm: exit
[25-NOV-2003 19:03:15:666] naectrm: entry
[25-NOV-2003 19:03:15:666] naectrm: exit
[25-NOV-2003 19:03:15:666] nagbltrm: entry
[25-NOV-2003 19:03:15:666] nau_gtm: entry
[25-NOV-2003 19:03:15:666] nau_gtm: exit
[25-NOV-2003 19:03:15:666] nagbltrm: exit
[25-NOV-2003 19:03:15:666] nadisc: exit
[25-NOV-2003 19:03:15:666] nainit: exit
[25-NOV-2003 19:03:15:666] nsnainit: NS Connection version: 312
[25-NOV-2003 19:03:15:666] nsnainit: inf->nsinfflg[0]: 0xd
inf->nsinfflg[1]: 0xd
[25-NOV-2003 19:03:15:666] 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
[25-NOV-2003 19:03:15:666] 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
[25-NOV-2003 19:03:15:666] nsnainit: normal exit
[25-NOV-2003 19:03:15:666] nsopen: global context check-in (to slot 2)
complete
[25-NOV-2003 19:03:15:666] nsopen: lcl[0]=0xffefff, lcl[1]=0x12003,
gbl[0]=0x7e3f, gbl[1]=0x2001, tdu=32767, sdu=8192
[25-NOV-2003 19:03:15:666] nsdo: entry
[25-NOV-2003 19:03:15:666] nsdo: cid=2, opcode=65, *bl=0, *what=0,
uflgs=0x0, cflgs=0x2
[25-NOV-2003 19:03:15:666] nsdo: rank=64, nsctxrnk=0
[25-NOV-2003 19:03:15:666] nsdo: nsctx: state=7, flg=0x4200, mvd=0
[25-NOV-2003 19:03:15:666] nsbal: entry
[25-NOV-2003 19:03:15:666] nsbgetfl: entry
[25-NOV-2003 19:03:15:666] nsbgetfl: normal exit
[25-NOV-2003 19:03:15:666] nsmal: entry
[25-NOV-2003 19:03:15:666] nsmal: 48 bytes at 0xeddee0
[25-NOV-2003 19:03:15:666] nsmal: normal exit
[25-NOV-2003 19:03:15:666] nsbal: normal exit
[25-NOV-2003 19:03:15:666] nsbal: entry
[25-NOV-2003 19:03:15:666] nsbgetfl: entry
[25-NOV-2003 19:03:15:666] nsbgetfl: normal exit
[25-NOV-2003 19:03:15:666] nsmal: entry
[25-NOV-2003 19:03:15:666] nsmal: 48 bytes at 0xeddfa0
[25-NOV-2003 19:03:15:666] nsmal: normal exit
[25-NOV-2003 19:03:15:666] nsbal: normal exit
[25-NOV-2003 19:03:15:666] nsdo: nsctxrnk=0
[25-NOV-2003 19:03:15:666] nsdo: normal exit
[25-NOV-2003 19:03:15:666] nsopen: normal exit
[25-NOV-2003 19:03:15:666] nsanswer: deferring connect attempt; at stage 5
[25-NOV-2003 19:03:15:666] nsanswer: normal exit
[25-NOV-2003 19:03:15:666] nsevreg: entry
[25-NOV-2003 19:03:15:666] nsevreg: begin registration process for 2
[25-NOV-2003 19:03:15:666] nsevregPrePost: entry
[25-NOV-2003 19:03:15:666] nsevregPrePost: normal exit
[25-NOV-2003 19:03:15:666] nsevreg: sgt=0, evn=4, evt[2]=0x0
[25-NOV-2003 19:03:15:666] nsevreg: begin notification process for 2
[25-NOV-2003 19:03:15:666] nsevregAffectNotif: entry
[25-NOV-2003 19:03:15:666] nsrah: entry
[25-NOV-2003 19:03:15:666] nsrah: setting transport read mode (2)
[25-NOV-2003 19:03:15:666] nttctl: entry
[25-NOV-2003 19:03:15:666] nttctl: Clearing non-blocking mode
[25-NOV-2003 19:03:15:666] nttctl: entry
[25-NOV-2003 19:03:15:666] nttctl: Setting connection into async mode
[25-NOV-2003 19:03:15:666] nsrah: normal exit
[25-NOV-2003 19:03:15:666] nsevregAffectNotif: exit (0)
[25-NOV-2003 19:03:15:666] nsevreg: rdm=2, sgt=0, evt[0]=0x20, [1]=0x20,
[2]=0x0, nrg=0
[25-NOV-2003 19:03:15:666] nsevreg: registering for 0x20
[25-NOV-2003 19:03:15:666] nsrah: entry
[25-NOV-2003 19:03:15:666] nsrah: reading (asynchronously) from transport...
[25-NOV-2003 19:03:15:666] nsbal: entry
[25-NOV-2003 19:03:15:666] nsbgetfl: entry
[25-NOV-2003 19:03:15:666] nsbgetfl: normal exit
[25-NOV-2003 19:03:15:666] nsmal: entry
[25-NOV-2003 19:03:15:666] nsmal: 48 bytes at 0xeb83c8
[25-NOV-2003 19:03:15:666] nsmal: normal exit
[25-NOV-2003 19:03:15:666] nsbal: normal exit
[25-NOV-2003 19:03:15:666] nsrah: ...into overflow area...
[25-NOV-2003 19:03:15:666] nttmrd: entry
[25-NOV-2003 19:03:15:666] ntt2err: entry
[25-NOV-2003 19:03:15:666] ntt2err: soc 468 error - operation=5,
ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0[25-NOV-2003 19:03:15:666] nsevwait: 0 pre-posted event(s)
[25-NOV-2003 19:03:15:666] ntt2err: exit
[25-NOV-2003 19:03:15:666] nttmrd: socket 468 had bytes read=8208
[25-NOV-2003 19:03:15:666] nttmrd: exit
[25-NOV-2003 19:03:15:666] nsrah: exit (0)
[25-NOV-2003 19:03:15:666] nsevreg: normal exit
[25-NOV-2003 19:03:15:666] nsglhe: exit
[25-NOV-2003 19:03:15:666] nsevwait: entry
[25-NOV-2003 19:03:15:666] nsevwait: 2 registered connection(s)
ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0[25-NOV-2003 19:03:15:706] nsdo: entry
[25-NOV-2003 19:03:15:706] ntt2err: exit
[25-NOV-2003 19:03:15:706] nttmrd: socket 468 had bytes read=2064
[25-NOV-2003 19:03:15:706] nttmrd: exit
[25-NOV-2003 19:03:15:706] nsrah: exit (0)
[25-NOV-2003 19:03:15:706] nsclose: entry
[25-NOV-2003 19:03:15:706] nstimarmed: entry
[25-NOV-2003 19:03:15:706] nstimarmed: no timer allocated
[25-NOV-2003 19:03:15:706] nstimarmed: normal exit