Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

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

Freeman, Donald

2004-08-03

Replies:
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@(protected)
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
-----------------------------------------------------------------