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