ORA-00600 Может кто посмотрит на Металинке, спасибо.

arsgot
Дата: 23.09.2004 05:14:02
Oracle 9.2.0.4 W2k SP4
После некоторых ora-00600 все резко тормозит,коннекты не принимаются
приходится перегружать сервис,иногда операционку.

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [504], [0x39E435C], [640], [7], [shared pool], [1], [0], [0x39E4424]
ORA-00600: код внутр. ошибки, аргументы: [504], [0x39E4424], [160], [7], [shared pool], [2], [0], [0x39E435C]
ORA-00600: код внутр. ошибки, аргументы: [504], [0x9144424], [240], [7], [shared pool], [2], [0], [0x914435C]
ORA-00600: internal error code, arguments: [504], [0x3F44424], [160], [7], [shared pool], [2], [0], [0x3F4435C]
ORA-00600: internal error code, arguments: [504], [0x914435C], [160], [7], [shared pool], [1], [0], [0x9144424]
ORA-00600: код внутр. ошибки, аргументы: [504], [0x39E435C], [240], [7], [shared pool], [1], [0], [0x39E4424]
ORA-00600: internal error code, arguments: [504], [0x3C04424], [160], [7], [shared pool], [2], [0], [0x3C0435C]
ORA-00600: internal error code, arguments: [504], [0x9144424], [160], [7], [shared pool], [2], [0], [0x914435C]
ORA-00600: internal error code, arguments: [504], [0x39E435C], [160], [7], [shared pool], [1], [0], [0x39E4424]
dragonx
Дата: 23.09.2004 07:01:56

PURPOSE: This article discusses the internal error "ORA-600 [504]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance. ERROR: ORA-600 [504] [a] [c] [d] [e] [f] [g] VERSIONS: versions 6.0 to 9.2 DESCRIPTION: This ORA-600 triggers when a latch request violates the ordering rules for obtaining latches and granting the latch would potentially result in a deadlock. These ordering rules are enforced by assigning each latch a "level#", and checking requested-level vs owned-levels on each latch request. ARGUMENTS: Arg [a] the requested latch address Arg bit array of latches owned Arg [c] the level of the requested latch Arg [d] the name of the requested latch Arg [e] the child latch number of the requested latch Arg [f] if non zero, allows 2 wait gets of children Arg [g] address of latch owned at this level FUNCTIONALITY: KERNEL SERVICE LAYER - LATCHING IMPACT: PROCESS FAILURE NON CORRUPTIVE - No underlying data corruption. SUGGESTIONS: Look for trace files generated at the time of the error. Contact Oracle Support Services and provide the alert.log and associated trace files for further diagnosis. Known Issues: Bug# 3514664 See <Note 3514664.8> OERI[504][ges process hash list] possible in RAC during diagnostics dump Fixed: 9.2.0.6, 10.1.0.3, 10.2 Bug# 2890150 See <Note 2890150.8> OERI:504 possible in RAC Fixed: 9.2.0.4, 10.1.0.2 Bug# 2758770 See <Note 2758770.8> OERI:504 from Dispatcher/s when using TCP DB LINKS Fixed: 9.2.0.4, 10.1.0.2 Bug# 2689585 See <Note 2689585.8> LMS might encounter ORA-600[504] during the simultaneous shutdown Fixed: 9.2.0.3, 10.1.0.2 Bug# 2621310 See <Note 2621310.8> OERI:504 possible selecting from shared pool fixed tables in MTS Fixed: 9.2.0.4, 10.1.0.2 Bug# 2280027 See <Note 2280027.8> OERI:504 possible from using SNAPSHOTs against 8i Fixed: 9.0.1.4, 9.2.0.2, 10.1.0.2 Bug# 2189615 See <Note 2189615.8> OERI:25012 / OERI:504 [cache buffers chains] selecting from certain V$ tables Fixed: 8.1.7.4, 9.0.1.4, 9.2.0.1 Bug# 2095109 See <Note 2095109.8> LMD may die with OERI:504 on [KCL lock element parent latch] Fixed: 8.1.7.4, 9.0.1.0 Bug# 1874554 See <Note 1874554.8> Shared server may dump (in kmcfsq) or OERI:504 Fixed: 9.0.1.2, 9.2.0.1 Bug# 1642957 See <Note 1642957.8> OERI:KJUHL1 / OERI:504 / database hang possible from diagnostic dump routines Fixed: 8.1.7.3, 9.0.1.0 Bug# 1523608 See <Note 1523608.8> OERI:504 [cache buffers chains] possible selecting MDSYS.SDO_GEOMETRY data Fixed: 9.0.1.0 Bug# 708238 See <Note 708238.8> OERI:504 possible especially in OPS Fixed: 7.3.4.4, 8.0.5.2, 8.0.6.0, 8.1.5.0 Bug# 608736 See <Note 608736.8> OERI:504 for 'session queue latch' possible from PQ slave Fixed: 8.0.4.3, 8.0.5.1, 8.0.6.0, 8.1.5.0
arsgot
Дата: 23.09.2004 11:06:42
Спасибо.
А какие последние PATCH-и для 9.2.0.1 и 10.1.0.2 W2K 32bit ?
Oleg Afanasiev
Дата: 23.09.2004 11:08:17