Oracle 9.2.0.5 "10046" Tracing Causes Server Crash on Windows 2000?
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Aug 2004 10:26:25 -0400
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
*************************************************************************=
**********************************************************************
*** SESSION ID:(20.3685) 2004-07-29 13:23:08.828
APPNAME mod=3D'impserver.exe' mh=3D0 act=3D'' ah=3D0
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #5 len=3D68 dep=3D2 uid=3D0 oct=3D42 lid=3D0 =
tim=3D18446744069886947494 hv=3D2212335334 ad=3D'4f558260'
alter session set events '10046 trace name context forever, level 8'
END OF STMT
EXEC =
#5:c=3D0,e=3D73,p=3D0,cr=3D0,cu=3D0,mis=3D0,r=3D0,dep=3D2,og=3D4,tim=3D18=
446744069886840263
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
PARSING IN CURSOR #3 len=3D345 dep=3D1 uid=3D0 oct=3D47 lid=3D0 =
tim=3D18446744069886993066 hv=3D3240680083 ad=3D'48cc978c'
BEGIN
IF USER =3D'COGNOSOP' THEN
EXECUTE IMMEDIATE 'alter session set timed_statistics=3Dtrue';
EXECUTE IMMEDIATE 'alter session set max_dump_file_size=3D
UNLIMITED';
EXECUTE IMMEDIATE 'alter session set tracefile_identifier=3D =
COGNOSOP';
EXECUTE IMMEDIATE 'alter session set events ''10046 trace name
context =
forever, level 8''';
END IF;
END;
*************************************************************************=
************************************************************************
Error 1 ( non-fatal) frequently reoccurs throughout our tracing =
sessions.
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
