Link to home
Start Free TrialLog in
Avatar of ryeandi
ryeandi

asked on

database trigger firing only after login

hi oracle experts,
i have a test database that i'm working out some things i'd like to implement  on our production db.  one of the things that i'm interested in doing is notifying our dba's when a threshold number of failed attemts to logon to our database has occured within the last 24 hours.  my idea is that when the threshold is reaached, a smtp email will be sent to our dba's letting them know to investigate.  i have the following database trigger in place:

/*******************Begin Code***********************************/
CREATE OR REPLACE TRIGGER logon_watch
AFTER SERVERERROR
ON DATABASE
DECLARE
-- Constants --
NUMBEROFFAILURES CONSTANT NUMBER(4) := 2;
RECIPIENT1 CONSTANT VARCHAR2(25) := 'mymail;
MAILSERVER CONSTANT VARCHAR2(25) := 'mail.server';
SENDER CONSTANT VARCHAR2(25) := 'THE_ORACLE_GODS@Tester';
PORT CONSTANT NUMBER(2) := 25;

-- Variables --
v_failures_last24      NUMBER(9);
v_message VARCHAR2(4000);
v_smtp_conn      Utl_Smtp.CONNECTION;

BEGIN
v_failures_last24 := 0;
IF (Is_Servererror(1017)) THEN
 SELECT COUNT(*)
 INTO v_failures_last24
 FROM DBA_AUDIT_TRAIL
 WHERE returncode = 1017
   AND TIMESTAMP >= (SYSDATE - 1)
   AND TIMESTAMP <= SYSDATE;
            
 INSERT INTO ZZZ_TEST VALUES (v_failures_last24);
        
 IF v_failures_last24 >= NUMBEROFFAILURES THEN
  v_message := 'THERE HAVE BEEN ' || v_failures_last24 || ' FAILED ' ||
               'ATTEMPTS TO LOGIN TO TESTER';

  v_smtp_conn := Utl_Smtp.OPEN_CONNECTION(MAILSERVER, PORT);
  Utl_Smtp.HELO(v_smtp_conn, MAILSERVER);
  Utl_Smtp.MAIL(v_smtp_conn, SENDER);
  Utl_Smtp.RCPT(v_smtp_conn, RECIPIENT1);
  Utl_Smtp.OPEN_DATA(v_smtp_conn);
  Utl_Smtp.WRITE_DATA(v_smtp_conn, v_message);
  Utl_Smtp.CLOSE_DATA(v_smtp_conn);
  Utl_Smtp.QUIT(v_smtp_conn);
 END IF;
END IF;
END logon_watch;
/*******************End Code***********************************/

this trigger has been created under the 'SYS' schema.  notice that it has a table zzz_test that it writes to when it fires.  here is what is happening.
1)  i try to login to the database with the user 'DEV' and delibrately misspell the password.
2)  i check 'DBA_AUDIT_TRAIL' and see that the failed loggin has been captured.
3)  i check zzz_test and see that the loggin has NOT been entered and also note that i have NOT received an email.  (the trigger did not fire)
4)  i correctly log in as 'SYS' and check zzz_test and NOW the trigger fires for the failed login.    

this trigger will not fire until i correctly login as SYS.  what is going on?  how do i get this trigger to fire at the moment of the detected failed attempt?  

thanks,

rye
Avatar of jrb1
jrb1
Flag of United States of America image
It may be a problem with the count from DBA_AUDIT_TRAIL.  That's probably being written from a different thread and is not available for the trigger when it runs for the user.  Add 1 to the count and use that as the basis for sending the email.
Avatar of ryeandi
ryeandi

ASKER

that's not the problem because,
1)  i have the code set to send an email when there have been 2 or more ora-01017's in a day.  right now i have 10 so it should be firing every time an ora-01017 occurs.  
2)  when i do login to SYS, the correct number is sent within the email.  so the trigger is firing, but just not until SYS logs in.
Avatar of jrb1
jrb1
Flag of United States of America image
OK.  That's especially strange as this trigger shouldn't fire at all when you log in successfully.  I'll do some playing around with it.....
Avatar of jrb1
jrb1
Flag of United States of America image
Can you try a simpler version of the trigger?  Mine fires immediately:

CREATE OR REPLACE TRIGGER logon_watch
AFTER SERVERERROR
ON DATABASE
BEGIN
   IF (IS_SERVERERROR(1017)) THEN
      insert into ZZZ_TEST VALUES (999);
   END IF;
END logon_failures;
Avatar of jrb1
jrb1
Flag of United States of America image
sorry...cut and past error:

CREATE OR REPLACE TRIGGER logon_watch
AFTER SERVERERROR
ON DATABASE
BEGIN
   IF (IS_SERVERERROR(1017)) THEN
      insert into ZZZ_TEST VALUES (999);
   END IF;
END logon_watch;
Avatar of ryeandi
ryeandi

ASKER

thanks jrb1,
i replaced the code with exactly your trigger.  when i try a failed login, i get NO insert into zzz_test.  when i successfully login as SYS, the value gets inserted immediately.  
NEW INFO:  i just noticed something on the last login.  when i try the failed login via sqlplus, the error i get back is not ora-01017 but rather ora-03113.  when i look at dba_audit_trail, the 1017 error is written to the audit table for this attempted login.  does this shed some new light on the problem?  
Avatar of jrb1
jrb1
Flag of United States of America image
Sure.  You're having some other communications problem that's sabotaging your trigger.  I'll look around and see if anything obvious pops up.
Avatar of jrb1
jrb1
Flag of United States of America image
Here's a great resource for trying to track down the ora-03113 error:

http://www.tilsor.com.uy/servicios/soporte_tecnico/documentos/fichas/23.htm

I'd turn on SQLNET tracing on, both client and server.  And then fail the log on to generate the error.  Then turn tracing off.  The trace files should show exactly where the problem is occurring.
Avatar of ryeandi
ryeandi

ASKER

thanks jrb1,  i've enabled sqlnet tracing and produced trace files on both the client and server.  unfortuantely, i have no idea how to read them.  the only thing that i noticed in the .trc file on the client machine was this:  

[12-APR-2005 14:26:55:494] ntt2err: entry
[12-APR-2005 14:26:55:494] ntt2err: Read unexpected EOF ERROR on 256
[12-APR-2005 14:26:55:494] ntt2err: exit
[12-APR-2005 14:26:55:494] nsprecv: transport read error
[12-APR-2005 14:26:55:494] nsprecv: error exit
[12-APR-2005 14:26:55:494] nserror: entry
[12-APR-2005 14:26:55:494] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[12-APR-2005 14:26:55:494] nsrdr: error exit
[12-APR-2005 14:26:55:494] nsdo: nsctxrnk=0
[12-APR-2005 14:26:55:494] nsdo: error exit
[12-APR-2005 14:26:55:494] nioqer: entry
[12-APR-2005 14:26:55:494] nioqer:  incoming err = 12151
[12-APR-2005 14:26:55:494] nioqce: entry
[12-APR-2005 14:26:55:494] nioqce: exit
[12-APR-2005 14:26:55:494] nioqer:  returning err = 3113
[12-APR-2005 14:26:55:494] nioqer: exit
[12-APR-2005 14:26:55:494] nioqrc: exit
[12-APR-2005 14:26:55:494] nioqbr: entry
[12-APR-2005 14:26:55:494] nioqbr:  state = normal (0)
[12-APR-2005 14:26:55:494] nioqsm: entry
[12-APR-2005 14:26:55:494] nioqsm:  Sending break packet (1)...
[12-APR-2005 14:26:55:494] nsdo: entry
[12-APR-2005 14:26:55:494] nsdo: cid=0, opcode=67, *bl=1, *what=17, uflgs=0x100, cflgs=0x3
[12-APR-2005 14:26:55:494] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:55:494] nsdo: nsctx: state=1, flg=0x100420d, mvd=0
[12-APR-2005 14:26:55:494] nsdo: nsctxrnk=0
[12-APR-2005 14:26:55:494] nsdo: error exit
[12-APR-2005 14:26:55:494] nioqsm: send-break: failed to send break...
[12-APR-2005 14:26:55:494] nioqper:  error from send-marker
[12-APR-2005 14:26:55:494] nioqper:    nr err code: 0
[12-APR-2005 14:26:55:494] nioqper:    ns main err code: 12583
[12-APR-2005 14:26:55:494] nioqper:    ns (2)  err code: 0
[12-APR-2005 14:26:55:494] nioqper:    nt main err code: 0
[12-APR-2005 14:26:55:494] nioqper:    nt (2)  err code: 0
[12-APR-2005 14:26:55:494] nioqper:    nt OS   err code: 0
[12-APR-2005 14:26:55:494] nioqsm: exit
[12-APR-2005 14:26:55:494] nioqer: entry
[12-APR-2005 14:26:55:494] nioqer:  incoming err = 12152
[12-APR-2005 14:26:55:494] nioqce: entry
[12-APR-2005 14:26:55:494] nioqce: exit
[12-APR-2005 14:26:55:504] nioqer:  returning err = 3113
[12-APR-2005 14:26:55:504] nioqer: exit
[12-APR-2005 14:26:55:504] nioqbr:  returning 3113
[12-APR-2005 14:26:55:504] nioqbr: exit
[12-APR-2005 14:26:55:504] nioqds: entry
[12-APR-2005 14:26:55:504] nioqds:  disconnecting...

don't know if this helps.
Avatar of jrb1
jrb1
Flag of United States of America image
Yes, much better.  I'll take a look at it.
Avatar of jrb1
jrb1
Flag of United States of America image
Is that the entire file?  Either way I guess, can you run this from a command prompt:

trcasst listener.trc

That's supposed to help read the file.  What I see, however, starting at the end...the error codes

3113 - this is an end-of-file on communication channel error.  pretty much a catch all
12152 - TNS:unable to send break message (still pretty generic)
12583 - TNS:no reader
Cause: A send operation has been requested but partner has already disconnected.

Then you see "Sending break packet" a bit higher.  That is why you got the 12152....the break packet failed.

Moving up, you see 3113 again.  Then above that,

12151 - TNS:received bad packet type from network layer

I'm not sure if you file has more information above this, but if it does, can you post the next 100 lines or so from above this?
Avatar of ryeandi
ryeandi

ASKER

here's a quarter of the entire file.  thanks a million for your help.

[12-APR-2005 14:26:54:572] nacomap: Version transmitted: Oracle Advanced Security: Oracle Advanced Security for 32-bit Windows: Version 9.2.0.1.0 - Production
[12-APR-2005 14:26:54:572] nacomps: entry
[12-APR-2005 14:26:54:572] nacomps: service      authentication
       # of fields      2
       ORACLE error      0
[12-APR-2005 14:26:54:572] nacomps:       data length      4
            data type      raw data
[12-APR-2005 14:26:54:572] nacomps:       data length      1296
            data type      raw data
[12-APR-2005 14:26:54:572] nacomps: exit
[12-APR-2005 14:26:54:572] nacomap: exit
[12-APR-2005 14:26:54:572] nacomsn: sending 1329 bytes
[12-APR-2005 14:26:54:572] nsnasend: entry
[12-APR-2005 14:26:54:572] nsnasend: bytes to send: 1329
[12-APR-2005 14:26:54:572] nsdo: entry
[12-APR-2005 14:26:54:572] nsdo: cid=0, opcode=67, *bl=1329, *what=1, uflgs=0x22, cflgs=0x3
[12-APR-2005 14:26:54:572] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:572] nsdo: nsctx: state=8, flg=0x102420d, mvd=0
[12-APR-2005 14:26:54:572] nsdo: gtn=69, gtc=69, ptn=10, ptc=2011
[12-APR-2005 14:26:54:572] nsdo: 1329 bytes to NS buffer
[12-APR-2005 14:26:54:572] nsdoacts: entry
[12-APR-2005 14:26:54:572] nsdofls: entry
[12-APR-2005 14:26:54:572] nsdofls: DATA flags: 0x0
[12-APR-2005 14:26:54:572] nsdofls: sending NSPTDA packet
[12-APR-2005 14:26:54:572] nspsend: entry
[12-APR-2005 14:26:54:572] nspsend: plen=1339, type=6
[12-APR-2005 14:26:54:572] nttwr: entry
[12-APR-2005 14:26:54:572] nttwr: socket 256 had bytes written=1339
[12-APR-2005 14:26:54:572] nttwr: exit
[12-APR-2005 14:26:54:572] nspsend: 1339 bytes to transport
[12-APR-2005 14:26:54:572] nspsend: packet dump
[12-APR-2005 14:26:54:572] nspsend: 05 3B 00 00 06 04 00 00  |.;......|
[12-APR-2005 14:26:54:572] nspsend: 00 00 DE AD BE EF 05 31  |.......1|
[12-APR-2005 14:26:54:572] nspsend: 09 20 01 00 00 01 00 00  |........|
[12-APR-2005 14:26:54:572] nspsend: 01 00 02 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:572] nspsend: 04 00 01 10 05 00 00 05  |........|
[12-APR-2005 14:26:54:572] nspsend: 10 00 01 60 82 05 0C 06  |...`....|
[12-APR-2005 14:26:54:572] nspsend: 09 2A 86 48 86 F7 12 01  |.*.H....|
[12-APR-2005 14:26:54:572] nspsend: 02 02 01 00 6E 82 04 FB  |....n...|
[12-APR-2005 14:26:54:572] nspsend: 30 82 04 F7 A0 03 02 01  |0.......|
[12-APR-2005 14:26:54:572] nspsend: 05 A1 03 02 01 0E A2 07  |........|
[12-APR-2005 14:26:54:572] nspsend: 03 05 00 20 00 00 00 A3  |........|
[12-APR-2005 14:26:54:572] nspsend: 82 04 1F 61 82 04 1B 30  |...a...0|
[12-APR-2005 14:26:54:572] nspsend: 82 04 17 A0 03 02 01 05  |........|
[12-APR-2005 14:26:54:572] nspsend: A1 13 1B 11 4E 41 55 2E  |....NAU.|
[12-APR-2005 14:26:54:572] nspsend: 46 52 4F 4F 54 2E 4E 41  |FROOT.NA|
[12-APR-2005 14:26:54:572] nspsend: 55 2E 45 44 55 A2 13 30  |U.EDU..0|
[12-APR-2005 14:26:54:572] nspsend: 11 A0 03 02 01 80 A1 0A  |........|
[12-APR-2005 14:26:54:572] nspsend: 30 08 1B 06 4A 45 53 54  |0...JEST|
[12-APR-2005 14:26:54:572] nspsend: 45 52 A3 82 03 E4 30 82  |ER....0.|
[12-APR-2005 14:26:54:572] nspsend: 03 E0 A0 03 02 01 17 A1  |........|
[12-APR-2005 14:26:54:572] nspsend: 03 02 01 0E A2 82 03 D2  |........|
[12-APR-2005 14:26:54:572] nspsend: 04 82 03 CE 45 6F EA 3E  |....Eo.>|
[12-APR-2005 14:26:54:572] nspsend: 23 13 1A 7F C9 89 E0 FE  |#.......|
[12-APR-2005 14:26:54:572] nspsend: 6C 83 8B 03 F2 C3 73 61  |l.....sa|
[12-APR-2005 14:26:54:572] nspsend: AF F9 DF F4 FA 8B 4D 4A  |......MJ|
[12-APR-2005 14:26:54:572] nspsend: 04 0D B7 8D 63 AA B4 FD  |....c...|
[12-APR-2005 14:26:54:572] nspsend: 94 AA 79 8A 7C 04 41 0A  |..y.|.A.|
[12-APR-2005 14:26:54:572] nspsend: 87 D3 5D 3D 76 13 B8 AF  |..]=v...|
[12-APR-2005 14:26:54:572] nspsend: 53 DF 04 7D 03 7E 35 2E  |S..}.~5.|
[12-APR-2005 14:26:54:572] nspsend: 08 9B 76 B7 2B BC 09 8A  |..v.+...|
[12-APR-2005 14:26:54:572] nspsend: EF 41 B8 06 7E 78 E2 3D  |.A..~x.=|
[12-APR-2005 14:26:54:572] nspsend: 61 8F 6D F3 53 1C 0B 20  |a.m.S...|
[12-APR-2005 14:26:54:572] nspsend: 7F 2E E1 51 D1 F2 15 8E  |...Q....|
[12-APR-2005 14:26:54:572] nspsend: 3D 6F 09 C3 83 F6 B1 EF  |=o......|
[12-APR-2005 14:26:54:572] nspsend: 65 D1 D7 8A 76 06 41 74  |e...v.At|
[12-APR-2005 14:26:54:572] nspsend: 94 AD CE 53 99 E6 58 05  |...S..X.|
[12-APR-2005 14:26:54:572] nspsend: FE 0B 5E 9E E6 53 FF A1  |..^..S..|
[12-APR-2005 14:26:54:572] nspsend: AF 1F EC 78 5E 7A 9C 67  |...x^z.g|
[12-APR-2005 14:26:54:572] nspsend: 74 15 94 A9 B3 BE 0B B7  |t.......|
[12-APR-2005 14:26:54:572] nspsend: B1 CF 53 E8 E6 07 AB 63  |..S....c|
[12-APR-2005 14:26:54:572] nspsend: 6B AF A0 FD 28 A8 10 88  |k...(...|
[12-APR-2005 14:26:54:572] nspsend: 8A 1E DE F9 81 B9 7A 86  |......z.|
[12-APR-2005 14:26:54:572] nspsend: EC A2 5E A0 8D FE 21 24  |..^...!$|
[12-APR-2005 14:26:54:572] nspsend: 41 2C 01 3E D6 B7 7C 75  |A,.>..|u|
[12-APR-2005 14:26:54:572] nspsend: 86 19 23 C3 F3 2A 9E 71  |..#..*.q|
[12-APR-2005 14:26:54:572] nspsend: ED 2C 91 35 14 B7 C0 68  |.,.5...h|
[12-APR-2005 14:26:54:572] nspsend: 07 D5 76 37 81 67 CF B5  |..v7.g..|
[12-APR-2005 14:26:54:572] nspsend: 26 DD 92 4C FE 49 24 6B  |&..L.I$k|
[12-APR-2005 14:26:54:572] nspsend: 51 A9 F2 8B 88 F7 71 3D  |Q.....q=|
[12-APR-2005 14:26:54:572] nspsend: BA 90 9C 92 B9 F5 14 E5  |........|
[12-APR-2005 14:26:54:572] nspsend: 93 22 2C CD 78 5F AE 5E  |.",.x_.^|
[12-APR-2005 14:26:54:572] nspsend: AB D4 0F FD D8 51 57 47  |.....QWG|
[12-APR-2005 14:26:54:572] nspsend: DE 85 6D 3E 35 5B A3 72  |..m>5[.r|
[12-APR-2005 14:26:54:572] nspsend: E4 44 82 CC B2 82 B5 5F  |.D....._|
[12-APR-2005 14:26:54:572] nspsend: 0D A1 E0 F8 FC 3F 1F A4  |.....?..|
[12-APR-2005 14:26:54:572] nspsend: 76 D7 05 1B DF 35 33 5C  |v....53\|
[12-APR-2005 14:26:54:572] nspsend: 90 04 B4 96 33 46 6B 56  |....3FkV|
[12-APR-2005 14:26:54:572] nspsend: C8 5F 56 45 7C 94 ED CB  |._VE|...|
[12-APR-2005 14:26:54:572] nspsend: 9A EC 04 1A 2D 8F 47 95  |....-.G.|
[12-APR-2005 14:26:54:572] nspsend: 1E CF 3E 83 74 81 56 80  |..>.t.V.|
[12-APR-2005 14:26:54:572] nspsend: 6A 73 2F 68 17 7A 76 A3  |js/h.zv.|
[12-APR-2005 14:26:54:572] nspsend: 28 45 DB 9B 03 AE 62 83  |(E....b.|
[12-APR-2005 14:26:54:572] nspsend: BB 01 B9 EF 03 FA 59 8C  |......Y.|
[12-APR-2005 14:26:54:572] nspsend: E9 81 A5 B5 A0 9A DA C2  |........|
[12-APR-2005 14:26:54:572] nspsend: 71 18 5A 7F 28 9E 8B EC  |q.Z.(...|
[12-APR-2005 14:26:54:572] nspsend: E7 27 FD D1 D2 B7 F4 30  |.'.....0|
[12-APR-2005 14:26:54:572] nspsend: AE 96 14 95 4F B6 E0 E6  |....O...|
[12-APR-2005 14:26:54:572] nspsend: EE 49 8A 02 DD D7 D1 44  |.I.....D|
[12-APR-2005 14:26:54:572] nspsend: 58 E2 8D A9 9B 7F C2 81  |X.......|
[12-APR-2005 14:26:54:572] nspsend: 1D 30 F3 6E A9 0B 70 02  |.0.n..p.|
[12-APR-2005 14:26:54:572] nspsend: E4 1C EA F9 2E 83 D5 0D  |........|
[12-APR-2005 14:26:54:572] nspsend: DE 27 F7 51 D7 D1 FC 44  |.'.Q...D|
[12-APR-2005 14:26:54:572] nspsend: D6 B0 C7 E8 7E B4 02 91  |....~...|
[12-APR-2005 14:26:54:572] nspsend: F5 6F 5B DA 36 73 F3 15  |.o[.6s..|
[12-APR-2005 14:26:54:572] nspsend: 23 0B 54 42 E8 A4 E2 AA  |#.TB....|
[12-APR-2005 14:26:54:572] nspsend: 6A 6C 7B F3 73 79 6E 78  |jl{.synx|
[12-APR-2005 14:26:54:572] nspsend: 35 8C EF D5 B3 17 35 C2  |5.....5.|
[12-APR-2005 14:26:54:572] nspsend: 75 96 79 C7 7E B3 5F CE  |u.y.~._.|
[12-APR-2005 14:26:54:572] nspsend: 6A BA B8 38 7A A7 70 EA  |j..8z.p.|
[12-APR-2005 14:26:54:572] nspsend: 2F 80 F1 D1 95 A9 9F DE  |/.......|
[12-APR-2005 14:26:54:572] nspsend: 3A 8A 10 19 8C AE 8B F0  |:.......|
[12-APR-2005 14:26:54:572] nspsend: BD AB 8E 13 5F 42 B9 3E  |...._B.>|
[12-APR-2005 14:26:54:572] nspsend: 03 A2 2B 44 39 CA 14 0D  |..+D9...|
[12-APR-2005 14:26:54:572] nspsend: 0A 2C 50 41 37 BF 1F 20  |.,PA7...|
[12-APR-2005 14:26:54:572] nspsend: F0 90 29 8F EA 6F BF F5  |..)..o..|
[12-APR-2005 14:26:54:572] nspsend: 2A 78 48 72 9B D5 65 F6  |*xHr..e.|
[12-APR-2005 14:26:54:572] nspsend: 9B 3F 02 63 22 46 77 2F  |.?.c"Fw/|
[12-APR-2005 14:26:54:572] nspsend: A7 49 12 1A EB 9A AD 9D  |.I......|
[12-APR-2005 14:26:54:572] nspsend: 05 E4 C9 A7 A4 AD 2E 93  |........|
[12-APR-2005 14:26:54:572] nspsend: A0 C9 C9 8A C3 4F E7 CD  |.....O..|
[12-APR-2005 14:26:54:572] nspsend: 0D 26 42 F6 E2 DB 82 43  |.&B....C|
[12-APR-2005 14:26:54:572] nspsend: 38 DD E3 F6 2D 3D AB 23  |8...-=.#|
[12-APR-2005 14:26:54:572] nspsend: 26 43 46 A6 56 8A 53 75  |&CF.V.Su|
[12-APR-2005 14:26:54:572] nspsend: 97 EC F4 0D F4 B1 D7 59  |.......Y|
[12-APR-2005 14:26:54:572] nspsend: 2F 67 26 8F 43 26 BA 43  |/g&.C&.C|
[12-APR-2005 14:26:54:572] nspsend: D4 6A 4F AE 88 E3 7C 9D  |.jO...|.|
[12-APR-2005 14:26:54:572] nspsend: C1 84 58 93 0D BE F1 DF  |..X.....|
[12-APR-2005 14:26:54:572] nspsend: 9A 6D AE 17 6E D7 DF 22  |.m..n.."|
[12-APR-2005 14:26:54:572] nspsend: 1E 39 8E 04 8D 60 A7 E7  |.9...`..|
[12-APR-2005 14:26:54:572] nspsend: 97 84 C2 A3 C3 8A 5F FF  |......_.|
[12-APR-2005 14:26:54:572] nspsend: A2 AA C8 76 A9 59 F0 B6  |...v.Y..|
[12-APR-2005 14:26:54:572] nspsend: FF F6 B1 80 15 26 33 33  |.....&33|
[12-APR-2005 14:26:54:572] nspsend: F7 60 64 A2 E5 8D 31 63  |.`d...1c|
[12-APR-2005 14:26:54:572] nspsend: AF 1D E0 8D 84 80 9A 78  |.......x|
[12-APR-2005 14:26:54:572] nspsend: 44 C1 A4 30 09 1B 8E DC  |D..0....|
[12-APR-2005 14:26:54:572] nspsend: 90 CF 28 E9 C5 7A 83 14  |..(..z..|
[12-APR-2005 14:26:54:572] nspsend: 6C D1 BD 85 A5 B2 BA A7  |l.......|
[12-APR-2005 14:26:54:572] nspsend: FA 2F E9 A8 4A BC 92 5E  |./..J..^|
[12-APR-2005 14:26:54:572] nspsend: 18 CD CA 4D BB B2 B5 E1  |...M....|
[12-APR-2005 14:26:54:572] nspsend: 98 EC 64 C5 FA E3 BC 4B  |..d....K|
[12-APR-2005 14:26:54:572] nspsend: C0 24 93 F4 53 B3 8F 35  |.$..S..5|
[12-APR-2005 14:26:54:572] nspsend: 30 4E 88 19 7B 7C EC FD  |0N..{|..|
[12-APR-2005 14:26:54:572] nspsend: 12 F0 73 E3 8E 28 C9 F6  |..s..(..|
[12-APR-2005 14:26:54:572] nspsend: 85 CA 61 D9 19 B8 FC 07  |..a.....|
[12-APR-2005 14:26:54:572] nspsend: 46 19 60 C1 35 A7 8C 18  |F.`.5...|
[12-APR-2005 14:26:54:572] nspsend: E8 52 EB ED 83 A1 1F 74  |.R.....t|
[12-APR-2005 14:26:54:572] nspsend: 0E A7 E0 A4 81 43 0A FC  |.....C..|
[12-APR-2005 14:26:54:572] nspsend: D9 CE 9A 8B CF 90 8D 2F  |......./|
[12-APR-2005 14:26:54:572] nspsend: A1 74 A3 0B 04 C5 F9 9D  |.t......|
[12-APR-2005 14:26:54:572] nspsend: 67 4A D7 67 0A 37 5E 29  |gJ.g.7^)|
[12-APR-2005 14:26:54:572] nspsend: 59 C3 6F 7B 1B EB FC 9D  |Y.o{....|
[12-APR-2005 14:26:54:572] nspsend: 40 23 E3 F7 E0 FD 26 C0  |@#....&.|
[12-APR-2005 14:26:54:572] nspsend: 9A 29 10 36 C1 E7 EA D9  |.).6....|
[12-APR-2005 14:26:54:572] nspsend: 8B 43 49 02 ED B6 82 A0  |.CI.....|
[12-APR-2005 14:26:54:572] nspsend: C2 F6 93 97 D4 1A 15 85  |........|
[12-APR-2005 14:26:54:572] nspsend: 85 F4 2A 3E 3E A1 30 2B  |..*>>.0+|
[12-APR-2005 14:26:54:572] nspsend: 30 5C 33 F6 B9 29 28 25  |0\3..)(%|
[12-APR-2005 14:26:54:572] nspsend: E2 2B 22 20 62 16 67 F3  |.+".b.g.|
[12-APR-2005 14:26:54:572] nspsend: C0 B9 C8 64 45 64 A8 0C  |...dEd..|
[12-APR-2005 14:26:54:582] nspsend: D5 33 83 1A 7F 2D E3 7F  |.3...-..|
[12-APR-2005 14:26:54:582] nspsend: 40 D1 C4 BF DB D9 81 9D  |@.......|
[12-APR-2005 14:26:54:582] nspsend: 6E 24 AC D3 FA 7A 15 43  |n$...z.C|
[12-APR-2005 14:26:54:582] nspsend: F8 C7 9D C0 6C A0 00 6C  |....l..l|
[12-APR-2005 14:26:54:582] nspsend: 85 DF 5C 36 25 9E 6D B5  |..\6%.m.|
[12-APR-2005 14:26:54:582] nspsend: 37 BD CF 29 40 19 AD F8  |7..)@...|
[12-APR-2005 14:26:54:582] nspsend: A9 35 F2 41 7D AF 51 E7  |.5.A}.Q.|
[12-APR-2005 14:26:54:582] nspsend: E0 5F E6 C4 DD E2 2F 76  |._..../v|
[12-APR-2005 14:26:54:582] nspsend: 27 54 AE 0D 23 4E 7C 16  |'T..#N|.|
[12-APR-2005 14:26:54:582] nspsend: 23 0B 5C 15 C0 56 BD 0D  |#.\..V..|
[12-APR-2005 14:26:54:582] nspsend: 31 E9 FF 3B 58 2B 9C 3F  |1..;X+.?|
[12-APR-2005 14:26:54:582] nspsend: A9 6E 64 72 AA 1E 6E 20  |.ndr..n.|
[12-APR-2005 14:26:54:582] nspsend: 2B 8E DB 3D FF 53 7C 9E  |+..=.S|.|
[12-APR-2005 14:26:54:582] nspsend: E4 17 FD 6A 2E 55 AA 5B  |...j.U.[|
[12-APR-2005 14:26:54:582] nspsend: 24 12 A4 81 BE 30 81 BB  |$....0..|
[12-APR-2005 14:26:54:582] nspsend: A0 03 02 01 17 A2 81 B3  |........|
[12-APR-2005 14:26:54:582] nspsend: 04 81 B0 DA 4D 3A A0 22  |....M:."|
[12-APR-2005 14:26:54:582] nspsend: 27 8B 06 F7 18 17 09 70  |'......p|
[12-APR-2005 14:26:54:582] nspsend: 43 44 C2 B4 BF F0 1C A1  |CD......|
[12-APR-2005 14:26:54:582] nspsend: 2B 25 9E 8A 41 2F 18 39  |+%..A/.9|
[12-APR-2005 14:26:54:582] nspsend: 24 A9 B9 36 43 31 22 D3  |$..6C1".|
[12-APR-2005 14:26:54:582] nspsend: 00 79 CD 49 66 B8 E7 7D  |.y.If..}|
[12-APR-2005 14:26:54:582] nspsend: 3E 6E 00 F8 8F D1 E3 B1  |>n......|
[12-APR-2005 14:26:54:582] nspsend: CE 55 83 48 AF 1D 6B E8  |.U.H..k.|
[12-APR-2005 14:26:54:582] nspsend: C4 3F 83 1B 6E EF C6 90  |.?..n...|
[12-APR-2005 14:26:54:582] nspsend: F9 00 4E 62 BD 0A 84 DC  |..Nb....|
[12-APR-2005 14:26:54:582] nspsend: 3C 1B 9C 15 24 D0 71 1B  |<...$.q.|
[12-APR-2005 14:26:54:582] nspsend: D5 37 E1 9C 88 36 CE DC  |.7...6..|
[12-APR-2005 14:26:54:582] nspsend: 0D 95 74 9E 8F 89 CC 1B  |..t.....|
[12-APR-2005 14:26:54:582] nspsend: 43 63 E4 D3 AC 15 4C F3  |Cc....L.|
[12-APR-2005 14:26:54:582] nspsend: DE B4 7F 7E 14 73 E8 2D  |...~.s.-|
[12-APR-2005 14:26:54:582] nspsend: C1 A9 B0 92 AF A0 BB 8B  |........|
[12-APR-2005 14:26:54:582] nspsend: 85 DC 44 BE B7 E8 F6 BB  |..D.....|
[12-APR-2005 14:26:54:582] nspsend: 88 1B B6 A7 3F FA C8 9F  |....?...|
[12-APR-2005 14:26:54:582] nspsend: 90 46 A5 8C CF 6A 69 14  |.F...ji.|
[12-APR-2005 14:26:54:582] nspsend: 89 2C 5E 39 AE F7 41 DD  |.,^9..A.|
[12-APR-2005 14:26:54:582] nspsend: 7E 60 0D 1C FC 65 E2 EE  |~`...e..|
[12-APR-2005 14:26:54:582] nspsend: 76 FB 99 59 75 1C E3 70  |v..Yu..p|
[12-APR-2005 14:26:54:582] nspsend: 7C A3 69                 ||.i     |
[12-APR-2005 14:26:54:582] nspsend: normal exit
[12-APR-2005 14:26:54:582] nsdofls: exit (0)
[12-APR-2005 14:26:54:582] nsdoacts: flushing transport
[12-APR-2005 14:26:54:582] nttctl: entry
[12-APR-2005 14:26:54:582] nsdoacts: normal exit
[12-APR-2005 14:26:54:582] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:582] nsdo: normal exit
[12-APR-2005 14:26:54:582] nsnasend: normal exit
[12-APR-2005 14:26:54:582] nacompd: entry
[12-APR-2005 14:26:54:582] nacompd: exit
[12-APR-2005 14:26:54:582] nacomsn: exit
[12-APR-2005 14:26:54:582] snauicomparehash: entry
[12-APR-2005 14:26:54:582] nacomrc: entry
[12-APR-2005 14:26:54:582] nacompd: entry
[12-APR-2005 14:26:54:582] nacompd: exit
[12-APR-2005 14:26:54:582] nsnareceive: entry
[12-APR-2005 14:26:54:582] nsnareceive: buffer address: 0x128540 bytes wanted: 2048
[12-APR-2005 14:26:54:582] nsnareceive: calling NS to receive 2048 bytes into address 0x128540
[12-APR-2005 14:26:54:582] nsdo: entry
[12-APR-2005 14:26:54:582] nsdo: cid=0, opcode=68, *bl=2048, *what=0, uflgs=0x0, cflgs=0x3
[12-APR-2005 14:26:54:582] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:582] nsdo: nsctx: state=8, flg=0x102420d, mvd=0
[12-APR-2005 14:26:54:582] nsdo: gtn=69, gtc=69, ptn=10, ptc=2011
[12-APR-2005 14:26:54:582] nsrdr: entry
[12-APR-2005 14:26:54:582] nsrdr: recving a packet
[12-APR-2005 14:26:54:582] nsprecv: entry
[12-APR-2005 14:26:54:582] nsprecv: reading from transport...
[12-APR-2005 14:26:54:582] nttrd: entry
[12-APR-2005 14:26:54:622] nttrd: socket 256 had bytes read=176
[12-APR-2005 14:26:54:622] nttrd: exit
[12-APR-2005 14:26:54:622] nsprecv: 176 bytes from transport
[12-APR-2005 14:26:54:622] nsprecv: tlen=176, plen=176, type=6
[12-APR-2005 14:26:54:622] nsprecv: packet dump
[12-APR-2005 14:26:54:622] nsprecv: 00 B0 00 00 06 04 00 00  |........|
[12-APR-2005 14:26:54:622] nsprecv: 00 00 DE AD BE EF 00 A6  |........|
[12-APR-2005 14:26:54:622] nsprecv: 09 20 01 00 00 01 00 00  |........|
[12-APR-2005 14:26:54:622] nsprecv: 01 00 02 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:622] nsprecv: 04 00 01 85 00 00 00 00  |........|
[12-APR-2005 14:26:54:622] nsprecv: 85 00 01 60 81 82 06 09  |...`....|
[12-APR-2005 14:26:54:622] nsprecv: 2A 86 48 86 F7 12 01 02  |*.H.....|
[12-APR-2005 14:26:54:622] nsprecv: 02 02 00 6F 73 30 71 A0  |...os0q.|
[12-APR-2005 14:26:54:622] nsprecv: 03 02 01 05 A1 03 02 01  |........|
[12-APR-2005 14:26:54:622] nsprecv: 0F A2 65 30 63 A0 03 02  |..e0c...|
[12-APR-2005 14:26:54:622] nsprecv: 01 17 A2 5C 04 5A BE 0B  |...\.Z..|
[12-APR-2005 14:26:54:622] nsprecv: 7E 38 25 CA 1D 7D 71 90  |~8%..}q.|
[12-APR-2005 14:26:54:622] nsprecv: 83 ED B9 DE DC F3 E9 CC  |........|
[12-APR-2005 14:26:54:622] nsprecv: 41 A0 74 0A 69 9E A8 7D  |A.t.i..}|
[12-APR-2005 14:26:54:622] nsprecv: 6F 6D FD CB C7 FA 99 53  |om.....S|
[12-APR-2005 14:26:54:622] nsprecv: 28 7D 81 C3 19 21 5E 96  |(}...!^.|
[12-APR-2005 14:26:54:622] nsprecv: 08 14 F3 0D 3D 0E C7 50  |....=..P|
[12-APR-2005 14:26:54:622] nsprecv: 49 6A 15 65 E5 0A 91 1C  |Ij.e....|
[12-APR-2005 14:26:54:622] nsprecv: E7 98 B4 A9 F5 3D 48 93  |.....=H.|
[12-APR-2005 14:26:54:622] nsprecv: 61 B9 1A 8C 74 69 37 D4  |a...ti7.|
[12-APR-2005 14:26:54:622] nsprecv: BD 49 F4 B7 30 12 42 95  |.I..0.B.|
[12-APR-2005 14:26:54:622] nsprecv: 88 6C 49 07 D9 DD 6F 2A  |.lI...o*|
[12-APR-2005 14:26:54:622] nsprecv: normal exit
[12-APR-2005 14:26:54:622] nsrdr: got NSPTDA packet
[12-APR-2005 14:26:54:622] nsrdr: NSPTDA flags: 0x0
[12-APR-2005 14:26:54:622] nsrdr: normal exit
[12-APR-2005 14:26:54:622] nsdo: *what=1, *bl=2048
[12-APR-2005 14:26:54:622] nsdo: 166 bytes from NS buffer
[12-APR-2005 14:26:54:622] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:622] nsdo: normal exit
[12-APR-2005 14:26:54:622] nsnareceive: received 166 bytes
[12-APR-2005 14:26:54:622] nsnareceive: no more data to receive - returning
[12-APR-2005 14:26:54:622] nsnareceive: normal exit
[12-APR-2005 14:26:54:622] nsnareceive: total bytes received: 166
[12-APR-2005 14:26:54:622] nacomrc: received 166 bytes
[12-APR-2005 14:26:54:622] nacomrc: total data length: 166 bytes
[12-APR-2005 14:26:54:622] nacomrc: Version received: Oracle Advanced Security: Oracle Advanced Security for 32-bit Windows: Version 9.2.0.1.0 - Production
[12-APR-2005 14:26:54:622] nacomrc: Length      166
       # of services      1
       Error rec'd?      FALSE
[12-APR-2005 14:26:54:622] nacomus: entry
[12-APR-2005 14:26:54:622] nacomus: service      authentication
       # of fields      2
       ORACLE error      0
[12-APR-2005 14:26:54:622] nacomdp: entry
[12-APR-2005 14:26:54:622] nacomdp: direction:      inbound
       service:      authentication
       data type:      raw data
       data length:      4
[12-APR-2005 14:26:54:622] nacomdp: exit
[12-APR-2005 14:26:54:622] nacomdp: entry
[12-APR-2005 14:26:54:622] nacomdp: direction:      inbound
       service:      authentication
       data type:      raw data
       data length:      133
[12-APR-2005 14:26:54:622] nacomdp: exit
[12-APR-2005 14:26:54:622] nacomus: exit
[12-APR-2005 14:26:54:622] nacomrc: exit
[12-APR-2005 14:26:54:622] snauicomparehash: exit
[12-APR-2005 14:26:54:622] na_csrd: entry
[12-APR-2005 14:26:54:622] nau_ccn: entry
[12-APR-2005 14:26:54:622] naunauthent: entry
[12-APR-2005 14:26:54:622] nacomrp: entry
[12-APR-2005 14:26:54:622] nacomrp: exit
[12-APR-2005 14:26:54:622] nacomrp: entry
[12-APR-2005 14:26:54:622] nacomrp: exit
[12-APR-2005 14:26:54:622] nacomsd: entry
[12-APR-2005 14:26:54:622] nacomfsd: entry
[12-APR-2005 14:26:54:622] nacomfsd: exit
[12-APR-2005 14:26:54:622] nacomdp: entry
[12-APR-2005 14:26:54:622] nacomdp: direction:      outbound
       service:      authentication
       data type:      raw data
       data length:      4
[12-APR-2005 14:26:54:622] nacomdp: exit
[12-APR-2005 14:26:54:622] nacomsd: exit
[12-APR-2005 14:26:54:622] nacomsd: entry
[12-APR-2005 14:26:54:622] nacomfsd: entry
[12-APR-2005 14:26:54:622] nacomfsd: exit
[12-APR-2005 14:26:54:622] nacomdp: entry
[12-APR-2005 14:26:54:622] nacomdp: direction:      outbound
       service:      authentication
       data type:      raw data
       data length:      0
[12-APR-2005 14:26:54:622] nacomdp: exit
[12-APR-2005 14:26:54:622] nacomsd: exit
[12-APR-2005 14:26:54:622] naunauthent: exit
[12-APR-2005 14:26:54:622] nau_ccn: client handshake succeeded
[12-APR-2005 14:26:54:622] nau_ccn: exit
[12-APR-2005 14:26:54:622] na_csrd: exit
[12-APR-2005 14:26:54:622] nacomsn: entry
[12-APR-2005 14:26:54:622] nacomap: entry
[12-APR-2005 14:26:54:622] nacomap: Packet length      33
       # of services      1
       Error sent?      FALSE
[12-APR-2005 14:26:54:622] nacomap: Version transmitted: Oracle Advanced Security: Oracle Advanced Security for 32-bit Windows: Version 9.2.0.1.0 - Production
[12-APR-2005 14:26:54:622] nacomps: entry
[12-APR-2005 14:26:54:622] nacomps: service      authentication
       # of fields      2
       ORACLE error      0
[12-APR-2005 14:26:54:622] nacomps:       data length      4
            data type      raw data
[12-APR-2005 14:26:54:622] nacomps:       data length      0
            data type      raw data
[12-APR-2005 14:26:54:622] nacomps: exit
[12-APR-2005 14:26:54:622] nacomap: exit
[12-APR-2005 14:26:54:622] nacomsn: sending 33 bytes
[12-APR-2005 14:26:54:622] nsnasend: entry
[12-APR-2005 14:26:54:622] nsnasend: bytes to send: 33
[12-APR-2005 14:26:54:622] nsdo: entry
[12-APR-2005 14:26:54:622] nsdo: cid=0, opcode=67, *bl=33, *what=1, uflgs=0x22, cflgs=0x3
[12-APR-2005 14:26:54:622] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:622] nsdo: nsctx: state=8, flg=0x102420d, mvd=0
[12-APR-2005 14:26:54:622] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:622] nsdo: 33 bytes to NS buffer
[12-APR-2005 14:26:54:622] nsdoacts: entry
[12-APR-2005 14:26:54:622] nsdofls: entry
[12-APR-2005 14:26:54:622] nsdofls: DATA flags: 0x0
[12-APR-2005 14:26:54:622] nsdofls: sending NSPTDA packet
[12-APR-2005 14:26:54:622] nspsend: entry
[12-APR-2005 14:26:54:622] nspsend: plen=43, type=6
[12-APR-2005 14:26:54:622] nttwr: entry
[12-APR-2005 14:26:54:622] nttwr: socket 256 had bytes written=43
[12-APR-2005 14:26:54:622] nttwr: exit
[12-APR-2005 14:26:54:622] nspsend: 43 bytes to transport
[12-APR-2005 14:26:54:622] nspsend: packet dump
[12-APR-2005 14:26:54:622] nspsend: 00 2B 00 00 06 04 00 00  |.+......|
[12-APR-2005 14:26:54:622] nspsend: 00 00 DE AD BE EF 00 21  |.......!|
[12-APR-2005 14:26:54:622] nspsend: 09 20 01 00 00 01 00 00  |........|
[12-APR-2005 14:26:54:622] nspsend: 01 00 02 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:622] nspsend: 04 00 01 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:622] nspsend: 00 00 01                 |...     |
[12-APR-2005 14:26:54:622] nspsend: normal exit
[12-APR-2005 14:26:54:622] nsdofls: exit (0)
[12-APR-2005 14:26:54:622] nsdoacts: flushing transport
[12-APR-2005 14:26:54:622] nttctl: entry
[12-APR-2005 14:26:54:622] nsdoacts: normal exit
[12-APR-2005 14:26:54:622] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:622] nsdo: normal exit
[12-APR-2005 14:26:54:622] nsnasend: normal exit
[12-APR-2005 14:26:54:622] nacompd: entry
[12-APR-2005 14:26:54:622] nacompd: exit
[12-APR-2005 14:26:54:622] nacomsn: exit
[12-APR-2005 14:26:54:622] na_client: all services done
[12-APR-2005 14:26:54:622] na_client: exit
[12-APR-2005 14:26:54:622] na_coco: entry
[12-APR-2005 14:26:54:622] nau_cco: entry
[12-APR-2005 14:26:54:622] nau_cco: exit
[12-APR-2005 14:26:54:622] naeecom: entry
[12-APR-2005 14:26:54:622] naeecom: Encryption inactive
[12-APR-2005 14:26:54:622] naeecom: exit
[12-APR-2005 14:26:54:622] naeccom: entry
[12-APR-2005 14:26:54:622] naeccom: Crypto-Checksumming inactive
[12-APR-2005 14:26:54:622] naeccom: exit
[12-APR-2005 14:26:54:622] na_tns: entry
[12-APR-2005 14:26:54:632] na_tns: Secure Network Services is available.
[12-APR-2005 14:26:54:632] nau_adi: entry
[12-APR-2005 14:26:54:632] nau_adi: exit
[12-APR-2005 14:26:54:632] na_tns:       authentication is active, using NTS
[12-APR-2005 14:26:54:632] na_tns:       encryption is not active
[12-APR-2005 14:26:54:632] na_tns:       crypto-checksumming is not active
[12-APR-2005 14:26:54:632] na_tns: exit
[12-APR-2005 14:26:54:632] na_coco: exit
[12-APR-2005 14:26:54:632] naconnect: exit
[12-APR-2005 14:26:54:632] nsnafinishconn: entry
[12-APR-2005 14:26:54:632] nagetctxinfo: entry
[12-APR-2005 14:26:54:632] nagetctxinfo: exit
[12-APR-2005 14:26:54:632] nsnafinishconn: normal exit
[12-APR-2005 14:26:54:632] nsnadoconn: normal exit
[12-APR-2005 14:26:54:632] nsnaconn: normal exit
[12-APR-2005 14:26:54:632] nscall: normal exit
[12-APR-2005 14:26:54:632] niotns: niotns: passing ns handle back up...
[12-APR-2005 14:26:54:632] nsballoc: entry
[12-APR-2005 14:26:54:632] nsbgetfl: entry
[12-APR-2005 14:26:54:632] nsbgetfl: normal exit
[12-APR-2005 14:26:54:632] nsmal: entry
[12-APR-2005 14:26:54:632] nsmal: 48 bytes at 0xe15ac0
[12-APR-2005 14:26:54:632] nsmal: normal exit
[12-APR-2005 14:26:54:632] nsballoc: normal exit
[12-APR-2005 14:26:54:632] nsballoc: entry
[12-APR-2005 14:26:54:632] nsbgetfl: entry
[12-APR-2005 14:26:54:632] nsbgetfl: normal exit
[12-APR-2005 14:26:54:632] nsmal: entry
[12-APR-2005 14:26:54:632] nsmal: 48 bytes at 0xe077b0
[12-APR-2005 14:26:54:632] nsmal: normal exit
[12-APR-2005 14:26:54:632] nsballoc: normal exit
[12-APR-2005 14:26:54:632] niotns: exit
[12-APR-2005 14:26:54:632] nioqsn: entry
[12-APR-2005 14:26:54:632] nioqrc: entry
[12-APR-2005 14:26:54:632] nsdo: entry
[12-APR-2005 14:26:54:632] nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3
[12-APR-2005 14:26:54:632] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:632] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:632] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:632] nsdofls: entry
[12-APR-2005 14:26:54:632] nsdofls: DATA flags: 0x0
[12-APR-2005 14:26:54:632] nsdofls: sending NSPTDA packet
[12-APR-2005 14:26:54:632] nspsend: entry
[12-APR-2005 14:26:54:632] nspsend: plen=37, type=6
[12-APR-2005 14:26:54:632] nttwr: entry
[12-APR-2005 14:26:54:632] nttwr: socket 256 had bytes written=37
[12-APR-2005 14:26:54:632] nttwr: exit
[12-APR-2005 14:26:54:632] nspsend: 37 bytes to transport
[12-APR-2005 14:26:54:632] nspsend: packet dump
[12-APR-2005 14:26:54:632] nspsend: 00 25 00 00 06 04 00 00  |.%......|
[12-APR-2005 14:26:54:632] nspsend: 00 00 01 06 05 04 03 02  |........|
[12-APR-2005 14:26:54:632] nspsend: 01 00 49 42 4D 50 43 2F  |..IBMPC/|
[12-APR-2005 14:26:54:632] nspsend: 57 49 4E 5F 4E 54 2D 38  |WIN_NT-8|
[12-APR-2005 14:26:54:632] nspsend: 2E 31 2E 30 00           |.1.0.   |
[12-APR-2005 14:26:54:632] nspsend: normal exit
[12-APR-2005 14:26:54:632] nsdofls: exit (0)
[12-APR-2005 14:26:54:632] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:632] nsdo: normal exit
[12-APR-2005 14:26:54:632] nsdo: entry
[12-APR-2005 14:26:54:632] nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3
[12-APR-2005 14:26:54:632] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:632] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:632] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:632] nsdo: switching to application buffer
[12-APR-2005 14:26:54:632] nsrdr: entry
[12-APR-2005 14:26:54:632] nsrdr: recving a packet
[12-APR-2005 14:26:54:632] nsprecv: entry
[12-APR-2005 14:26:54:632] nsprecv: reading from transport...
[12-APR-2005 14:26:54:632] nttrd: entry
[12-APR-2005 14:26:54:672] nttrd: socket 256 had bytes read=164
[12-APR-2005 14:26:54:672] nttrd: exit
[12-APR-2005 14:26:54:672] nsprecv: 164 bytes from transport
[12-APR-2005 14:26:54:672] nsprecv: tlen=164, plen=164, type=6
[12-APR-2005 14:26:54:672] nsprecv: packet dump
[12-APR-2005 14:26:54:672] nsprecv: 00 A4 00 00 06 04 00 00  |........|
[12-APR-2005 14:26:54:672] nsprecv: 00 00 01 06 00 49 42 4D  |.....IBM|
[12-APR-2005 14:26:54:672] nsprecv: 50 43 2F 57 49 4E 5F 4E  |PC/WIN_N|
[12-APR-2005 14:26:54:672] nsprecv: 54 2D 38 2E 31 2E 30 00  |T-8.1.0.|
[12-APR-2005 14:26:54:672] nsprecv: 01 00 01 00 00 00 64 00  |......d.|
[12-APR-2005 14:26:54:672] nsprecv: 00 00 60 01 24 0F 05 0B  |..`.$...|
[12-APR-2005 14:26:54:672] nsprecv: 0C 03 0C 0C 05 04 05 0D  |........|
[12-APR-2005 14:26:54:672] nsprecv: 06 09 07 08 05 0F 05 05  |........|
[12-APR-2005 14:26:54:672] nsprecv: 05 0F 05 05 05 05 05 0A  |........|
[12-APR-2005 14:26:54:672] nsprecv: 05 05 05 05 05 04 05 06  |........|
[12-APR-2005 14:26:54:672] nsprecv: 07 08 08 23 47 23 23 08  |...#G##.|
[12-APR-2005 14:26:54:672] nsprecv: 11 23 08 11 41 B0 23 00  |.#..A.#.|
[12-APR-2005 14:26:54:672] nsprecv: 83 00 01 07 D0 03 00 00  |........|
[12-APR-2005 14:26:54:672] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:672] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:672] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:672] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:672] nsprecv: 00 00 00 15 06 01 01 01  |........|
[12-APR-2005 14:26:54:672] nsprecv: 05 01 01 02 01 01 01 01  |........|
[12-APR-2005 14:26:54:672] nsprecv: 01 01 01 3F 0F 03 06 03  |...?....|
[12-APR-2005 14:26:54:672] nsprecv: 00 02 02 01              |....    |
[12-APR-2005 14:26:54:672] nsprecv: normal exit
[12-APR-2005 14:26:54:672] nsrdr: got NSPTDA packet
[12-APR-2005 14:26:54:672] nsrdr: NSPTDA flags: 0x0
[12-APR-2005 14:26:54:672] nsrdr: normal exit
[12-APR-2005 14:26:54:672] nsdo: *what=1, *bl=2001
[12-APR-2005 14:26:54:672] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:672] nsdo: normal exit
[12-APR-2005 14:26:54:672] nioqrc: exit
[12-APR-2005 14:26:54:672] nioqsn: entry
[12-APR-2005 14:26:54:672] nioqrc: entry
[12-APR-2005 14:26:54:672] nsdo: entry
[12-APR-2005 14:26:54:672] nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3
[12-APR-2005 14:26:54:672] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:672] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:672] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:672] nsdofls: entry
[12-APR-2005 14:26:54:672] nsdofls: DATA flags: 0x0
[12-APR-2005 14:26:54:672] nsdofls: sending NSPTDA packet
[12-APR-2005 14:26:54:672] nspsend: entry
[12-APR-2005 14:26:54:672] nspsend: plen=52, type=6
[12-APR-2005 14:26:54:672] nttwr: entry
[12-APR-2005 14:26:54:672] nttwr: socket 256 had bytes written=52
[12-APR-2005 14:26:54:672] nttwr: exit
[12-APR-2005 14:26:54:672] nspsend: 52 bytes to transport
[12-APR-2005 14:26:54:672] nspsend: packet dump
[12-APR-2005 14:26:54:672] nspsend: 00 34 00 00 06 04 00 00  |.4......|
[12-APR-2005 14:26:54:672] nspsend: 00 00 02 01 00 01 00 02  |........|
[12-APR-2005 14:26:54:672] nspsend: 15 06 01 01 01 05 01 01  |........|
[12-APR-2005 14:26:54:672] nspsend: 02 01 01 01 01 01 01 01  |........|
[12-APR-2005 14:26:54:672] nspsend: 3F 0F 03 06 03 00 02 02  |?.......|
[12-APR-2005 14:26:54:672] nspsend: 01 80 00 00 00 3C 3C 3C  |.....<<<|
[12-APR-2005 14:26:54:672] nspsend: 80 00 00 00              |....    |
[12-APR-2005 14:26:54:672] nspsend: normal exit
[12-APR-2005 14:26:54:672] nsdofls: exit (0)
[12-APR-2005 14:26:54:672] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:672] nsdo: normal exit
[12-APR-2005 14:26:54:672] nsdo: entry
[12-APR-2005 14:26:54:672] nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3
[12-APR-2005 14:26:54:672] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:672] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:672] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:672] nsdo: switching to application buffer
[12-APR-2005 14:26:54:672] nsrdr: entry
[12-APR-2005 14:26:54:672] nsrdr: recving a packet
[12-APR-2005 14:26:54:672] nsprecv: entry
[12-APR-2005 14:26:54:672] nsprecv: reading from transport...
[12-APR-2005 14:26:54:672] nttrd: entry
[12-APR-2005 14:26:54:682] nttrd: socket 256 had bytes read=22
[12-APR-2005 14:26:54:682] nttrd: exit
[12-APR-2005 14:26:54:682] nsprecv: 22 bytes from transport
[12-APR-2005 14:26:54:682] nsprecv: tlen=22, plen=22, type=6
[12-APR-2005 14:26:54:682] nsprecv: packet dump
[12-APR-2005 14:26:54:682] nsprecv: 00 16 00 00 06 04 00 00  |........|
[12-APR-2005 14:26:54:682] nsprecv: 00 00 02 80 00 00 00 35  |.......5|
[12-APR-2005 14:26:54:682] nsprecv: 3C 3C 80 00 00 00        |<<....  |
[12-APR-2005 14:26:54:682] nsprecv: normal exit
[12-APR-2005 14:26:54:682] nsrdr: got NSPTDA packet
[12-APR-2005 14:26:54:682] nsrdr: NSPTDA flags: 0x0
[12-APR-2005 14:26:54:682] nsrdr: normal exit
[12-APR-2005 14:26:54:682] nsdo: *what=1, *bl=2001
[12-APR-2005 14:26:54:682] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:682] nsdo: normal exit
[12-APR-2005 14:26:54:682] nioqrc: exit
[12-APR-2005 14:26:54:682] nioqsn: entry
[12-APR-2005 14:26:54:682] nioqrc: entry
[12-APR-2005 14:26:54:682] nsdo: entry
[12-APR-2005 14:26:54:682] nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3
[12-APR-2005 14:26:54:682] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:682] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:682] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:682] nsdofls: entry
[12-APR-2005 14:26:54:682] nsdofls: DATA flags: 0x0
[12-APR-2005 14:26:54:682] nsdofls: sending NSPTDA packet
[12-APR-2005 14:26:54:682] nspsend: entry
[12-APR-2005 14:26:54:682] nspsend: plen=194, type=6
[12-APR-2005 14:26:54:682] nttwr: entry
[12-APR-2005 14:26:54:682] nttwr: socket 256 had bytes written=194
[12-APR-2005 14:26:54:682] nttwr: exit
[12-APR-2005 14:26:54:682] nspsend: 194 bytes to transport
[12-APR-2005 14:26:54:682] nspsend: packet dump
[12-APR-2005 14:26:54:682] nspsend: 00 C2 00 00 06 04 00 00  |........|
[12-APR-2005 14:26:54:682] nspsend: 00 00 03 76 02 F8 A1 DE  |...v....|
[12-APR-2005 14:26:54:682] nspsend: 00 0B 00 00 00 01 00 00  |........|
[12-APR-2005 14:26:54:682] nspsend: 00 00 D4 12 00 04 00 00  |........|
[12-APR-2005 14:26:54:682] nspsend: 00 D0 D1 12 00 C0 D5 12  |........|
[12-APR-2005 14:26:54:682] nspsend: 00 0B 64 65 76 65 6C 6F  |..develo|
[12-APR-2005 14:26:54:682] nspsend: 70 6D 65 6E 74 0D 00 00  |pment...|
[12-APR-2005 14:26:54:682] nspsend: 00 0D 41 55 54 48 5F 54  |..AUTH_T|
[12-APR-2005 14:26:54:682] nspsend: 45 52 4D 49 4E 41 4C 06  |ERMINAL.|
[12-APR-2005 14:26:54:682] nspsend: 00 00 00 06 55 44 45 56  |....UDEV|
[12-APR-2005 14:26:54:682] nspsend: 31 39 00 00 00 00 0F 00  |19......|
[12-APR-2005 14:26:54:682] nspsend: 00 00 0F 41 55 54 48 5F  |...AUTH_|
[12-APR-2005 14:26:54:682] nspsend: 50 52 4F 47 52 41 4D 5F  |PROGRAM_|
[12-APR-2005 14:26:54:682] nspsend: 4E 4D 0C 00 00 00 0C 73  |NM.....s|
[12-APR-2005 14:26:54:682] nspsend: 71 6C 70 6C 75 73 77 2E  |qlplusw.|
[12-APR-2005 14:26:54:682] nspsend: 65 78 65 00 00 00 00 0C  |exe.....|
[12-APR-2005 14:26:54:682] nspsend: 00 00 00 0C 41 55 54 48  |....AUTH|
[12-APR-2005 14:26:54:682] nspsend: 5F 4D 41 43 48 49 4E 45  |_MACHINE|
[12-APR-2005 14:26:54:682] nspsend: 0B 00 00 00 0B 4E 41 55  |.....NAU|
[12-APR-2005 14:26:54:682] nspsend: 5C 55 44 45 56 31 39 00  |\UDEV19.|
[12-APR-2005 14:26:54:682] nspsend: 00 00 00 00 08 00 00 00  |........|
[12-APR-2005 14:26:54:682] nspsend: 08 41 55 54 48 5F 50 49  |.AUTH_PI|
[12-APR-2005 14:26:54:682] nspsend: 44 08 00 00 00 08 34 38  |D.....48|
[12-APR-2005 14:26:54:682] nspsend: 30 3A 33 38 31 36 00 00  |0:3816..|
[12-APR-2005 14:26:54:682] nspsend: 00 00                    |..      |
[12-APR-2005 14:26:54:682] nspsend: normal exit
[12-APR-2005 14:26:54:682] nsdofls: exit (0)
[12-APR-2005 14:26:54:682] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:682] nsdo: normal exit
[12-APR-2005 14:26:54:682] nsdo: entry
[12-APR-2005 14:26:54:682] nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3
[12-APR-2005 14:26:54:682] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:682] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:682] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:682] nsdo: switching to application buffer
[12-APR-2005 14:26:54:682] nsrdr: entry
[12-APR-2005 14:26:54:682] nsrdr: recving a packet
[12-APR-2005 14:26:54:682] nsprecv: entry
[12-APR-2005 14:26:54:682] nsprecv: reading from transport...
[12-APR-2005 14:26:54:682] nttrd: entry
[12-APR-2005 14:26:54:783] nttrd: socket 256 had bytes read=165
[12-APR-2005 14:26:54:783] nttrd: exit
[12-APR-2005 14:26:54:783] nsprecv: 165 bytes from transport
[12-APR-2005 14:26:54:783] nsprecv: tlen=165, plen=165, type=6
[12-APR-2005 14:26:54:783] nsprecv: packet dump
[12-APR-2005 14:26:54:783] nsprecv: 00 A5 00 00 06 04 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 08 01 00 0C 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 0C 41 55 54 48 5F 53  |..AUTH_S|
[12-APR-2005 14:26:54:783] nsprecv: 45 53 53 4B 45 59 20 00  |ESSKEY..|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 20 38 30 36 43 32  |...806C2|
[12-APR-2005 14:26:54:783] nsprecv: 42 30 43 45 45 45 44 42  |B0CEEEDB|
[12-APR-2005 14:26:54:783] nsprecv: 35 31 31 31 41 32 45 45  |5111A2EE|
[12-APR-2005 14:26:54:783] nsprecv: 30 34 46 42 30 37 31 37  |04FB0717|
[12-APR-2005 14:26:54:783] nsprecv: 42 44 37 00 00 00 00 04  |BD7.....|
[12-APR-2005 14:26:54:783] nsprecv: 01 00 00 00 01 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 00 02 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 36 01 00  |.....6..|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 BC AB E0  |........|
[12-APR-2005 14:26:54:783] nsprecv: 03 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00 00 00 00  |........|
[12-APR-2005 14:26:54:783] nsprecv: 00 00 00 00 00           |.....   |
[12-APR-2005 14:26:54:783] nsprecv: normal exit
[12-APR-2005 14:26:54:783] nsrdr: got NSPTDA packet
[12-APR-2005 14:26:54:783] nsrdr: NSPTDA flags: 0x0
[12-APR-2005 14:26:54:783] nsrdr: normal exit
[12-APR-2005 14:26:54:783] nsdo: *what=1, *bl=2001
[12-APR-2005 14:26:54:783] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:783] nsdo: normal exit
[12-APR-2005 14:26:54:783] nioqrc: exit
[12-APR-2005 14:26:54:783] nioqsn: entry
[12-APR-2005 14:26:54:783] nioqrc: entry
[12-APR-2005 14:26:54:783] nsdo: entry
[12-APR-2005 14:26:54:783] nsdo: cid=0, opcode=84, *bl=0, *what=1, uflgs=0x20, cflgs=0x3
[12-APR-2005 14:26:54:783] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:783] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:783] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:783] nsdofls: entry
[12-APR-2005 14:26:54:783] nsdofls: DATA flags: 0x0
[12-APR-2005 14:26:54:783] nsdofls: sending NSPTDA packet
[12-APR-2005 14:26:54:783] nspsend: entry
[12-APR-2005 14:26:54:783] nspsend: plen=796, type=6
[12-APR-2005 14:26:54:783] nttwr: entry
[12-APR-2005 14:26:54:783] nttwr: socket 256 had bytes written=796
[12-APR-2005 14:26:54:783] nttwr: exit
[12-APR-2005 14:26:54:783] nspsend: 796 bytes to transport
[12-APR-2005 14:26:54:783] nspsend: packet dump
[12-APR-2005 14:26:54:783] nspsend: 03 1C 00 00 06 04 00 00  |........|
[12-APR-2005 14:26:54:783] nspsend: 00 00 03 73 03 F8 A1 DE  |...s....|
[12-APR-2005 14:26:54:783] nspsend: 00 0B 00 00 00 01 01 00  |........|
[12-APR-2005 14:26:54:783] nspsend: 00 1C E3 12 00 07 00 00  |........|
[12-APR-2005 14:26:54:783] nspsend: 00 D4 DF 12 00 60 E5 12  |.....`..|
[12-APR-2005 14:26:54:783] nspsend: 00 0B 64 65 76 65 6C 6F  |..develo|
[12-APR-2005 14:26:54:783] nspsend: 70 6D 65 6E 74 0D 00 00  |pment...|
[12-APR-2005 14:26:54:783] nspsend: 00 0D 41 55 54 48 5F 50  |..AUTH_P|
[12-APR-2005 14:26:54:783] nspsend: 41 53 53 57 4F 52 44 20  |ASSWORD.|
[12-APR-2005 14:26:54:783] nspsend: 00 00 00 20 43 33 30 37  |....C307|
[12-APR-2005 14:26:54:783] nspsend: 34 36 38 45 33 45 30 33  |468E3E03|
[12-APR-2005 14:26:54:783] nspsend: 36 39 30 32 43 34 39 37  |6902C497|
[12-APR-2005 14:26:54:783] nspsend: 35 46 41 43 45 32 39 33  |5FACE293|
[12-APR-2005 14:26:54:783] nspsend: 44 42 38 42 00 00 00 00  |DB8B....|
[12-APR-2005 14:26:54:783] nspsend: 0D 00 00 00 0D 41 55 54  |.....AUT|
[12-APR-2005 14:26:54:783] nspsend: 48 5F 54 45 52 4D 49 4E  |H_TERMIN|
[12-APR-2005 14:26:54:783] nspsend: 41 4C 06 00 00 00 06 55  |AL.....U|
[12-APR-2005 14:26:54:783] nspsend: 44 45 56 31 39 00 00 00  |DEV19...|
[12-APR-2005 14:26:54:783] nspsend: 00 0F 00 00 00 0F 41 55  |......AU|
[12-APR-2005 14:26:54:783] nspsend: 54 48 5F 50 52 4F 47 52  |TH_PROGR|
[12-APR-2005 14:26:54:783] nspsend: 41 4D 5F 4E 4D 0C 00 00  |AM_NM...|
[12-APR-2005 14:26:54:783] nspsend: 00 0C 73 71 6C 70 6C 75  |..sqlplu|
[12-APR-2005 14:26:54:783] nspsend: 73 77 2E 65 78 65 00 00  |sw.exe..|
[12-APR-2005 14:26:54:783] nspsend: 00 00 0C 00 00 00 0C 41  |.......A|
[12-APR-2005 14:26:54:783] nspsend: 55 54 48 5F 4D 41 43 48  |UTH_MACH|
[12-APR-2005 14:26:54:783] nspsend: 49 4E 45 0B 00 00 00 0B  |INE.....|
[12-APR-2005 14:26:54:783] nspsend: 4E 41 55 5C 55 44 45 56  |NAU\UDEV|
[12-APR-2005 14:26:54:783] nspsend: 31 39 00 00 00 00 00 08  |19......|
[12-APR-2005 14:26:54:783] nspsend: 00 00 00 08 41 55 54 48  |....AUTH|
[12-APR-2005 14:26:54:783] nspsend: 5F 50 49 44 08 00 00 00  |_PID....|
[12-APR-2005 14:26:54:783] nspsend: 08 34 38 30 3A 33 38 31  |.480:381|
[12-APR-2005 14:26:54:783] nspsend: 36 00 00 00 00 08 00 00  |6.......|
[12-APR-2005 14:26:54:783] nspsend: 00 08 41 55 54 48 5F 41  |..AUTH_A|
[12-APR-2005 14:26:54:783] nspsend: 43 4C 04 00 00 00 04 34  |CL.....4|
[12-APR-2005 14:26:54:783] nspsend: 34 30 30 00 00 00 00 12  |400.....|
[12-APR-2005 14:26:54:783] nspsend: 00 00 00 12 41 55 54 48  |....AUTH|
[12-APR-2005 14:26:54:783] nspsend: 5F 41 4C 54 45 52 5F 53  |_ALTER_S|
[12-APR-2005 14:26:54:783] nspsend: 45 53 53 49 4F 4E DC 01  |ESSION..|
[12-APR-2005 14:26:54:783] nspsend: 00 00 FE 40 41 4C 54 45  |...@ALTE|
[12-APR-2005 14:26:54:783] nspsend: 52 20 53 45 53 53 49 4F  |R.SESSIO|
[12-APR-2005 14:26:54:783] nspsend: 4E 20 53 45 54 20 4E 4C  |N.SET.NL|
[12-APR-2005 14:26:54:783] nspsend: 53 5F 4C 41 4E 47 55 41  |S_LANGUA|
[12-APR-2005 14:26:54:783] nspsend: 47 45 3D 20 27 41 4D 45  |GE=.'AME|
[12-APR-2005 14:26:54:783] nspsend: 52 49 43 41 4E 27 20 4E  |RICAN'.N|
[12-APR-2005 14:26:54:783] nspsend: 4C 53 5F 54 45 52 52 49  |LS_TERRI|
[12-APR-2005 14:26:54:783] nspsend: 54 4F 52 59 3D 20 27 41  |TORY=.'A|
[12-APR-2005 14:26:54:783] nspsend: 4D 45 52 49 40 43 41 27  |MERI@CA'|
[12-APR-2005 14:26:54:783] nspsend: 20 4E 4C 53 5F 43 55 52  |.NLS_CUR|
[12-APR-2005 14:26:54:783] nspsend: 52 45 4E 43 59 3D 20 27  |RENCY=.'|
[12-APR-2005 14:26:54:783] nspsend: 24 27 20 4E 4C 53 5F 49  |$'.NLS_I|
[12-APR-2005 14:26:54:783] nspsend: 53 4F 5F 43 55 52 52 45  |SO_CURRE|
[12-APR-2005 14:26:54:783] nspsend: 4E 43 59 3D 20 27 41 4D  |NCY=.'AM|
[12-APR-2005 14:26:54:783] nspsend: 45 52 49 43 41 27 20 4E  |ERICA'.N|
[12-APR-2005 14:26:54:783] nspsend: 4C 53 5F 4E 55 4D 45 52  |LS_NUMER|
[12-APR-2005 14:26:54:783] nspsend: 49 43 5F 43 48 40 41 52  |IC_CH@AR|
[12-APR-2005 14:26:54:783] nspsend: 41 43 54 45 52 53 3D 20  |ACTERS=.|
[12-APR-2005 14:26:54:783] nspsend: 27 2E 2C 27 20 4E 4C 53  |'.,'.NLS|
[12-APR-2005 14:26:54:783] nspsend: 5F 43 41 4C 45 4E 44 41  |_CALENDA|
[12-APR-2005 14:26:54:783] nspsend: 52 3D 20 27 47 52 45 47  |R=.'GREG|
[12-APR-2005 14:26:54:783] nspsend: 4F 52 49 41 4E 27 20 4E  |ORIAN'.N|
[12-APR-2005 14:26:54:783] nspsend: 4C 53 5F 44 41 54 45 5F  |LS_DATE_|
[12-APR-2005 14:26:54:783] nspsend: 46 4F 52 4D 41 54 3D 20  |FORMAT=.|
[12-APR-2005 14:26:54:783] nspsend: 27 44 44 2D 4D 4F 40 4E  |'DD-MO@N|
[12-APR-2005 14:26:54:783] nspsend: 2D 52 52 27 20 4E 4C 53  |-RR'.NLS|
[12-APR-2005 14:26:54:783] nspsend: 5F 44 41 54 45 5F 4C 41  |_DATE_LA|
[12-APR-2005 14:26:54:783] nspsend: 4E 47 55 41 47 45 3D 20  |NGUAGE=.|
[12-APR-2005 14:26:54:783] nspsend: 27 41 4D 45 52 49 43 41  |'AMERICA|
[12-APR-2005 14:26:54:783] nspsend: 4E 27 20 20 4E 4C 53 5F  |N'..NLS_|
[12-APR-2005 14:26:54:783] nspsend: 53 4F 52 54 3D 20 27 42  |SORT=.'B|
[12-APR-2005 14:26:54:783] nspsend: 49 4E 41 52 59 27 20 54  |INARY'.T|
[12-APR-2005 14:26:54:783] nspsend: 49 4D 45 5F 5A 4F 4E 40  |IME_ZON@|
[12-APR-2005 14:26:54:783] nspsend: 45 3D 20 27 2D 30 37 3A  |E=.'-07:|
[12-APR-2005 14:26:54:783] nspsend: 30 30 27 20 4E 4C 53 5F  |00'.NLS_|
[12-APR-2005 14:26:54:783] nspsend: 44 55 41 4C 5F 43 55 52  |DUAL_CUR|
[12-APR-2005 14:26:54:783] nspsend: 52 45 4E 43 59 20 3D 20  |RENCY.=.|
[12-APR-2005 14:26:54:783] nspsend: 27 24 27 20 4E 4C 53 5F  |'$'.NLS_|
[12-APR-2005 14:26:54:783] nspsend: 54 49 4D 45 5F 46 4F 52  |TIME_FOR|
[12-APR-2005 14:26:54:783] nspsend: 4D 41 54 20 3D 20 27 48  |MAT.=.'H|
[12-APR-2005 14:26:54:783] nspsend: 48 2E 4D 49 2E 53 53 58  |H.MI.SSX|
[12-APR-2005 14:26:54:783] nspsend: 40 46 46 20 41 4D 27 20  |@FF.AM'.|
[12-APR-2005 14:26:54:783] nspsend: 4E 4C 53 5F 54 49 4D 45  |NLS_TIME|
[12-APR-2005 14:26:54:783] nspsend: 53 54 41 4D 50 5F 46 4F  |STAMP_FO|
[12-APR-2005 14:26:54:783] nspsend: 52 4D 41 54 20 3D 20 27  |RMAT.=.'|
[12-APR-2005 14:26:54:783] nspsend: 44 44 2D 4D 4F 4E 2D 52  |DD-MON-R|
[12-APR-2005 14:26:54:783] nspsend: 52 20 48 48 2E 4D 49 2E  |R.HH.MI.|
[12-APR-2005 14:26:54:783] nspsend: 53 53 58 46 46 20 41 4D  |SSXFF.AM|
[12-APR-2005 14:26:54:783] nspsend: 27 20 4E 4C 53 5F 54 49  |'.NLS_TI|
[12-APR-2005 14:26:54:783] nspsend: 4D 40 45 5F 54 5A 5F 46  |M@E_TZ_F|
[12-APR-2005 14:26:54:783] nspsend: 4F 52 4D 41 54 20 3D 20  |ORMAT.=.|
[12-APR-2005 14:26:54:783] nspsend: 27 48 48 2E 4D 49 2E 53  |'HH.MI.S|
[12-APR-2005 14:26:54:783] nspsend: 53 58 46 46 20 41 4D 20  |SXFF.AM.|
[12-APR-2005 14:26:54:783] nspsend: 54 5A 52 27 20 4E 4C 53  |TZR'.NLS|
[12-APR-2005 14:26:54:783] nspsend: 5F 54 49 4D 45 53 54 41  |_TIMESTA|
[12-APR-2005 14:26:54:783] nspsend: 4D 50 5F 54 5A 5F 46 4F  |MP_TZ_FO|
[12-APR-2005 14:26:54:783] nspsend: 52 4D 41 54 20 3D 20 27  |RMAT.=.'|
[12-APR-2005 14:26:54:783] nspsend: 44 44 1C 2D 4D 4F 4E 2D  |DD.-MON-|
[12-APR-2005 14:26:54:783] nspsend: 52 52 20 48 48 2E 4D 49  |RR.HH.MI|
[12-APR-2005 14:26:54:783] nspsend: 2E 53 53 58 46 46 20 41  |.SSXFF.A|
[12-APR-2005 14:26:54:783] nspsend: 4D 20 54 5A 52 27 00 00  |M.TZR'..|
[12-APR-2005 14:26:54:783] nspsend: 00 00 00 00              |....    |
[12-APR-2005 14:26:54:783] nspsend: normal exit
[12-APR-2005 14:26:54:783] nsdofls: exit (0)
[12-APR-2005 14:26:54:783] nsdo: nsctxrnk=0
[12-APR-2005 14:26:54:783] nsdo: normal exit
[12-APR-2005 14:26:54:783] nsdo: entry
[12-APR-2005 14:26:54:783] nsdo: cid=0, opcode=85, *bl=0, *what=0, uflgs=0x0, cflgs=0x3
[12-APR-2005 14:26:54:783] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:54:783] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[12-APR-2005 14:26:54:783] nsdo: gtn=176, gtc=176, ptn=10, ptc=2011
[12-APR-2005 14:26:54:783] nsdo: switching to application buffer
[12-APR-2005 14:26:54:783] nsrdr: entry
[12-APR-2005 14:26:54:783] nsrdr: recving a packet
[12-APR-2005 14:26:54:783] nsprecv: entry
[12-APR-2005 14:26:54:783] nsprecv: reading from transport...
[12-APR-2005 14:26:54:783] nttrd: entry
[12-APR-2005 14:26:55:494] nttrd: exit
[12-APR-2005 14:26:55:494] ntt2err: entry
[12-APR-2005 14:26:55:494] ntt2err: Read unexpected EOF ERROR on 256
[12-APR-2005 14:26:55:494] ntt2err: exit
[12-APR-2005 14:26:55:494] nsprecv: transport read error
[12-APR-2005 14:26:55:494] nsprecv: error exit
[12-APR-2005 14:26:55:494] nserror: entry
[12-APR-2005 14:26:55:494] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[12-APR-2005 14:26:55:494] nsrdr: error exit
[12-APR-2005 14:26:55:494] nsdo: nsctxrnk=0
[12-APR-2005 14:26:55:494] nsdo: error exit
[12-APR-2005 14:26:55:494] nioqer: entry
[12-APR-2005 14:26:55:494] nioqer:  incoming err = 12151
[12-APR-2005 14:26:55:494] nioqce: entry
[12-APR-2005 14:26:55:494] nioqce: exit
[12-APR-2005 14:26:55:494] nioqer:  returning err = 3113
[12-APR-2005 14:26:55:494] nioqer: exit
[12-APR-2005 14:26:55:494] nioqrc: exit
[12-APR-2005 14:26:55:494] nioqbr: entry
[12-APR-2005 14:26:55:494] nioqbr:  state = normal (0)
[12-APR-2005 14:26:55:494] nioqsm: entry
[12-APR-2005 14:26:55:494] nioqsm:  Sending break packet (1)...
[12-APR-2005 14:26:55:494] nsdo: entry
[12-APR-2005 14:26:55:494] nsdo: cid=0, opcode=67, *bl=1, *what=17, uflgs=0x100, cflgs=0x3
[12-APR-2005 14:26:55:494] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:55:494] nsdo: nsctx: state=1, flg=0x100420d, mvd=0
[12-APR-2005 14:26:55:494] nsdo: nsctxrnk=0
[12-APR-2005 14:26:55:494] nsdo: error exit
[12-APR-2005 14:26:55:494] nioqsm: send-break: failed to send break...
[12-APR-2005 14:26:55:494] nioqper:  error from send-marker
[12-APR-2005 14:26:55:494] nioqper:    nr err code: 0
[12-APR-2005 14:26:55:494] nioqper:    ns main err code: 12583
[12-APR-2005 14:26:55:494] nioqper:    ns (2)  err code: 0
[12-APR-2005 14:26:55:494] nioqper:    nt main err code: 0
[12-APR-2005 14:26:55:494] nioqper:    nt (2)  err code: 0
[12-APR-2005 14:26:55:494] nioqper:    nt OS   err code: 0
[12-APR-2005 14:26:55:494] nioqsm: exit
[12-APR-2005 14:26:55:494] nioqer: entry
[12-APR-2005 14:26:55:494] nioqer:  incoming err = 12152
[12-APR-2005 14:26:55:494] nioqce: entry
[12-APR-2005 14:26:55:494] nioqce: exit
[12-APR-2005 14:26:55:504] nioqer:  returning err = 3113
[12-APR-2005 14:26:55:504] nioqer: exit
[12-APR-2005 14:26:55:504] nioqbr:  returning 3113
[12-APR-2005 14:26:55:504] nioqbr: exit
[12-APR-2005 14:26:55:504] nioqds: entry
[12-APR-2005 14:26:55:504] nioqds:  disconnecting...
[12-APR-2005 14:26:55:504] nsdisc: entry
[12-APR-2005 14:26:55:504] nsclose: entry
[12-APR-2005 14:26:55:504] nstimarmed: entry
[12-APR-2005 14:26:55:504] nstimarmed: no timer allocated
[12-APR-2005 14:26:55:504] nstimarmed: normal exit
[12-APR-2005 14:26:55:504] nsdo: entry
[12-APR-2005 14:26:55:504] nsdo: cid=0, opcode=66, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
[12-APR-2005 14:26:55:504] nsdo: rank=64, nsctxrnk=0
[12-APR-2005 14:26:55:504] nsdo: nsctx: state=1, flg=0x1004209, mvd=0
[12-APR-2005 14:26:55:504] nsdo: entry
[12-APR-2005 14:26:55:504] nsdo: cid=0, opcode=67, *bl=0, *what=1, uflgs=0x0, cflgs=0x1
[12-APR-2005 14:26:55:504] nsdo: nsctx: state=1, flg=0x1004209, mvd=0
[12-APR-2005 14:26:55:504] nsdo: error exit
[12-APR-2005 14:26:55:504] nsbfr: entry
[12-APR-2005 14:26:55:504] nsbaddfl: entry
[12-APR-2005 14:26:55:504] nsbaddfl: normal exit
[12-APR-2005 14:26:55:504] nsbfr: normal exit
[12-APR-2005 14:26:55:504] nsbfr: entry
[12-APR-2005 14:26:55:504] nsbaddfl: entry
[12-APR-2005 14:26:55:504] nsbaddfl: normal exit
[12-APR-2005 14:26:55:504] nsbfr: normal exit
[12-APR-2005 14:26:55:504] nsdo: nsctxrnk=0
[12-APR-2005 14:26:55:504] nsdo: normal exit
[12-APR-2005 14:26:55:504] nsclose: closing transport
[12-APR-2005 14:26:55:504] nttdisc: entry
[12-APR-2005 14:26:55:504] nttdisc: Closed socket 256
[12-APR-2005 14:26:55:504] nttdisc: exit
[12-APR-2005 14:26:55:504] nsclose: global context check-out (from slot 0) complete
[12-APR-2005 14:26:55:504] nsnadisc: entry
[12-APR-2005 14:26:55:504] nadisc: entry
[12-APR-2005 14:26:55:504] nacomtm: entry
[12-APR-2005 14:26:55:504] nacompd: entry
[12-APR-2005 14:26:55:504] nacompd: exit
[12-APR-2005 14:26:55:504] nacompd: entry
[12-APR-2005 14:26:55:504] nacompd: exit
[12-APR-2005 14:26:55:504] nacomtm: exit
[12-APR-2005 14:26:55:504] nas_dis: entry
[12-APR-2005 14:26:55:504] nas_dis: exit
[12-APR-2005 14:26:55:504] nau_dis: entry
[12-APR-2005 14:26:55:504] naundiscon: entry
[12-APR-2005 14:26:55:504] naundiscon: exit
[12-APR-2005 14:26:55:504] nau_fad: exit
[12-APR-2005 14:26:55:504] nau_dis: exit
[12-APR-2005 14:26:55:504] naeetrm: entry
[12-APR-2005 14:26:55:504] naeetrm: exit
[12-APR-2005 14:26:55:504] naectrm: entry
[12-APR-2005 14:26:55:504] naectrm: exit
[12-APR-2005 14:26:55:504] nagbltrm: entry
[12-APR-2005 14:26:55:504] nau_gtm: entry
[12-APR-2005 14:26:55:504] nau_gtm: exit
[12-APR-2005 14:26:55:504] nagbltrm: exit
[12-APR-2005 14:26:55:504] nadisc: exit
[12-APR-2005 14:26:55:504] nsnadisc: normal exit
[12-APR-2005 14:26:55:504] nsbfr: entry
[12-APR-2005 14:26:55:504] nsbaddfl: entry
[12-APR-2005 14:26:55:504] nsbaddfl: normal exit
[12-APR-2005 14:26:55:504] nsbfr: normal exit
[12-APR-2005 14:26:55:504] nsbfr: entry
[12-APR-2005 14:26:55:504] nsbfr: normal exit
[12-APR-2005 14:26:55:504] nsmfr: entry
[12-APR-2005 14:26:55:504] nsmfr: 2348 bytes at 0xe07e88
[12-APR-2005 14:26:55:504] nsmfr: normal exit
[12-APR-2005 14:26:55:504] nsmfr: entry
[12-APR-2005 14:26:55:504] nsmfr: 170 bytes at 0xe15008
[12-APR-2005 14:26:55:504] nsmfr: normal exit
[12-APR-2005 14:26:55:504] nsmfr: entry
[12-APR-2005 14:26:55:504] nsmfr: 164 bytes at 0xe042c8
[12-APR-2005 14:26:55:504] nsmfr: normal exit
[12-APR-2005 14:26:55:504] nladtrm: entry
[12-APR-2005 14:26:55:504] nladtrm: exit
[12-APR-2005 14:26:55:504] nsmfr: entry
[12-APR-2005 14:26:55:504] nsmfr: 492 bytes at 0xe07c90
[12-APR-2005 14:26:55:504] nsmfr: normal exit
[12-APR-2005 14:26:55:504] nsclose: normal exit
[12-APR-2005 14:26:55:504] nsdisc: exit (0)
[12-APR-2005 14:26:55:504] nioqds: exit
[12-APR-2005 14:26:55:504] nsbfree: entry
[12-APR-2005 14:26:55:504] nsbaddfl: entry
[12-APR-2005 14:26:55:504] nsbaddfl: normal exit
[12-APR-2005 14:26:55:504] nsbfree: normal exit
[12-APR-2005 14:26:55:504] nsbfree: entry
[12-APR-2005 14:26:55:504] nsbaddfl: entry
[12-APR-2005 14:26:55:504] nsbaddfl: normal exit
[12-APR-2005 14:26:55:504] nsbfree: normal exit
[12-APR-2005 14:26:55:504] nigtrm: Count in the NI global area is now 0
[12-APR-2005 14:26:55:504] nsbfrfl: entry
[12-APR-2005 14:26:55:504] nsbrfr: entry
[12-APR-2005 14:26:55:504] nsbrfr: nsbfs at 0xe077b0, data at 0xe19c70.
[12-APR-2005 14:26:55:504] nsbrfr: normal exit
[12-APR-2005 14:26:55:504] nsbrfr: entry
[12-APR-2005 14:26:55:504] nsbrfr: nsbfs at 0xe15ac0, data at 0xe150f8.
[12-APR-2005 14:26:55:504] nsbrfr: normal exit
[12-APR-2005 14:26:55:504] nsbrfr: entry
[12-APR-2005 14:26:55:504] nsbrfr: nsbfs at 0xe0af30, data at 0xe19450.
[12-APR-2005 14:26:55:504] nsbrfr: normal exit
[12-APR-2005 14:26:55:504] nsbrfr: entry
[12-APR-2005 14:26:55:504] nsbrfr: nsbfs at 0xe0b788, data at 0xe0b7c0.
[12-APR-2005 14:26:55:504] nsbrfr: normal exit
[12-APR-2005 14:26:55:504] nsbrfr: entry
[12-APR-2005 14:26:55:504] nsbrfr: nsbfs at 0xe150c0, data at 0xe0af68.
[12-APR-2005 14:26:55:504] nsbrfr: normal exit
[12-APR-2005 14:26:55:504] nsbfrfl: normal exit
[12-APR-2005 14:26:55:504] nrigbd: entry
[12-APR-2005 14:26:55:504] nrigbd: exit
[12-APR-2005 14:26:55:504] nigtrm: Count in the NL global area is now 0
Avatar of ryeandi
ryeandi

ASKER

i ran the trcassist on the trace file and got this:


Trace Assistant Utility: Version 9.2.0.1.0 Production on April 12, 2005 4:58:15 PM

(c) Copyright 2002 Oracle Corporation.  All rights reserved.


    *************************************************************************
    *                        Trace Assistant                                *
    *************************************************************************

---> Send 228 bytes - Connect packet  timestamp=12-APR-2005 14:26:54:182
Current NS version number is: 312.
Lowest NS version number can accommodate is: 300.
      Maximum SDU size: 2048
      Maximum TDU size: 32767
      NT protocol characteristics:
            Asynchronous mode
            Callback mode
            Test for more data
            Full duplex I/O
            Urgent data support
            Grant connection to another
      Line turnaround value: 0
      Connect data length: 170
      Connect data offset: 58
      Connect data maximum size: 512
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
      Cross facility item 1: 0
      Cross facility item 2: 0
      Connection id: Ox000001E000000006
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jester)(PORT=1521))(CONNECT_
    DATA=(SERVICE_NAME=TESTER)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.e
    xe)(HOST=UDEV19)(USER=pkp5))))

<--- Received 66 bytes - Redirect packet  timestamp=12-APR-2005 14:26:54:282
Redirect data length: 56
Redirect Data:
    (ADDRESS=(PROTOCOL=tcp)(HOST=134.114.208.85)(PORT=4952))

---> Send 228 bytes - Connect packet  timestamp=12-APR-2005 14:26:54:292
Current NS version number is: 312.
Lowest NS version number can accommodate is: 300.
      Maximum SDU size: 2048
      Maximum TDU size: 32767
      NT protocol characteristics:
            Asynchronous mode
            Callback mode
            Test for more data
            Full duplex I/O
            Urgent data support
            Grant connection to another
      Line turnaround value: 0
      Connect data length: 170
      Connect data offset: 58
      Connect data maximum size: 512
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
      Cross facility item 1: 0
      Cross facility item 2: 0
      Connection id: Ox000001E000000011
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jester)(PORT=1521))(CONNECT_
    DATA=(SERVICE_NAME=TESTER)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.e
    xe)(HOST=UDEV19)(USER=pkp5))))

<--- Received 32 bytes - Accept packet  timestamp=12-APR-2005 14:26:54:352
Accepted NS version number is: 312.
      Accepted maximum SDU size: 2048
      Accepted maximum TDU size: 32767
      Connect data length: 0
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin

---> Send 168 bytes - Data packet  timestamp=12-APR-2005 14:26:54:352
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Supervisor has 3 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 0000000000000000
                  Subpacket #2: DEADBEEF0003000000040004000100010002
             Service data packet #1 for Authentication has 5 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: UB2: 57569
                  Subpacket #2: FCFF
                  Subpacket #3: UB1: 1
                  Subpacket #4: NTS
             Service data packet #2 for Encryption has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 000000000000000000000000
             Service data packet #3 for Data Integrity has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 000000

<--- Received 163 bytes - Data packet  timestamp=12-APR-2005 14:26:54:432
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Supervisor has 3 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 0000
                  Subpacket #2: DEADBEEF00030000000200040001
             Service data packet #1 for Authentication has 7 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: FAFF
                  Subpacket #2: UB1: 1
                  Subpacket #3: NTS
                  Subpacket #4:  Version #33554432
                  Subpacket #5: UB4: 0
                  Subpacket #6: UB4: 0
             Service data packet #2 for Encryption has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: UB1: 0
             Service data packet #3 for Data Integrity has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: UB1: 0

---> Send 87 bytes - Data packet  timestamp=12-APR-2005 14:26:54:552
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 5 subpackets
                  Subpacket #0:  Version #33554432
                  Subpacket #1: UB4: 0
                  Subpacket #2: UB4: 0
                  Subpacket #3: 0200000005000000010000000000000000000000
                  Subpacket #4: 00000000

<--- Received 69 bytes - Data packet  timestamp=12-APR-2005 14:26:54:572
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 0200000005000000020000000000000000000000
                  Subpacket #1: NAU\JESTER

---> Send 1339 bytes - Data packet  timestamp=12-APR-2005 14:26:54:572
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 10050000
                  Subpacket #1: 6082050C06092A864886F71201020201006E8204FB308204F7A003020105A10302010EA20703050020000000A382041F6182041B30820417A003020105A1131B114E41552E46524F4F542E4E41552E454455A2133011A003020180A10A30081B064A4553544552A38203E4308203E0A003020117A10302010EA28203D2048203CE456FEA3E23131A7FC989E0FE6C838B03F2C37361AFF9DFF4FA8B4D4A040DB78D63AAB4FD94AA798A7C04410A87D35D3D7613B8AF53DF047D037E352E089B76B72BBC098AEF41B8067E78E23D618F6DF3531C0B207F2EE151D1F2158E3D6F09C383F6B1EF65D1D78A7606417494ADCE5399E65805FE0B5E9EE653FFA1AF1FEC785E7A9C67741594A9B3BE0BB7B1CF53E8E607AB636BAFA0FD28A810888A1EDEF981B97A86ECA25EA08DFE2124412C013ED6B77C75861923C3F32A9E71ED2C913514B7C06807D576378167CFB526DD924CFE49246B51A9F28B88F7713DBA909C92B9F514E593222CCD785FAE5EABD40FFDD8515747DE856D3E355BA372E44482CCB282B55F0DA1E0F8FC3F1FA476D7051BDF35335C9004B49633466B56C85F56457C94EDCB9AEC041A2D8F47951ECF3E83748156806A732F68177A76A32845DB9B03AE6283BB01B9EF03FA598CE981A5B5A09ADAC271185A7F289E8BECE727FDD1D2B7F430AE9614954FB6E0E6EE498A02DDD7D14458E28DA99B7FC2811D30F36EA90B7002E41CEAF92E83D50DDE27F751D7D1FC44D6B0C7E87EB40291F56F5BDA3673F315230B5442E8A4E2AA6A6C7BF373796E78358CEFD5B31735C2759679C77EB35FCE6ABAB8387AA770EA2F80F1D195A99FDE3A8A10198CAE8BF0BDAB8E135F42B93E03A22B4439CA140D0A2C504137BF1F20F090298FEA6FBFF52A7848729BD565F69B3F02632246772FA749121AEB9AAD9D05E4C9A7A4AD2E93A0C9C98AC34FE7CD0D2642F6E2DB824338DDE3F62D3DAB23264346A6568A537597ECF40DF4B1D7592F67268F4326BA43D46A4FAE88E37C9DC18458930DBEF1DF9A6DAE176ED7DF221E398E048D60A7E79784C2A3C38A5FFFA2AAC876A959F0B6FFF6B18015263333F76064A2E58D3163AF1DE08D84809A7844C1A430091B8EDC90CF28E9C57A83146CD1BD85A5B2BAA7FA2FE9A84ABC925E18CDCA4DBBB2B5E198EC64C5FAE3BC4BC02493F453B38F35304E88197B7CECFD12F073E38E28C9F685CA61D919B8FC07461960C135A78C18E852EBED83A11F740EA7E0A481430AFCD9CE9A8BCF908D2FA174A30B04C5F99D674AD7670A375E2959C36F7B1BEBFC9D4023E3F7E0FD26C09A291036C1E7EAD98B434902EDB682A0C2F69397D41A158585F42A3E3EA1302B305C33F6B9292825E22B2220621667F3C0B9C8644564A80CD533831A7F2DE37F40D1C4BFDBD9819D6E24ACD3FA7A1543F8C79DC06CA0006C85DF5C36259E6DB537BDCF294019ADF8A935F2417DAF51E7E05FE6C4DDE22F762754AE0D234E7C16230B5C15C056BD0D31E9FF3B582B9C3FA96E6472AA1E6E202B8EDB3DFF537C9EE417FD6A2E55AA5B2412A481BE3081BBA003020117A281B30481B0DA4D3AA022278B06F7181709704344C2B4BFF01CA12B259E8A412F183924A9B936433122D30079CD4966B8E77D3E6E00F88FD1E3B1CE558348AF1D6BE8C43F831B6EEFC690F9004E62BD0A84DC3C1B9C1524D0711BD537E19C8836CEDC0D95749E8F89CC1B4363E4D3AC154CF3DEB47F7E1473E82DC1A9B092AFA0BB8B85DC44BEB7E8F6BB881BB6A73FFAC89F9046A58CCF6A6914892C5E39AEF741DD7E600D1CFC65E2EE76FB9959751CE3707CA369

<--- Received 176 bytes - Data packet  timestamp=12-APR-2005 14:26:54:622
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 85000000
                  Subpacket #1: 60818206092A864886F71201020202006F733071A003020105A10302010FA2653063A003020117A25C045ABE0B7E3825CA1D7D719083EDB9DEDCF3E9CC41A0740A699EA87D6F6DFDCBC7FA9953287D81C319215E960814F30D3D0EC750496A1565E50A911CE798B4A9F53D489361B91A8C746937D4BD49F4B730124295886C4907D9DD6F2A

---> Send 43 bytes - Data packet  timestamp=12-APR-2005 14:26:54:622
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 00000000
                  Subpacket #1:

---> Send 37 bytes - Data packet  timestamp=12-APR-2005 14:26:54:632
Set protocol (TTIPRO)
      Operation 01 (con) Send protocol version=6
      Originating platform: IBMPC/WIN_NT-8.1.0

<--- Received 164 bytes - Data packet  timestamp=12-APR-2005 14:26:54:672
Set protocol (TTIPRO)
      Operation 01 (con) Receive protocol version=6
      Destination platform: IBMPC/WIN_NT-8.1.0

---> Send 52 bytes - Data packet  timestamp=12-APR-2005 14:26:54:672
Set datatypes (TTIDTY)

<--- Received 22 bytes - Data packet  timestamp=12-APR-2005 14:26:54:682
Set datatypes (TTIDTY)

---> Send 194 bytes - Data packet  timestamp=12-APR-2005 14:26:54:682
Start of user function (TTIFUN)
      Get the session key (OSESSKEY)

<--- Received 165 bytes - Data packet  timestamp=12-APR-2005 14:26:54:783
Return opi parameter (TTIRPA)

---> Send 796 bytes - Data packet  timestamp=12-APR-2005 14:26:54:783
Start of user function (TTIFUN)
      Generic authentication call (OAUTH)

///////////////////////////////////////////////////////////////
Error found. Error Stack follows:
              id:0
  Operation code:68
      NS Error 1:12537
      NS Error 2:12560
NT Generic Error:507
  Protocol Error:0
        OS Error:0
 NS & NT Errors Translation
12537, 00000 "TNS:connection closed"
 // *Cause: "End of file" condition has been reached; partner has disconnected.
 // *Action: None needed; this is an information message.
/
12560, 00000 "TNS:protocol adapter error"
 // *Cause: A generic protocol adapter error occurred.
 // *Action: Check addresses used for proper protocol specification. Before
 // reporting this error, look at the error stack and check for lower level
 // transport errors.For further details, turn on tracing and reexecute the
 // operation. Turn off tracing when the operation is complete.
/
00507, 00000 "Connection closed"
 // *Cause: Normal "end of file" condition has been reached; partner has
 // disconnected.
 // *Action: None needed; this is an information message.
/
///////////////////////////////////////////////////////////////


----------------------
Trace File Statistics:
----------------------
Start Timestamp : 12-APR-2005 14:26:54:182
End Timestamp   : 12-APR-2005 14:26:54:783
Total number of Sessions: 2

DATABASE:
  Operation Count:    0 OPENS,     0 PARSES,     0 EXECUTES,     0 FETCHES


ORACLE NET SERVICES:
  Total Calls  :        10 sent,          8 received,           2 oci
  Total Bytes  :      3172 sent,        857 received
    Average Bytes:       317 sent per packet,        107 received per packet
    Maximum Bytes:      1339 sent,        176 received

  Grand Total Packets:     10  sent,       8 received


    *************************************************************************
    *                    Trace Assistant has completed                      *
    *************************************************************************
Avatar of jrb1
jrb1
Flag of United States of America image
What trace level are you using?  If not SUPPORT, can you set that and run the trace assistant again?
Avatar of ryeandi
ryeandi

ASKER

TRACE_LEVEL_CLIENT = 16
Avatar of jrb1
jrb1
Flag of United States of America image
I see a recommendation to go in to the LISTENER.ORA file (on the server) and increasing the value of this parameter:

connect_timeout_LISTENER=0

Maybe set to 10?
Avatar of jrb1
jrb1
Flag of United States of America image
Also, is there an trc file on the server as well?
Avatar of ryeandi
ryeandi

ASKER

1)  changing CONNECTION_TIMEOUT_LISTENER=0  din't work
2) i turned tracing on for both client and server.  one file had a matching timestamp as the one i posted earlier for the client.  i ran that
through trcassist and got the following:


Trace Assistant Utility: Version 9.2.0.1.0 Production on April 12, 2005 5:52:13 PM

(c) Copyright 2002 Oracle Corporation.  All rights reserved.


    *************************************************************************
    *                        Trace Assistant                                *
    *************************************************************************

<--- Received 228 bytes - Connect packet  timestamp=12-APR-2005 14:26:54:303
Current NS version number is: 312.
Lowest NS version number can accommodate is: 300.
      Maximum SDU size: 2048
      Maximum TDU size: 32767
      NT protocol characteristics:
            Asynchronous mode
            Callback mode
            Test for more data
            Full duplex I/O
            Urgent data support
            Grant connection to another
      Line turnaround value: 0
      Connect data length: 170
      Connect data offset: 58
      Connect data maximum size: 512
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
      Cross facility item 1: 0
      Cross facility item 2: 0
      Connection id: Ox000001E000000011
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jester)(PORT=1521))(CONNECT_
    DATA=(SERVICE_NAME=TESTER)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.e
    xe)(HOST=UDEV19)(USER=pkp5))))

---> Send 32 bytes - Accept packet  timestamp=12-APR-2005 14:26:54:334
Accepted NS version number is: 312.
      Accepted maximum SDU size: 2048
      Accepted maximum TDU size: 32767
      Connect data length: 0
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin
            Native Services wanted
            Authentication is linked and specify
            NAU doing O3LOGON - DH key foldedin

<--- Received 168 bytes - Data packet  timestamp=12-APR-2005 14:26:54:350
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Supervisor has 3 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 0000000000000000
                  Subpacket #2: DEADBEEF0003000000040004000100010002
             Service data packet #1 for Authentication has 5 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: UB2: 57569
                  Subpacket #2: FCFF
                  Subpacket #3: UB1: 1
                  Subpacket #4: NTS
             Service data packet #2 for Encryption has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 000000000000000000000000
             Service data packet #3 for Data Integrity has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 000000

---> Send 163 bytes - Data packet  timestamp=12-APR-2005 14:26:54:428
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Supervisor has 3 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: 0000
                  Subpacket #2: DEADBEEF00030000000200040001
             Service data packet #1 for Authentication has 7 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: FAFF
                  Subpacket #2: UB1: 1
                  Subpacket #3: NTS
                  Subpacket #4:  Version #33554432
                  Subpacket #5: UB4: 0
                  Subpacket #6: UB4: 0
             Service data packet #2 for Encryption has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: UB1: 0
             Service data packet #3 for Data Integrity has 2 subpackets
                  Subpacket #0:  Version #153092352
                  Subpacket #1: UB1: 0

<--- Received 87 bytes - Data packet  timestamp=12-APR-2005 14:26:54:537
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 5 subpackets
                  Subpacket #0:  Version #33554432
                  Subpacket #1: UB4: 0
                  Subpacket #2: UB4: 0
                  Subpacket #3: 0200000005000000010000000000000000000000
                  Subpacket #4: 00000000

---> Send 69 bytes - Data packet  timestamp=12-APR-2005 14:26:54:553
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 0200000005000000020000000000000000000000
                  Subpacket #1: NAU\JESTER

<--- Received 1339 bytes - Data packet  timestamp=12-APR-2005 14:26:54:569
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 10050000
                  Subpacket #1: 6082050C06092A864.....

---> Send 176 bytes - Data packet  timestamp=12-APR-2005 14:26:54:615
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 85000000
                  Subpacket #1: 60818206092A864886F712010202......
<--- Received 43 bytes - Data packet  timestamp=12-APR-2005 14:26:54:615
      Native Services negotiation packet version#: 153092352
             Service data packet #0 for Authentication has 2 subpackets
                  Subpacket #0: 00000000
                  Subpacket #1:

<--- Received 37 bytes - Data packet  timestamp=12-APR-2005 14:26:54:647
Set protocol (TTIPRO)
      Operation 01 (con)

---> Send 164 bytes - Data packet  timestamp=12-APR-2005 14:26:54:662
Set protocol (TTIPRO)
      Operation 01 (con) Send protocol version=6
      Originating platform: IBMPC/WIN_NT-8.1.0

<--- Received 52 bytes - Data packet  timestamp=12-APR-2005 14:26:54:662
Set datatypes (TTIDTY)

<--- Received 194 bytes - Data packet  timestamp=12-APR-2005 14:26:54:678

---> Send 165 bytes - Data packet  timestamp=12-APR-2005 14:26:54:772

<--- Received 796 bytes - Data packet  timestamp=12-APR-2005 14:26:54:772


----------------------
Trace File Statistics:
----------------------
Start Timestamp : 12-APR-2005 14:26:54:303
End Timestamp   : 12-APR-2005 14:26:54:772
Total number of Sessions: 2

DATABASE:
  Operation Count:    0 OPENS,     0 PARSES,     0 EXECUTES,     0 FETCHES


ORACLE NET SERVICES:
  Total Calls  :         7 sent,          9 received,           0 oci
  Total Bytes  :       791 sent,       2944 received
    Average Bytes:       113 sent per packet,        327 received per packet
    Maximum Bytes:       176 sent,       1339 received

  Grand Total Packets:      7  sent,       9 received


    *************************************************************************
    *                    Trace Assistant has completed                      *
    *************************************************************************
ASKER CERTIFIED SOLUTION
Avatar of PAQ_Man
PAQ_Man
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial