10.09.2006 16:50
bob
 
После выставления параметра cursor_sharing=force, при просмотре DBA-studio всех параметров инициализации базы появляется пустое окно без параметров. При попытке перейти на вкладку MEmory DBA-шка зависает. В алерт-логе появляется информация об ошибке ORA-0600. Версия Oracle - 8-ка. На других форумах рекомендуют пропатчить базу до 8.1.7.4.
10.09.2006 19:43
OlegON
 
А какая 600? Первый параметр какой? У меня в свое время сам СМ валился, но по показаниям очевидцев, в более поздних версиях это поправили.
11.09.2006 06:48
bob
 
Errors in file f:\oracle\admin\TEOREMA\udump\ORA02488.TRC:
ORA-00600: код внутр. ошибки, аргументы: [17182], [44449368], [], [], [], [], [], []
11.09.2006 10:10
OlegON
 
Вот, попробуй память проверить и полистать среди багов свое условие. Мне такое не попадалось.

PURPOSE:
This article discusses the internal error "ORA-600 [17182]", 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 [17182] [a] [b] [c] [d] [e]

VERSIONS:
versions 7.0 to 9.2

DESCRIPTION:

Oracle has detected that the magic number in a memory chunk header has been
overwritten.

This is a heap (in memory) corruption and there is no underlying data
corruption.

The error may occur in the one of the process specific heaps
(the Call heap, PGA heap, or session heap) or in the shared heap (SGA).


FUNCTIONALITY:
HEAP MANAGEMENT

IMPACT:
PROCESS FAILURE
MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE.
NON DATA CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

Check to see if the issue is reproducable.

Check the OS system logs (/var/adm/messages on Solaris, for example)
for any memory corruption and run low level memory tests on the system.

If reproducable, send alert.log and trace files to support.

Known Issues:

Bug# 4899479 See Note 4899479.8
Undo/redo corruption if distributed transactions used
Fixed: 11

Bug# 4104619 See Note 4104619.8
DIAG may fail with OERI[17182] during dumping of information
Fixed: 9.2.0.7, 10.1.0.2

Bug# 4061532 See Note 4061532.8
OERI [17182] / memory corruption from ANY_PATH predicate
Fixed: 10.1.0.5, 10.2.0.1

Bug# 3139818 See Note 3139818.8
OERI[17182] / memory corruption / data corruption from JAVA only TRIGGER
Fixed: 9.2.0.5, 10.1.0.2

Bug# 3053014 See Note 3053014.8
Memory corruption during/after query on IOT using subset of PK columns
Fixed: 9.2.0.8, 10.1.0.2

Bug# 3051782 See Note 3051782.8
Logical standby may fail with OERI:17182 / memory corruption
Fixed: 9.2.0.5, 10.1.0.2

Bug# 2912559 See Note 2912559.8
OERI[17182] / memory corruption possible on COMMIT in XDB
Fixed: 9.2.0.5, 10.1.0.2

Bug# 2839655 See Note 2839655.8
Single byte CGA memory corruption using NLS_COMP=ANSI with PLSQL
Fixed: 9.2.0.5, 10.1.0.2

Bug# 2712376 See Note 2712376.8
DIAG process suffers PGA memory corruption / OERI[17182]
Fixed: 9.2.0.7, 10.1.0.2

Bug# 2686597 See Note 2686597.8
Private memory corruption from LIKE used as index stop key
Fixed: 9.2.0.1

Bug# 2491893 See Note 2491893.8
OERI:17182 from refresh of DB2 tables using DBMS_PASSTHROUGH
Fixed: 9.0.1.0

Bug# 2281320 See Note 2281320.8
OERI:17182 possible during memory free under <Function:kkscls>
Fixed: 9.0.1.0

Bug# 2228280 + See Note 2228280.8
Private memory corruption possible with OPTIMIZER_MODE=RULE if tracing sometimes used
Fixed: 9.0.1.4, 9.2.0.2, 10.1.0.2

Bug# 2152752 See Note 2152752.8
Memory corruption / OERI:17182 possible fetching CHAR from DB2 over HS
Fixed: 8.1.7.4, 9.0.1.3, 9.2.0.1

Bug# 1771999 See Note 1771999.8
OERI[17182] under ksfdvread reading >1Mb contiguous data blocks
Fixed: 9.2.0.1

Bug# 1752554 See Note 1752554.8
OERI:17182 selecting DB2 DATA TYPE of CHAR over HS
Fixed: 8.1.7.3, 9.0.1.1, 9.2.0.1

Bug# 1542218 See Note 1542218.8
Heap corruption (OERI:17182 / dump in kghfrf) using very large collections
Fixed: 8.1.7.3, 9.0.1.2, 9.2.0.1

Bug# 1522053 See Note 1522053.8
Sporadic "session heap" memory corruption (eg: OERI:17182)
Fixed: 8.1.6.3

Bug# 1365873 See Note 1365873.8
OERI:17182 / CGA corruption with CURSOR_SHARING=FORCE
Fixed: 8.1.7.2, 9.0.1.0

Bug# 1279398 See Note 1279398.8
OERI:17182 from ALTER SESSION SET NLS_.. when CURSOR_SPACE_FOR_TIME=TRUE
Fixed: 8.1.6.2, 8.1.7.0

Bug# 1060189 See Note 1060189.8
OERI:17182 corrupt session heap from UNION ALL over DBLINK
Fixed: 8.0.6.2, 8.1.6.2, 8.1.7.0

Bug# 939235 See Note 939235.8
Corrupt data on PCTAS with MAX/MIN on VARCHAR2 & GROUP BY & INSTANCES>1
Fixed: 8.0.6.1

Bug# 917604 See Note 917604.8
Oracle Trace can cause SGA heap corruption (OERI:17182)
Fixed:

Bug# 916309 See Note 916309.8
PQ: Private memory corruption from AVG() & OR on PARTITIONED table
Fixed: 8.0.6.1, 8.1.6.0

Bug# 914998 See Note 914998.8
Cntrl-C during a select from GV$PQ_SLAVE can cause OERI:17182
Fixed: 8.1.7.0

Bug# 862170 See Note 862170.8
Work heap mem corr. / wrong results using CONCAT BITMAP index
Fixed: 7.3.4.5, 8.0.6.1, 8.1.6.0

Bug# 825260 See Note 825260.8
OCI: OERI:17182 possible binding uninitialized data of type SQLT_VNU
Fixed: 8.1.5.1, 8.1.6.0

Bug# 808049 See Note 808049.8
OERI:17182 using INDEX_DESC on concat index & LIKE predicates
Fixed: 7.3.4.5, 8.0.4.4, 8.0.5.2, 8.0.6.0

Bug# 802297 See Note 802297.8
OERI:17182 heap corruption setting TIMED_STATISTICS=TRUE
Fixed: 8.1.5.1, 8.1.6.0

Bug# 801692 See Note 801692.8
OERI:17182 from QC after single row parallel query
Fixed: 8.0.5.2
Часовой пояс GMT +3, время: 02:54.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.