ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(17281)(1001)错误

ORA-600(17281)(1001)错误

原创 Linux操作系统 作者:yangtingkun 时间:2011-03-10 21:48:26 0 删除 编辑

在客户的9.2.0.8 RAC环境的数据库中,发现了这个错误。

 

 

alert中的错误信息为:

Fri Feb 11 11:14:11 2011
Errors in file /u01/product/admin/RAC/udump/rac2_ora_1437816.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x7000000F9917C90], [], [], [], [], []
ORA-01001: invalid cursor
Fri Feb 11 11:14:11 2011
Errors in file /u01/product/admin/RAC/udump/rac2_ora_1437816.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x7000000F9917C90], [], [], [], [], []
ORA-01001: invalid cursor
Fri Feb 11 11:14:12 2011
Errors in file /u01/product/admin/RAC/udump/rac2_ora_1437816.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x7000000F9917C90], [], [], [], [], []
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [17281], [1001], [0x7000000F9917C90], [], [], [], [], []
ORA-01001: invalid cursor
Fri Feb 11 11:14:12 2011
Trace dumping is performing id=[cdmp_20110211111412]

对应的trace文件信息为:

p55a2$more /u01/product/admin/RAC/udump/rac2_ora_1437816.trc
/u01/product/admin/RAC/udump/rac2_ora_1437816.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /u01/product/oracle/9.2.0
System name:    AIX
Node name:      p55a2
Release:        3
Version:        5
Machine:        0001CFDDD600
Instance name: RAC2
Redo thread mounted by this instance: 2
Oracle process number: 211
Unix process pid: 1437816, image: oracle@p55a2 (TNS V1-V3)

*** SESSION ID:(170.50190) 2011-02-11 11:14:11.260
*** 2011-02-11 11:14:11.260
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17281], [1001], [0x7000000F9917C90], [], [], [], [], []
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(65536)), 1))    INTO :CharL
ength FROM dual;  for NlsRecord in NlsParamsCursor loop    if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then      :NlsDateLanguage := NlsRecord.value;    els
if NlsRecord.parameter = 'NLS_DATE_FORMAT' then      :NlsDateFormat := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then      :Nl
sNumericCharacters := NlsRecord.value;    elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then      :NlsTimeStampFormat := NlsRecord.value;    elsif NlsRe
cord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then      :NlsTimeStampTZFormat := NlsRecord.value;    end if;  end loop;end;
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedmp+0148          bl       ksedst               102974684 ?
ksfdmp+0018          bl       01FD3FC8            
kgeriv+0118          bl       _ptrgl              
kgeasi+00cc          bl       kgeriv               000000000 ? 110339570 ?
                                                   1101A1690 ? 11035E270 ?
                                                   11035E580 ?
kgicli+0164          bl       kgeasi               110006288 ? 110356E28 ?
                                                   438100004381 ? 200000002 ?
                                                   200000002 ? 000000000 ?
                                                   0000003E9 ? 000000002 ?
kgidlt+03a0          bl       kgicli               110279C20 ? 110279948 ?
kgidel+0018          bl       kgidlt               11003DC88 ? 1100620B8 ?
                                                   000000069 ? 000000000 ?
                                                   000000000 ?
perabo+00cc          bl       kgidel               7000000FE7C91C0 ?
                                                   7000000F37CCF38 ?
perdcs+0038          bl       perabo               7000000FCAA7290 ? 110006288 ?
                                                   1100029A0 ?
peidcs+00ac          bl       perdcs               7000000FCAA7290 ? 110006288 ?
kkxcls+00bc          bl       peidcs               FFFFFFFFFFFA468 ? 11033B198 ?
kxscln+0048          bl       kkxcls               103162830 ?
kkscls+0268          bl       kxscln               11033B9A8 ?
opicca+00f0          bl       kkscls               1009E7FEC ? FFFFFFFFFFFA690 ?
opiclo+0020          bl       opicca               FFFFFFFFFFFA9E0 ?
kpoclsa+004c         bl       opiclo               000000002 ?
opiodr+08cc          bl       _ptrgl              
ttcpip+0cc4          bl       _ptrgl              
opitsk+0d60          bl       ttcpip               11000CF10 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
opiino+0758          bl       opitsk               000000000 ? 000000000 ?
opiodr+08cc          bl       _ptrgl              
opidrv+032c          bl       opiodr               3C00000018 ? 4101FAED0 ?
                                                   FFFFFFFFFFFF970 ? 0A00F8D18 ?
sou2o+0028           bl       opidrv               3C0C000000 ? 4A0142C60 ?
                                                   FFFFFFFFFFFF970 ?
main+0138            bl       01FD39E0            
__start+0098         bl       main                 000000000 ? 000000000 ?
 

查询了一下metalink,发现问题是由于open_cursors参数设置偏小造成的,Oracle在文档[ID 793061.1]中描述了这个问题。Oracle给出的解决方案是增加初始化参数open_cursors的值。

检查数据库发现这个值是默认值300,确实比较小,看来问题多半就是由于这个参数引起的。

SQL> show parameter open_cursors

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300

根据Oracle的建议,增大了参数值。

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-689034/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10541616