遇到用toad 監控資料庫時的ora-00600 [17281] 錯誤

paulyibinyi發表於2009-03-30

    上週在客戶那巡檢時,客戶環境oracle 10.2.0.2  rac +AIX 5300為,檢視後臺日誌記錄時

出現以下錯誤

Errors in file /oracle/admin/rac/udump/rac1_ora_987296.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x7000000DC981B98], [], [], [], [], []
ORA-01001: invalid cursor

引起的sql為


Current SQL -----------     Current SQL statement for this session: declare  cursor NlsParamsCursor is    SELECT * FROM  nls_session_parameters;begin  SELECT     Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(65536)), 1))    INTO :CharLength  FROM dual;  for     NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter =  'NLS_DATE_LANGUAGE' then     :NlsDateLanguage := NlsRecord.value;    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 := NlsRecord.value;     elsif     NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then       :NlsTimeStampTZFormat :=     NlsRecord.value;    end if;  end loop;end; .

 

透過查詢metalink,是透過toad監控時引起的bug


ORA-00600 [17281] [1001] FROM TOAD


Summary of Bugs On ORA-00600 [17281]
Bug 4359111 (Unpublished)

Abstract:OERI [17281] can occur on session switch in UPI mode

Version affected: 9.2.0.7,10.1.0.4 and 10.2.0.2

Fixed in version: 9.2.0.8, 10.1.0.5, 10.2.0.3 & 11.0

 

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-580640/,如需轉載,請註明出處,否則將追究法律責任。

相關文章