ORA-00600[17281] [1001]

SCENARIO:
In alert*.log:
Thu Nov 25 15:42:35 2010
Errors in file /orabin/product/admin/lsdb/udump/lsdb_ora_18285.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x38A97F1C0], [], [], [], [], []
ORA-01001: invalid cursor

In the trace file:
*** SESSION ID:(379.13320) 2010-11-25 15:42:35.984
*** 2010-11-25 15:42:35.984
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17281], [1001], [0x38A97F1C0], [], [], [], [], []
ORA-01001: invalid cursor
Current SQL statement for this session:
declare cursor NlsParamsCursor is SELECT * FROM nls_session_parameters;begin SELECT Nvl(Lengthb
(Chr(65536)), Nvl(Lengthb(Chr(256)), 1)) INTO :CharLength FROM dual; for NlsRecord in NlsParamsC
ursor loop if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then :NlsDateLanguage := NlsRecord.v
alue; elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then :NlsDateFormat := NlsRecord.value;
elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then :NlsNumericCharacters := NlsRecord
.value; elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then :NlsTimeStampFormat := NlsRe
cord.value; elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then :NlsTimeStampTZFormat
:= NlsRecord.value; end if; end loop;end;

SQL> select s.sid,s.serial#,s.program,s.username,p.spid from v$session s, v$process p
2 where s.paddr = p.addr
3 and p.spid = 18285;
SID SERIAL# PROGRAM USERNAME SPID
---------- ---------- -------------------- ---------- ------------
379 13320 OEUSER 18285

SQL> select sid,serial#,process,machine,osuser from v$session
2 where sid = 379;
SID SERIAL# PROCESS MACHINE OSUSER
---------- ---------- ------------ -------------------- ------------
379 13320 2456:476 SMIC-SH\1FP07599 E007599

SQL> select event,p1text,p1raw,p2text,p2raw,state
2 from v$session_wait where sid = 379;
EVENT P1TEXT P1RAW P2TEXT P2RAW STATE
---------------- ------------ -------------------- ---------- -------------------- ----------
SQL*Net message driver id 0000000054435000 #bytes 0000000000000001 WAITING
from client

CAUSE:
This issue related to running SQL through TOAD.

REFERENCE:
ORA-600 [17281] using TOAD [ID 329531.1]
Bug 4359111 OERI [17281][1001] can occur on session switch in UPI mode

This entry was posted in Oracle. Bookmark the permalink.

Leave a comment