ORA-600(ksnpost:ksnigb)錯誤
客戶10.2.0.5 RAC for HP-UX ia64出現ORA-600(ksnpost:ksnigb)的錯誤。
錯誤資訊如下：
Wed Apr 25 16:32:21 UTC 2012
Errors in file /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS,
facility=ORA; arguments: [ksnpost:ksnigb]
Wed Apr 25 16:32:55 UTC 2012
Trace dumping is performing id=[cdmp_20120425163255]
Wed Apr 25 16:32:56 UTC 2012
Errors in file /oracle/app/admin/orcl/bdump/orcl2_ora_5511.trc:
ORA-12012: 自動執行作業 8938 出錯
ORA-12801: 並行查詢伺服器 ORA-12801: 並行查詢伺服器 P122, instance orcldb2:orcl2 (2) 中發出錯誤訊號
ORA-00600: Message 600 not found; No message file for product=RDBMS,
facility=ORA; arguments: [ksnpost:ksnigb]
ORA-06512: 在 "SYS.DBMS_STATS", line 21275
中發出錯誤訊號
Wed Apr 25 16:35:41 UTC 2012
Errors in file /oracle/app/admin/orcl/bdump/orcl2_ora_19966.trc:
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 44
Additional information: 65598
Additional information: 2734688
Wed Apr 25 16:35:41 UTC 2012
Errors in file /oracle/app/admin/orcl/bdump/orcl2_ora_19966.trc:
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 44
Additional information: 65598
Additional information: 2734688
Wed Apr 25 16:35:41 UTC 2012
Errors in file /oracle/app/admin/orcl/bdump/orcl2_ora_19966.trc:
ORA-27041: unable to open file
HPUX-ia64 Error: 23: File table overflow
Additional information: 44
Additional information: 65598
Additional information: 2734688
詳細TRACE資訊為：
orcldb2>more /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc
Dump file /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/app/product/10.2.0/db_1
System name: HP-UX
Node name: orcldb2
Release: B.11.31
Version: U
Machine: ia64
Instance name: orcl2
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 17014, image: oracle@orcldb2
Ioctl ASYNC_CONFIG error, errno = 1
*** SERVICE NAME:(SYS$USERS) 2012-04-25 16:32:21.472
*** SESSION ID:(377.37550) 2012-04-25 16:32:21.472
*** 2012-04-25 16:32:21.472
ksedmp: internal or fatal error
ORA-00600: Message 600 not found; No message file for product=RDBMS,
facility=ORA; arguments: [ksnpost:ksnigb]
Current SQL statement for this session:
select /*+ parallel_index(t,"IDX_PRODUCT_ID",96) dbms_stats
cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring
no_expand index_ffs(t,"
IDX_PRODUCT_ID") */ count(*) as nrw,count(distinct
sys_op_lbid(82769,'L',t.rowid)) as nlb,count(distinct "PRODUCT_ID")
as ndk,sys_op_countchg(substrb(t.rowid
,1,15),1) as clf from "ORCL_UNICOM"."MESSAGE_LOG" sample
block ( .4377057550,1) t where ("PRODUCT_ID" is not null)
and (TBL$OR$IDX$PART$NUM("ORCL_UNICOM"."M
ESSAGE_LOG",0,4,0,"ROWID") = :objn)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
40000000040333a0 call 4000000004035b60 000000000 ? 000000001 ?
4000000004032b40 call 4000000004033360 000000000 ?
C000000000000D20 ?
4000000004032B40 ?
000000000 ? 000000000 ?
000000000 ?
400000000407abb0 call 40000000040322c0 000000003 ?
9FFFFFFFFFFEFC10 ?
60000000000BA268 ?
9FFFFFFFFFFF01E0 ?
C000000000000999 ?
400000000407ABB0 ?
40000000098c33d0 call 400000000407ab40 9FFFFFFFFFFF0770 ?
000000003 ?
9FFFFFFFFFFF01F0 ?
60000000000BA268 ?
C000000000000612
?
40000000098C33D0 ?
40000000098c41c0 call 40000000098c32a0 60000000000318D0 ?
4000000001ADC4E0 ?
6000000000032988 ?
4000000001ADC4E0 ?
9FFFFFFFFFFF07A0 ?
4000000004030400 call 40000000098c4180 60000000000318D0 ?
9FFFFFFFFD364638 ?
9FFFFFFFFD364648 ?
6000000000032D00 ?
9FFFFFFFFFFF07A0
?
4000000002071430 call 4000000004030350 4000000000F67410 ?
000000000 ?
60000000000C6C98 ?
40000000030c7ce0 call 40000000020713d0 C000001FF2838160 ?
60000000000BA268 ?
C000000000000797 ?
40000000030C7CE0 ?
9FFFFFFFFFFF07DC ?
9FFFFFFFFFFF07E0 ?
9FFFFFFFFFFF07D0 ?
000000001 ?
40000000030c8940 call 40000000030c7a50 C0000020351ED5A0 ?
查詢MOS，發現和問題文件Get Various ORA-600 Error Followed By "HPUX-ia64 Error: 24: Too many open files" [ID 1061351.1]描述得比較接近。雖然文件描述的問題是HPUX-ia64 Error: 24，而當前的錯誤是HPUX-ia64 Error: 23: File table overflow，但是二者的本質是一樣的。
從錯誤資訊上看65598已經超過了設定值65536，針對這個問題，可以透過調整核心引數的方式進行解決，可以參考文件How to Increase the Number of Open Files on HP-UX [ID 1264834.1]。
而對於當前的情況，問題發生在並行執行上，並行度開到96顯然過大，將其降至並行度16應該就可以避免該錯誤。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/4227/viewspace-730017/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-600(kffmXpGet)錯誤
- ORA-600(kcbgcur_1)錯誤GC
- ORA-600 [ttcgcshnd-1 ]錯誤GC
- ORA-600(kclgclk_7)錯誤GC
- ORA-600(kcbnew_3)錯誤
- ORA-600(qersqCloseRem-2)錯誤REM
- ORA-600(qctopn1)錯誤
- ORA-600(kcblasm_1)錯誤ASM
- ORA-600(qkaffsindex5)錯誤Index
- ORA-600(kghuclientasp_03)錯誤client
- ORA-600(ttcgcshnd-2)錯誤GC
- ORA-600(kolaslGetLength-1)錯誤
- ORA-600(kghfremptyds)和ORA-600(kghasp1)錯誤REM
- ORA-600(kssadd: null parent)錯誤Null
- ORA-600(504)(row cache objects)錯誤Object
- ORA-600(ktrgcm_3)錯誤GC
- ORA-600(krvxdds: duplicated session not）錯誤Session
- ORA-600(kjxgrdecidemem1)錯誤IDE
- ORA-600(kfioUnidentify01)錯誤IDE
- ORA-600(qsmqSetupTableMetadata-2)錯誤MQ
- ORA-600(kcratr_scan_lastbwr)錯誤AST
- ORA-600(evapth : unexpected evaluation)錯誤APT
- ORA-600(qkacon:FJswrwo)錯誤JS
- ORA-600(KSFD_DECAIOPC)和ORA-600(kfioReapIO00)錯誤AIAPI
- ORA-600(kocgor077)錯誤Go
- ora-600內部錯誤的型別型別
- ORA-600(kkoipt:invalid join method)錯誤
- ORA-600[6122]錯誤處理
- ORA-600(krboReadBitmap_badbitmap)錯誤
- ORA-600(kcbchg1_12)和ORA-600(kdifind:kcbget_24)錯誤
- ORA-600(ktfbbsearch-8)和ORA-600(kewrose_1)錯誤ROS
- ORA-600(kjbrchkpkeywait:timeout)和ORA-600(kclcls_8)錯誤AI
- ORA-600(kauxs_do_jou:3)錯誤UX
- oracle 10.2.0.5 平臺上ORA-600錯誤Oracle
- ORA-600(kcbz_check_objd_typ_3)錯誤OBJ
- ORA-600(kgscLogOff-notempty)錯誤Go
- ORA-600(kssadd_stage: null parent)錯誤Null
- ORA-600[4000]/[4097]錯誤的處理