Re: Help! Connection Refused.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 04 Mar 1999 19:39:23 +0100
Message-ID: <36DED357.ECAE3E20@sybrandb.demon.nl>

The problem is in this fragment

nspsend:29 28 45 52 52 4F 52 3D  |)(ERROR=|
nspsend:28 43 4F 44 45 3D 31 32  |(CODE=12|
nspsend:35 36 30 29 28 45 4D 46  |560)(EMF|
nspsend:49 3D 34 29 29 28 45 52  |I=4))(ER|
nspsend:52 4F 52 3D 28 43 4F 44  |ROR=(COD|
nspsend:45 3D 35 31 36 29 28 45  |E=516)(E|
nspsend:4D 46 49 3D 34 29 29 28  |MFI=4))(|
nspsend:45 52 52 4F 52 3D 28 42  |ERROR=(B|
nspsend:55 46 3D 27 4C 69 6E 75  |UF='Linu|
nspsend:78 20 45 72 72 6F 72 3A  |x Error:|
nspsend:20 31 33 3A 20 50 65 72  | 13: Per|
nspsend:6D 69 73 73 69 6F 6E 20  |mission |
nspsend:64 65 6E 69 65 64 27 29  |denied')|
nspsend:29 29 29 00 00 00 00 00  |))

It occurs several times in your trace. This is an error returned by the server process. You have a permission problem on your oracle files, probably also on the SGA.
Regrettably, I don't know from the top of my head what the permissions should be, I remember the mask is 477 and the owner:group oracle:dba in a default installation.

Hth,

Sybrand Bakker, oracle dba

oracle devloper wrote:

> Hi all,
>
> I cannot connect to a Oracle Database via Oracle's jdbc thin client. I
> have the following trace hope anyone could help.
>
> lsnr.trc
>
> sntseltst: FOUND: connection request on socket 13
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x8365410 stage 0: NT events set:
> CONNECTION REQUEST
>
> nsevfnt: cxd: 0x8365410 stage 0: NS events set:
> INCOMING CALL
>
> nsevwait: event is 0x1, on 4
> nsevwait: 1 posted event(s)
> nsevwait: exit (0)
> tnslsnr: Event on cxd 0x8365410.
> tnslsnr: Allocating cxd 0x83672a0
> nsanswer: entry
> nsopen: entry
> nsmal: entry
> nsmal: 416 bytes at 0x8369940
> nsmal: normal exit
> nsnainconn: entry
> nsmal: entry
> nsmal: 1596 bytes at 0x83b32b0
> nsmal: normal exit
> nsnainconn: normal exit
> 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.
> nttvlser: entry
> nttvlser: valid node check on incoming node 192.168.2.4
> nttvlser: Accepted Entry: 192.168.2.4
> nttcnr: exit
> nttcon: NT layer TCP/IP connection has been established.
> nttcon: exit
> nsopen: transport is open
> nsnainit: entry
> nsnainit: answer
> nsnadct: entry
> nsnadct: normal exit
> nsnasvnainfo: entry
> nsnasvnainfo: NA disabled for this connection
> nsnasvnainfo: normal exit
> nainit: entry
> nagblini: entry
> nau_gin: entry
> nau_gparams: entry
> nam_gbp: Reading parameter "sqlnet.authentication_required" from
> parameter 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"
> na_receive_packet: entry
> na_receive_packet: exit
> nau_gslf: exit
> nau_gparams: exit
> nau_gin: exit
> nagblini: exit
> na_saveprot: entry
> na_saveprot: exit
> nacomin: entry
> nas_init: entry
> nas_init: exit
> nau_ini: entry
> naugcp_get_connect_parameters: entry
> na_receive_packet: entry
> na_receive_packet: exit
> naugcp_get_connect_parameters: exit
> nau_gettab: entry
> nau_gettab: using authentication adapter table "nautab"
> nau_gettab: nautab contains the following services:
> nau_gettab: OSS
> nau_gettab: exit
> nau_sini: entry
> nau_sini: exit
> nau_ini: connection type: "standard"
> nau_ini: exit
> naeeinit: entry
> nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter
> file
> nam_gnsp: Parameter not found
> naequad: Using default value "ACCEPTED"
> nam_gic: entry
> nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER"
> parameter
> nam_gic: Parameter not found
> nam_gic: exit
> naesno: Using default value "all available algorithms"
> naeshow: entry
> naeshow: These are the encryption algorithms that the server will
> accept, in decreasing order of preference:
> naeshow: Choice 0: no algorithm; encryption inactive
> naeshow: exit
> naeeinit: exit
> naecinit: entry
> nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from
> parameter file
> nam_gnsp: Parameter not found
> naequad: Using default value "ACCEPTED"
> nam_gic: entry
> nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER"
> parameter
> nam_gic: Parameter not found
> nam_gic: exit
> naesno: Using default value "all available algorithms"
> naeshow: entry
> naeshow: These are the checksumming algorithms that the server will
> accept, in decreasing order of preference:
> naeshow: Choice 0: no algorithm; checksumming inactive
> naeshow: exit
> naecinit: exit
> nainit: native services disabled - disconnecting
> nadisc: entry
> nacomtm: entry
> nacompd: entry
> nacompd: exit
> nacompd: entry
> nacompd: exit
> nacomtm: exit
> nas_dis: entry
> nas_dis: exit
> nau_dis: entry
> nau_dis: exit
> naeetrm: entry
> naeetrm: exit
> naectrm: entry
> naectrm: exit
> nagbltrm: entry
> nau_gtm: entry
> nau_gtm: exit
> nagbltrm: exit
> nadisc: exit
> nainit: 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
>
> nsnainit: normal exit
> nsopen: global context check-in (to slot 5) complete
> nsopen: lcl[0]=0xe9ff, lcl[1]=0x3, gbl[0]=0x383f, gbl[1]=0x2001,
> tdu=32767, sdu=2048
> nsdo: entry
> nsdo: cid=5, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
> nsdo: rank=64, nsctxrnk=0
> nsdo: nsctx: state=7, flg=0x4200, mvd=0
> nsbal: entry
> nsbgetfl: entry
> nsbgetfl: normal exit
> nsbal: normal exit
> nsbal: entry
> nsbgetfl: entry
> nsbgetfl: normal exit
> nsbal: normal exit
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsopen: normal exit
> nsanswer: deferring connect attempt; at stage 2
> nsanswer: normal exit
> nsevreg: entry
> nsevreg: begin registration process for 5
> nsevreg: sgt=0, evn=1, evt[2]=0x0
> nsevreg: begin notification process for 5
> nsevreg: rdm=0, sgt=0, evt[0]=0x20, [1]=0x20, [2]=0x0, nrg=0
> nsevreg: registering for 0x20
> nsevsig: entry
> nsevsig: normal exit
> nsevreg: normal exit
> nsevwait: entry
> nsevwait: 4 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 5 added to NT list for 0x1
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 5)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13
> sntseltst: Testing for WRITE on socket 14
> sntseltst: FOUND: write request on socket 14
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x83672a0 stage 2: NT events set:
> WRITE
>
> nsevfnt: cxd: 0x83672a0 stage 2: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevfnt: cxd: 0x83672a0 stage 2: NT events set:
> WRITE
>
> nsevfnt: cxd: 0x83672a0 stage 2: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevdansw: entry
> nsevdansw: at STAGE 2
> nsevdansw: exit
> nsevdansw: exit
> nsevwait: 0 posted event(s)
> nsevwait: exit (0)
> nsevwait: entry
> nsevwait: 4 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 5 added to NT list for 0x2
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 5)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13
> sntseltst: Testing for DATA on socket 14
> sntseltst: FOUND: read request on socket 14
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x83672a0 stage 3: NT events set:
> READ
>
> nsevfnt: cxd: 0x83672a0 stage 3: NS events set:
> OUTGOING CALL COMPLETE
>
> nsprecv: entry
> nsbal: entry
> nsbgetfl: entry
> nsbgetfl: normal exit
> nsbal: normal exit
> nsprecv: reading from transport...
> nttctl: entry
> nttctl: Setting connection into non-blocking mode
> nttmrd: entry
> nttmrd: socket 14 had bytes read=187
> nttmrd: exit
> nttctl: entry
> nttctl: Clearing non-blocking mode
> nsprecv: 187 bytes from transport
> nsprecv: tlen=187, plen=187, type=1
> nsprecv: normal exit
> nsevfnt: cxd: 0x83672a0 stage 3: NT events set:
> READ
>
> nsevfnt: cxd: 0x83672a0 stage 3: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevdansw: entry
> nsevdansw: at STAGE 3
> nsmal: entry
> nsmal: 2040 bytes at 0x83b4640
> nsmal: normal exit
> nsdo: entry
> nsdo: cid=5, 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=2047
> nscon: entry
> nscon: doing connect handshake...
> nscon: recving a packet
> nsprecv: entry
> nsprecv: 187 bytes from leftover
> nsprecv: tlen=187, plen=187, type=1
> nsprecv: packet dump
> nsprecv:00 BB 00 00 01 00 00 00 |........|
> nsprecv:01 33 01 2C 00 00 08 00 |.3.,....|
> nsprecv:7F FF 7F 08 00 00 01 00 |........|
> nsprecv:00 99 00 22 00 00 04 00 |..."....|
> nsprecv:04 00 28 44 45 53 43 52 |..(DESCR|
> nsprecv:49 50 54 49 4F 4E 3D 28 |IPTION=(|
> nsprecv:43 4F 4E 4E 45 43 54 5F |CONNECT_|
> nsprecv:44 41 54 41 3D 28 53 49 |DATA=(SI|
> nsprecv:44 3D 4F 52 41 5F 53 49 |D=ORA_SI|
> nsprecv:44 29 28 43 49 44 3D 28 |D)(CID=(|
> nsprecv:50 52 4F 47 52 41 4D 3D |PROGRAM=|
> nsprecv:29 28 48 4F 53 54 3D 5F |)(HOST=_|
> nsprecv:5F 6A 64 62 63 5F 5F 29 |_jdbc__)|
> nsprecv:28 55 53 45 52 3D 29 29 |(USER=))|
> nsprecv:29 28 41 44 44 52 45 53 |)(ADDRES|
> nsprecv:53 5F 4C 49 53 54 3D 28 |S_LIST=(|
> nsprecv:41 44 44 52 45 53 53 3D |ADDRESS=|
> nsprecv:28 50 52 4F 54 4F 43 4F |(PROTOCO|
> nsprecv:4C 3D 74 63 70 29 28 48 |L=tcp)(H|
> nsprecv:4F 53 54 3D 50 34 30 30 |OST=P400|
> nsprecv:2E 50 46 61 6D 69 6C 79 |.PFamily|
> nsprecv:2E 63 6F 6D 29 28 50 4F |.com)(PO|
> nsprecv:52 54 3D 31 35 32 31 29 |RT=1521)|
> nsprecv:29 29 29 00 00 00 00 00 |))).....|
> nsprecv: normal exit
> nscon: got NSPTCN packet
> nsconneg: entry
> nsconneg: vsn=307, lov=300, opt=0x0, sdu=2048, tdu=32767, ntc=0x7f08
> nsconneg: vsn=307, gbl=0x1, sdu=2048, tdu=32767
> nsconneg: normal exit
> nscon: got 153 bytes connect data
> nscon: exit (0)
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsmfr: entry
> nsmfr: 2040 bytes at 0x83b4640
> nsmfr: normal exit
> nsevdansw: exit
> nsevdansw: exit
> nsevwait: 0 posted event(s)
> nsevwait: exit (0)
> nsevwait: entry
> nsevwait: 4 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 5 added to NT list for 0x1
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 5)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13
> sntseltst: Testing for WRITE on socket 14
> sntseltst: FOUND: write request on socket 14
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x83672a0 stage 4: NT events set:
> WRITE
>
> nsevfnt: cxd: 0x83672a0 stage 4: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevdansw: entry
> nsevdansw: at STAGE 4
> nsevdansw: exit
> nsevwait: event is 0x20, on 5
> nsevwait: 1 posted event(s)
> nsevwait: exit (0)
> tnslsnr: Event on cxd 0x83672a0.
> tnslsnr: Assume establishing a connection: look for SID
> tnslsnr: command = establish
> nttaddr2bnd: entry
> nttaddr2bnd: exit
> nsbequeath: entry
> nsc2addr: entry
> nlpcaini: entry
> nlpcaini: prg =
> nlpcaini: arg[0] =
> nlpcaini: arg[1] =
> nlpcaini: env[0] =
> nlpcaini: env[1] =
> nlpcaini: env[2] =
> nlpcaini: exit
> nsc2addr: normal exit
> nttaddr2bnd: entry
> nttaddr2bnd: exit
> nsbequeath: connecting...
> nserror: entry
> nserror: nsres: id=5, op=72, ns=12546, ns2=12560; nt[0]=516, nt[1]=13,
> nt[2]=0
> nsbequeath: error exit
> nsrefuse: entry
> nsdo: entry
> nsdo: cid=5, opcode=67, *bl=223, *what=10, uflgs=0x0, cflgs=0x3
> nsdo: rank=64, nsctxrnk=0
> nsdo: nsctx: state=2, flg=0x4204, mvd=0
> nsdo: gtn=187, gtc=187, ptn=10, ptc=2047
> nscon: entry
> nscon: sending NSPTRF packet
> nspsend: entry
> nspsend: plen=235, type=4
> nttwr: entry
> nttwr: socket 14 had bytes written=235
> nttwr: exit
> nspsend: 235 bytes to transport
> nspsend: packet dump
> nspsend:00 EB 00 00 04 00 00 00 |........|
> nspsend:22 00 00 DF 28 44 45 53 |"...(DES|
> nspsend:43 52 49 50 54 49 4F 4E |CRIPTION|
> nspsend:3D 28 54 4D 50 3D 29 28 |=(TMP=)(|
> nspsend:56 53 4E 4E 55 4D 3D 31 |VSNNUM=1|
> nspsend:33 34 32 33 38 32 30 38 |34238208|
> nspsend:29 28 45 52 52 3D 31 32 |)(ERR=12|
> nspsend:35 30 30 29 28 45 52 52 |500)(ERR|
> nspsend:4F 52 5F 53 54 41 43 4B |OR_STACK|
> nspsend:3D 28 45 52 52 4F 52 3D |=(ERROR=|
> nspsend:28 43 4F 44 45 3D 31 32 |(CODE=12|
> nspsend:35 30 30 29 28 45 4D 46 |500)(EMF|
> nspsend:49 3D 34 29 29 28 45 52 |I=4))(ER|
> nspsend:52 4F 52 3D 28 43 4F 44 |ROR=(COD|
> nspsend:45 3D 31 32 35 34 36 29 |E=12546)|
> nspsend:28 45 4D 46 49 3D 34 29 |(EMFI=4)|
> nspsend:29 28 45 52 52 4F 52 3D |)(ERROR=|
> nspsend:28 43 4F 44 45 3D 31 32 |(CODE=12|
> nspsend:35 36 30 29 28 45 4D 46 |560)(EMF|
> nspsend:49 3D 34 29 29 28 45 52 |I=4))(ER|
> nspsend:52 4F 52 3D 28 43 4F 44 |ROR=(COD|
> nspsend:45 3D 35 31 36 29 28 45 |E=516)(E|
> nspsend:4D 46 49 3D 34 29 29 28 |MFI=4))(|
> nspsend:45 52 52 4F 52 3D 28 42 |ERROR=(B|
> nspsend:55 46 3D 27 4C 69 6E 75 |UF='Linu|
> nspsend:78 20 45 72 72 6F 72 3A |x Error:|
> nspsend:20 31 33 3A 20 50 65 72 | 13: Per|
> nspsend:6D 69 73 73 69 6F 6E 20 |mission |
> nspsend:64 65 6E 69 65 64 27 29 |denied')|
> nspsend:29 29 29 00 00 00 00 00 |))).....|
> nspsend: normal exit
> nscon: exit (0)
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsclose: entry
> nstimarmed: entry
> nstimarmed: no timer allocated
> nstimarmed: normal exit
> nsdo: entry
> nsdo: cid=5, opcode=66, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
> nsdo: rank=64, nsctxrnk=0
> nsdo: nsctx: state=2, flg=0x4200, mvd=0
> nsevunreg: entry
> nsevunreg: cid=5, sgt=0, rdm=0
> nsevunreg: 3 registered connection(s)
> nsevunreg: normal exit
> nsbfr: entry
> nsbaddfl: entry
> nsbaddfl: normal exit
> nsbfr: normal exit
> nsbfr: entry
> nsbaddfl: entry
> nsbaddfl: normal exit
> nsbfr: normal exit
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsclose: closing transport
> nttdisc: entry
> nttdisc: Closed socket 14
> nttdisc: exit
> nsclose: global context check-out (from slot 5) complete
> nsnadisc: entry
> nsbfr: entry
> nsbaddfl: entry
> nsbaddfl: normal exit
> nsbfr: normal exit
> nsmfr: entry
> nsmfr: 1596 bytes at 0x83b32b0
> nsmfr: normal exit
> nsmfr: entry
> nsmfr: 416 bytes at 0x8369940
> nsmfr: normal exit
> nsclose: normal exit
> nsrefuse: exit (0)
> tnslsnr: Deallocating cxd 0x83672a0.
> tnslsnr: entry
> tnslsnr: entry
> tnslsnr: connect string inst->lcxd[0]:
> (ADDRESS=(PROTOCOL=ipc)(DEV=9)(KEY=ORA_SID))
> tnslsnr: connect string inst->lcxd[1]:
> (ADDRESS=(PROTOCOL=ipc)(DEV=12)(KEY=PNPKEY))
> nttaddr2bnd: entry
> nttaddr2bnd: exit
> tnslsnr: connect string inst->lcxd[2]:
> (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=192.168.2.4)(PORT=1521))
> tnslsnr: exit
> nsevwait: entry
> nsevwait: 3 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 4)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13
> sntseltst: FOUND: connection request on socket 13
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x8365410 stage 0: NT events set:
> CONNECTION REQUEST
>
> nsevfnt: cxd: 0x8365410 stage 0: NS events set:
> INCOMING CALL
>
> nsevwait: event is 0x1, on 4
> nsevwait: 1 posted event(s)
> nsevwait: exit (0)
> tnslsnr: Event on cxd 0x8365410.
> tnslsnr: Allocating cxd 0x83672a0
> nsanswer: entry
> nsopen: entry
> nsmal: entry
> nsmal: 416 bytes at 0x83b3358
> nsmal: normal exit
> nsnainconn: entry
> nsmal: entry
> nsmal: 1596 bytes at 0x83b3a78
> nsmal: normal exit
> nsnainconn: normal exit
> 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.
> nttvlser: entry
> nttvlser: valid node check on incoming node 192.168.2.4
> nttvlser: Accepted Entry: 192.168.2.4
> nttcnr: exit
> nttcon: NT layer TCP/IP connection has been established.
> nttcon: exit
> nsopen: transport is open
> nsnainit: entry
> nsnainit: answer
> nsnadct: entry
> nsnadct: normal exit
> nsnasvnainfo: entry
> nsnasvnainfo: NA disabled for this connection
> nsnasvnainfo: normal exit
> nainit: entry
> nagblini: entry
> nau_gin: entry
> nau_gparams: entry
> nam_gbp: Reading parameter "sqlnet.authentication_required" from
> parameter 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"
> na_receive_packet: entry
> na_receive_packet: exit
> nau_gslf: exit
> nau_gparams: exit
> nau_gin: exit
> nagblini: exit
> na_saveprot: entry
> na_saveprot: exit
> nacomin: entry
> nas_init: entry
> nas_init: exit
> nau_ini: entry
> naugcp_get_connect_parameters: entry
> na_receive_packet: entry
> na_receive_packet: exit
> naugcp_get_connect_parameters: exit
> nau_gettab: entry
> nau_gettab: using authentication adapter table "nautab"
> nau_gettab: nautab contains the following services:
> nau_gettab: OSS
> nau_gettab: exit
> nau_sini: entry
> nau_sini: exit
> nau_ini: connection type: "standard"
> nau_ini: exit
> naeeinit: entry
> nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter
> file
> nam_gnsp: Parameter not found
> naequad: Using default value "ACCEPTED"
> nam_gic: entry
> nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER"
> parameter
> nam_gic: Parameter not found
> nam_gic: exit
> naesno: Using default value "all available algorithms"
> naeshow: entry
> naeshow: These are the encryption algorithms that the server will
> accept, in decreasing order of preference:
> naeshow: Choice 0: no algorithm; encryption inactive
> naeshow: exit
> naeeinit: exit
> naecinit: entry
> nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from
> parameter file
> nam_gnsp: Parameter not found
> naequad: Using default value "ACCEPTED"
> nam_gic: entry
> nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER"
> parameter
> nam_gic: Parameter not found
> nam_gic: exit
> naesno: Using default value "all available algorithms"
> naeshow: entry
> naeshow: These are the checksumming algorithms that the server will
> accept, in decreasing order of preference:
> naeshow: Choice 0: no algorithm; checksumming inactive
> naeshow: exit
> naecinit: exit
> nainit: native services disabled - disconnecting
> nadisc: entry
> nacomtm: entry
> nacompd: entry
> nacompd: exit
> nacompd: entry
> nacompd: exit
> nacomtm: exit
> nas_dis: entry
> nas_dis: exit
> nau_dis: entry
> nau_dis: exit
> naeetrm: entry
> naeetrm: exit
> naectrm: entry
> naectrm: exit
> nagbltrm: entry
> nau_gtm: entry
> nau_gtm: exit
> nagbltrm: exit
> nadisc: exit
> nainit: 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
>
> nsnainit: normal exit
> nsopen: global context check-in (to slot 5) complete
> nsopen: lcl[0]=0xe9ff, lcl[1]=0x3, gbl[0]=0x383f, gbl[1]=0x2001,
> tdu=32767, sdu=2048
> nsdo: entry
> nsdo: cid=5, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
> nsdo: rank=64, nsctxrnk=0
> nsdo: nsctx: state=7, flg=0x4200, mvd=0
> nsbal: entry
> nsbgetfl: entry
> nsbgetfl: normal exit
> nsbal: normal exit
> nsbal: entry
> nsbgetfl: entry
> nsbgetfl: normal exit
> nsbal: normal exit
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsopen: normal exit
> nsanswer: deferring connect attempt; at stage 2
> nsanswer: normal exit
> nsevreg: entry
> nsevreg: begin registration process for 5
> nsevreg: sgt=0, evn=1, evt[2]=0x0
> nsevreg: begin notification process for 5
> nsevreg: rdm=0, sgt=0, evt[0]=0x20, [1]=0x20, [2]=0x0, nrg=0
> nsevreg: registering for 0x20
> nsevsig: entry
> nsevsig: normal exit
> nsevreg: normal exit
> nsevwait: entry
> nsevwait: 4 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 5 added to NT list for 0x1
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 5)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13
> sntseltst: Testing for WRITE on socket 14
> sntseltst: FOUND: write request on socket 14
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x83672a0 stage 2: NT events set:
> WRITE
>
> nsevfnt: cxd: 0x83672a0 stage 2: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevfnt: cxd: 0x83672a0 stage 2: NT events set:
> WRITE
>
> nsevfnt: cxd: 0x83672a0 stage 2: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevdansw: entry
> nsevdansw: at STAGE 2
> nsevdansw: exit
> nsevdansw: exit
> nsevwait: 0 posted event(s)
> nsevwait: exit (0)
> nsevwait: entry
> nsevwait: 4 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 5 added to NT list for 0x2
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 5)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13
> sntseltst: Testing for DATA on socket 14
> sntseltst: FOUND: read request on socket 14
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x83672a0 stage 3: NT events set:
> READ
>
> nsevfnt: cxd: 0x83672a0 stage 3: NS events set:
> OUTGOING CALL COMPLETE
>
> nsprecv: entry
> nsbal: entry
> nsbgetfl: entry
> nsbgetfl: normal exit
> nsbal: normal exit
> nsprecv: reading from transport...
> nttctl: entry
> nttctl: Setting connection into non-blocking mode
> nttmrd: entry
> nttmrd: socket 14 had bytes read=187
> nttmrd: exit
> nttctl: entry
> nttctl: Clearing non-blocking mode
> nsprecv: 187 bytes from transport
> nsprecv: tlen=187, plen=187, type=1
> nsprecv: normal exit
> nsevfnt: cxd: 0x83672a0 stage 3: NT events set:
> READ
>
> nsevfnt: cxd: 0x83672a0 stage 3: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevdansw: entry
> nsevdansw: at STAGE 3
> nsmal: entry
> nsmal: 2040 bytes at 0x83b4e08
> nsmal: normal exit
> nsdo: entry
> nsdo: cid=5, 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=2047
> nscon: entry
> nscon: doing connect handshake...
> nscon: recving a packet
> nsprecv: entry
> nsprecv: 187 bytes from leftover
> nsprecv: tlen=187, plen=187, type=1
> nsprecv: packet dump
> nsprecv:00 BB 00 00 01 00 00 00 |........|
> nsprecv:01 33 01 2C 00 00 08 00 |.3.,....|
> nsprecv:7F FF 7F 08 00 00 01 00 |........|
> nsprecv:00 99 00 22 00 00 04 00 |..."....|
> nsprecv:04 00 28 44 45 53 43 52 |..(DESCR|
> nsprecv:49 50 54 49 4F 4E 3D 28 |IPTION=(|
> nsprecv:43 4F 4E 4E 45 43 54 5F |CONNECT_|
> nsprecv:44 41 54 41 3D 28 53 49 |DATA=(SI|
> nsprecv:44 3D 4F 52 41 5F 53 49 |D=ORA_SI|
> nsprecv:44 29 28 43 49 44 3D 28 |D)(CID=(|
> nsprecv:50 52 4F 47 52 41 4D 3D |PROGRAM=|
> nsprecv:29 28 48 4F 53 54 3D 5F |)(HOST=_|
> nsprecv:5F 6A 64 62 63 5F 5F 29 |_jdbc__)|
> nsprecv:28 55 53 45 52 3D 29 29 |(USER=))|
> nsprecv:29 28 41 44 44 52 45 53 |)(ADDRES|
> nsprecv:53 5F 4C 49 53 54 3D 28 |S_LIST=(|
> nsprecv:41 44 44 52 45 53 53 3D |ADDRESS=|
> nsprecv:28 50 52 4F 54 4F 43 4F |(PROTOCO|
> nsprecv:4C 3D 74 63 70 29 28 48 |L=tcp)(H|
> nsprecv:4F 53 54 3D 50 34 30 30 |OST=P400|
> nsprecv:2E 50 46 61 6D 69 6C 79 |.PFamily|
> nsprecv:2E 63 6F 6D 29 28 50 4F |.com)(PO|
> nsprecv:52 54 3D 31 35 32 31 29 |RT=1521)|
> nsprecv:29 29 29 00 00 00 00 00 |))).....|
> nsprecv: normal exit
> nscon: got NSPTCN packet
> nsconneg: entry
> nsconneg: vsn=307, lov=300, opt=0x0, sdu=2048, tdu=32767, ntc=0x7f08
> nsconneg: vsn=307, gbl=0x1, sdu=2048, tdu=32767
> nsconneg: normal exit
> nscon: got 153 bytes connect data
> nscon: exit (0)
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsmfr: entry
> nsmfr: 2040 bytes at 0x83b4e08
> nsmfr: normal exit
> nsevdansw: exit
> nsevdansw: exit
> nsevwait: 0 posted event(s)
> nsevwait: exit (0)
> nsevwait: entry
> nsevwait: 4 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 5 added to NT list for 0x1
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 5)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13
> sntseltst: Testing for WRITE on socket 14
> sntseltst: FOUND: write request on socket 14
> sntseltst: Events on 1 cxds
> nsevwait: 1 newly-posted event(s)
> nsevfnt: cxd: 0x83672a0 stage 4: NT events set:
> WRITE
>
> nsevfnt: cxd: 0x83672a0 stage 4: NS events set:
> OUTGOING CALL COMPLETE
>
> nsevdansw: entry
> nsevdansw: at STAGE 4
> nsevdansw: exit
> nsevwait: event is 0x20, on 5
> nsevwait: 1 posted event(s)
> nsevwait: exit (0)
> tnslsnr: Event on cxd 0x83672a0.
> tnslsnr: Assume establishing a connection: look for SID
> tnslsnr: command = establish
> nttaddr2bnd: entry
> nttaddr2bnd: exit
> nsbequeath: entry
> nsc2addr: entry
> nlpcaini: entry
> nlpcaini: prg =
> nlpcaini: arg[0] =
> nlpcaini: arg[1] =
> nlpcaini: env[0] =
> nlpcaini: env[1] =
> nlpcaini: env[2] =
> nlpcaini: exit
> nsc2addr: normal exit
> nttaddr2bnd: entry
> nttaddr2bnd: exit
> nsbequeath: connecting...
> nserror: entry
> nserror: nsres: id=5, op=72, ns=12546, ns2=12560; nt[0]=516, nt[1]=13,
> nt[2]=0
> nsbequeath: error exit
> nsrefuse: entry
> nsdo: entry
> nsdo: cid=5, opcode=67, *bl=223, *what=10, uflgs=0x0, cflgs=0x3
> nsdo: rank=64, nsctxrnk=0
> nsdo: nsctx: state=2, flg=0x4204, mvd=0
> nsdo: gtn=187, gtc=187, ptn=10, ptc=2047
> nscon: entry
> nscon: sending NSPTRF packet
> nspsend: entry
> nspsend: plen=235, type=4
> nttwr: entry
> nttwr: socket 14 had bytes written=235
> nttwr: exit
> nspsend: 235 bytes to transport
> nspsend: packet dump
> nspsend:00 EB 00 00 04 00 00 00 |........|
> nspsend:22 00 00 DF 28 44 45 53 |"...(DES|
> nspsend:43 52 49 50 54 49 4F 4E |CRIPTION|
> nspsend:3D 28 54 4D 50 3D 29 28 |=(TMP=)(|
> nspsend:56 53 4E 4E 55 4D 3D 31 |VSNNUM=1|
> nspsend:33 34 32 33 38 32 30 38 |34238208|
> nspsend:29 28 45 52 52 3D 31 32 |)(ERR=12|
> nspsend:35 30 30 29 28 45 52 52 |500)(ERR|
> nspsend:4F 52 5F 53 54 41 43 4B |OR_STACK|
> nspsend:3D 28 45 52 52 4F 52 3D |=(ERROR=|
> nspsend:28 43 4F 44 45 3D 31 32 |(CODE=12|
> nspsend:35 30 30 29 28 45 4D 46 |500)(EMF|
> nspsend:49 3D 34 29 29 28 45 52 |I=4))(ER|
> nspsend:52 4F 52 3D 28 43 4F 44 |ROR=(COD|
> nspsend:45 3D 31 32 35 34 36 29 |E=12546)|
> nspsend:28 45 4D 46 49 3D 34 29 |(EMFI=4)|
> nspsend:29 28 45 52 52 4F 52 3D |)(ERROR=|
> nspsend:28 43 4F 44 45 3D 31 32 |(CODE=12|
> nspsend:35 36 30 29 28 45 4D 46 |560)(EMF|
> nspsend:49 3D 34 29 29 28 45 52 |I=4))(ER|
> nspsend:52 4F 52 3D 28 43 4F 44 |ROR=(COD|
> nspsend:45 3D 35 31 36 29 28 45 |E=516)(E|
> nspsend:4D 46 49 3D 34 29 29 28 |MFI=4))(|
> nspsend:45 52 52 4F 52 3D 28 42 |ERROR=(B|
> nspsend:55 46 3D 27 4C 69 6E 75 |UF='Linu|
> nspsend:78 20 45 72 72 6F 72 3A |x Error:|
> nspsend:20 31 33 3A 20 50 65 72 | 13: Per|
> nspsend:6D 69 73 73 69 6F 6E 20 |mission |
> nspsend:64 65 6E 69 65 64 27 29 |denied')|
> nspsend:29 29 29 00 00 00 00 00 |))).....|
> nspsend: normal exit
> nscon: exit (0)
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsclose: entry
> nstimarmed: entry
> nstimarmed: no timer allocated
> nstimarmed: normal exit
> nsdo: entry
> nsdo: cid=5, opcode=66, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
> nsdo: rank=64, nsctxrnk=0
> nsdo: nsctx: state=2, flg=0x4200, mvd=0
> nsevunreg: entry
> nsevunreg: cid=5, sgt=0, rdm=0
> nsevunreg: 3 registered connection(s)
> nsevunreg: normal exit
> nsbfr: entry
> nsbaddfl: entry
> nsbaddfl: normal exit
> nsbfr: normal exit
> nsbfr: entry
> nsbaddfl: entry
> nsbaddfl: normal exit
> nsbfr: normal exit
> nsdo: nsctxrnk=0
> nsdo: normal exit
> nsclose: closing transport
> nttdisc: entry
> nttdisc: Closed socket 14
> nttdisc: exit
> nsclose: global context check-out (from slot 5) complete
> nsnadisc: entry
> nsbfr: entry
> nsbaddfl: entry
> nsbaddfl: normal exit
> nsbfr: normal exit
> nsmfr: entry
> nsmfr: 1596 bytes at 0x83b3a78
> nsmfr: normal exit
> nsmfr: entry
> nsmfr: 416 bytes at 0x83b3358
> nsmfr: normal exit
> nsclose: normal exit
> nsrefuse: exit (0)
> tnslsnr: Deallocating cxd 0x83672a0.
> tnslsnr: entry
> tnslsnr: entry
> tnslsnr: connect string inst->lcxd[0]:
> (ADDRESS=(PROTOCOL=ipc)(DEV=9)(KEY=ORA_SID))
> tnslsnr: connect string inst->lcxd[1]:
> (ADDRESS=(PROTOCOL=ipc)(DEV=12)(KEY=PNPKEY))
> nttaddr2bnd: entry
> nttaddr2bnd: exit
> tnslsnr: connect string inst->lcxd[2]:
> (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=192.168.2.4)(PORT=1521))
> tnslsnr: exit
> nsevwait: entry
> nsevwait: 3 registered connection(s)
> nsevwait: 1 added to NT list for 0x8
> nsevwait: 3 added to NT list for 0x8
> nsevwait: 4 added to NT list for 0x8
> nsevwait: 0 pre-posted event(s)
> nsevwait: waiting for transport event (1 thru 4)...
> ntctst: size of NTTEST list is 1 - not calling poll
> sntseltst: Testing for CONNECTIONS on socket 9
> sntseltst: Testing for CONNECTIONS on socket 12
> sntseltst: Testing for CONNECTIONS on socket 13

Received on Thu Mar 04 1999 - 12:39:23 CST