上周在客户那巡检时,客户环境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博客 ” ,链接:https://blog.itpub.net/7199859/viewspace-580640/ ,如需转载,请注明出处,否则将追究法律责任。