Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000?

Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000?

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Tue, 3 Aug 2004 10:26:25 -0400
Message-ID: <AFF54B073FF15849B53E32E67EE860763A7D2C@enhbgpri11.backup> 





I am finally getting to practice some of the tracing functionality that =
is discussed here and ran into something I haven't seen dicussed here.  =
We had a complaint about a query that performs inconsistently and I =
enabled my session trigger on user logon to capture it.   The server =
failed at a point shown below.  The first entry is the alert log entry.  =
The second is my trigger.  The third is an error that is appearing =
frequently in my trace and lastly is the error that crashed the server.  =
We have turned off tracing and haven't had any other errors.  Any =
thoughts?  I haven't submitted a TAR yet because I would like to know =
that it's not something I am doing.  I will submit one if advised =
because I want to be able to confidently use the tracing methodology.  I =
=20




Errors in file =


d:\oracle\admin\nedssarp\udump\nedssarp_ora_2676_cognosop.trc:



Thu Jul 29 13:23:14 2004


Errors in file =


d:\oracle\admin\nedssarp\udump\nedssarp_ora_688_cognosop.trc:

ORA-12801: error signaled in parallel query server P002
ORA-27153: wait operation failed
ORA-27300: OS system dependent operation:spwat failed with status: 6
ORA-27301: OS failure message: The handle is invalid.
ORA-27302: failure occurred at: skgpwopwait
*************************************************************************=
**********************************************************************







PARSE ERROR #3:len=3D144 dep=3D0 uid=3D44 oct=3D3 lid=3D44 =
tim=3D18446744069888019367 err=3D942


select decode( VALUE, :"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", =
:"SYS_B_4" )        from V$PARAMETER       where UPPER(NAME) =3D =
:"SYS_B_5"



WAIT #3: nam=3D'SQL*Net break/reset to client' ela=3D 5 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #3: nam=3D'SQL*Net break/reset to client' ela=3D 561 =
p1=3D1413697536 p2=3D0 p3=3D0


WAIT #3: nam=3D'SQL*Net message to client' ela=3D 6 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #3: nam=3D'SQL*Net message from client' ela=3D 590 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #3: nam=3D'SQL*Net message to client' ela=3D 6 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #3: nam=3D'SQL*Net message from client' ela=3D 552 p1=3D1413697536 =
p2=3D1 p3=3D0


XCTEND rlbk=3D0, rd_only=3D1


WAIT #0: nam=3D'SQL*Net message to client' ela=3D 6 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #0: nam=3D'SQL*Net message from client' ela=3D 158902 =
p1=3D1413697536 p2=3D1 p3=3D0


WAIT #3: nam=3D'SQL*Net message to client' ela=3D 6 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #3: nam=3D'SQL*Net message from client' ela=3D 705 p1=3D1413697536 =
p2=3D1 p3=3D0

*************************************************************************=
**********************************************************************


Error 1 (fatal) caused us to have to reboot the server



EXEC =



#5:c=3D0,e=3D1038304,p=3D0,cr=3D15,cu=3D0,mis=3D0,r=3D0,dep=3D0,og=3D4,ti=
m=3D18446744069892576177

ERROR #5:err=3D12801 tim=3D15068345
WAIT #5: nam=3D'enqueue' ela=3D 493 p1=3D1347616774 p2=3D1 p3=3D3
WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 5 p1=3D1413697536 =


p2=3D1 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 28 p1=3D1413697536 =
p2=3D0 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 9 p1=3D1413697536 =
p2=3D0 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 9 p1=3D1413697536 =
p2=3D0 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 2 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 8 p1=3D1413697536 =
p2=3D0 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 3 p1=3D1413697536 =
p2=3D1 p3=3D0


WAIT #5: nam=3D'SQL*Net break/reset to client' ela=3D 8 p1=3D1413697536 =
p2=3D0 p3=3D0


FATAL ERROR IN TWO-TASK SERVER: error =3D 12152
*** 2004-07-29 13:23:14.562


ksedmp: internal or fatal error

ORA-12801: error signaled in parallel query server P002
ORA-27153: wait operation failed
ORA-27300: OS system dependent operation:spwat failed with status: 6
ORA-27301: OS failure message: The handle is invalid.
ORA-27302: failure occurred at: skgpwopwait


Current SQL statement for this session:


select "c22" "c1", "c21" "c2", "c20" "c3", "c16" "c4", "c14" "c5", "c18" =


"c6", "c19" "c7", "c18" "c8", "c18" "c9", "c17" "c10", "c16" "c11", =

"c15" "c13" from (select count(T3."IDR_PARTY_ID") "c14" from =

"PADOHSNAP"."PERSON_NAME" T1, "PADOHSNAP"."LOCAL_ADDRESS_CODE" T2, =


"PADOHSNAP"."PARTY" T3, "PADOHSNAP"."PARTY_JURISDICTION" T7, =


"PADOHSNAP"."PARTY_PERMISSIONS" T4, =


"PADOHSNAP"."PARTY_LOCATION_PARTICIPAT" T8, "PADOHSNAP"."LOCATION" T9, =


"PADOHSNAP"."TELECOMMUNICATION_LOCATION" T5, "PADOHSNAP"."PARTY_ROLE" T6 =


where T3."IDR_PARTY_ID"=3DT1."IDR_PARTY_ID" and =

T7."PARTY_ID"=3DT3."IDR_PARTY_ID" and =
T7."JURISDICTION_CODE_VALUE"=3DT2."CODE_VALUE" and =
T4."IDR_PARTY_ID"=3DT1."IDR_PARTY_ID" and =
T8."IDR_PARTY_ID"=3DT3."IDR_PARTY_ID" and =
T8."IDR_LOCATION_ID"=3DT9."IDR_LOCATION_ID" and =
T5."IDR_LOCATION_ID"=3DT9."IDR_LOCATION_ID" and =
T1."IDR_PARTY_ID"=3DT6."PARTY_ID" and =
T6."ROLE_TYPE_CODE_VALUE"=3D:"SYS_B_00" and =
T2."PRINT_NAME"=3D:"SYS_B_01" and =
T4."PERMISSION_CODE_VALUE"=3D:"SYS_B_02" and T3."ROW_STATUS" in =


(:"SYS_B_03", :"SYS_B_04") and T7."ROW_STATUS"=3D:"SYS_B_05" and =
T7."ROW_STATUS"=3D:"SYS_B_06" and =


T5."TELECOM_TYPE_CODE_VALUE"=3D:"SYS_B_07") D3, (select upper (T5."URI") =


"c15", T4."PERMISSION_CODE_VALUE" "c16", T3."ROW_STATUS" "c17", =


T1."IDR_PERSON_ID" "c18", T1."IDR_PARTY_ID" "c19", T3."IDR_PARTY_ID" =




"c20", T2."PRINT_NAME" "c21", ((upper (T1."SURNAME") || :"SYS_B_08") || =


upper (upper (T1."GNAME"))) "c22" from "PADOHSNAP"."PERSON_NAME" T1, =


"PADOHSNAP"."LOCAL_ADDRESS_CODE" T2, "PADOHSNAP"."PARTY" T3, =

"PADOHSNAP"."PARTY_JURISDICTION" T7, "PADOHSNAP"."PARTY_PERMISSIONS" T4, =



"PADOHSNAP"."PARTY_LOCATION_PARTICIPAT" T8, "PADOHSNAP"."LOCATION" T9, =


"PADOHSNAP"."TELECOMMUNICATION_LOCATION" T5, "PADOHSNAP"."PARTY_ROLE" T6 =


where T3."IDR_PARTY_ID"=3DT1."IDR_PARTY_ID" and =

T7."PARTY_ID"=3DT3."IDR_PARTY_ID" and =
T7."JURISDICTION_CODE_VALUE"=3DT2."CODE_VALUE" and =
T4."IDR_PARTY_ID"=3DT1."IDR_PARTY_ID" and =
T8."IDR_PARTY_ID"=3DT3."IDR_PARTY_ID" and =
T8."IDR_LOCATION_ID"=3DT9."IDR_LOCATION_ID" and =
T5."IDR_LOCATION_ID"=3DT9."IDR_LOCATION_ID" and =
T1."IDR_PARTY_ID"=3DT6."PARTY_ID" and =
T6."ROLE_TYPE_CODE_VALUE"=3D:"SYS_B_09" and =
T2."PRINT_NAME"=3D:"SYS_B_10" and =
T4."PERMISSION_CODE_VALUE"=3D:"SYS_B_11" and T3."ROW_STATUS" in =


(:"SYS_B_12", :"SYS_B_13") and T7."ROW_STATUS"=3D:"SYS_B_14" and =
T7."ROW_STATUS"=3D:"SYS_B_15" and =


T5."TELECOM_TYPE_CODE_VALUE"=3D:"SYS_B_16") D2 order by "c5" asc, "c1" =
asc


----- Call Stack Trace =

-----.........................................................





Don Freeman


Database Administrator 1


Pennsylvania Dept of Health


Bureau of Information Technology






Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


Received on Tue Aug 03 2004 - 09:22:19 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US