ora-603，600 错误请教

ccw2003

Wed Jul 14 16:18:52 2004
Errors in file d:\oracle\product\10.1.0\admin\come\udump\come1_ora_3416.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [KGHFRE3], [0x32D193AC], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [6008], [8], [], [], [], [], [], []

ccw2003

每天生成10几个G 的trace 和log
可以不可以禁止全部纪录log的功能？

urmqck

不使用归档日志即可

ccw2003

怎样设置？

urmqck

用oracle的OEM工具可以设置，也可以用以下命令：
archive log list;查看当前在什么模式下
shutdown；
startup mount；
alter database noarchivelog；
alter database open；
注意如果在noarchivelog模式下，将不能做到联机备份，如果你的机器要求24x7服务，最好在archivelog下，这样出现故障比较容易恢复

ccw2003

hi,你说的是archive热备份模式把，
我的server没有运行archivelog 模式。但是由于有哦ora600错误，所以总是有udump,bdump的trace文件每天有10个G dump文件.
可以不可以设置数据库去掉自动记录log？
顺便水以下，我没法近metalink察看 ora-600的详细问题

renxiao2003

Bookmark Fixed font  Go to End

Doc ID:  Note:138586.1
Subject:  ORA-600 [17172]
Type:  REFERENCE
Status:  PUBLISHED
Content Type:  TEXT/PLAIN
Creation Date:  02-APR-2001
Last Revision Date:  21-MAY-2004


Note: For additional ORA-600 related information please read [NOTE:146580.1]  PURPOSE:               This article discusses the internal error "ORA-600 [17172]", 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 [17172] [a]  VERSIONS:   versions 7.0 to 9.2  DESCRIPTION:    The recovery location must be nulled by the client.    We are trying to allocate memory from the Shared Pool and the caller    has not passed a pointer whose value is null.  ARGUMENTS:   Arg [a] Always 0  FUNCTIONALITY:   Heap Manager  IMPACT:   PROCESS FAILURE   MEMORY CORRUPTION   NON CORRUPTIVE - No underlying data corruption.  SUGGESTIONS:            There may well be additional ORA-600 [17XXX] errors reported along    with this one.    See if the problem will reproduce, many are one time occurrences.    Check all memory hardware and operating system logs for any additional    errors.    If the Known Issues section below does not help in terms of identifying   a solution, please submit the trace files and alert.log to Oracle   Support Services for further analysis.     Known Issues:   Bug# 3089086   See Note 3089086.8       OERI[17172] / SGA corruption possible at startup       Fixed: 9.2.0.5, 10G     Bug# 2065386   See Note 2065386.8       Mem. Corruption / OERI:KGHFRE2 / OERI:17172 possible using bitmap indexes       Fixed: 8.1.7.3, 9.0.1.3, 9.2.0.1   
.

renxiao2003

在Ｍｅｔａｌｉｎｋ里关于这个错误的说明太多了，说出你的具体的错误，我帮你看看啊！

pearaep

把trace文件也贴上来看看吧。

SunPeng040709

看看会有帮助吗？
ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:

timeouts

file corruption

failed data checks in memory

hardware, memory, or I/O errors

incorrectly restored files

The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.

Action: Report this error to Oracle Support Services after gathering the following information:

events that led up to the error

the operations that were attempted that led to the error

the conditions of the operating system and databases at the time of the error

any unusual circumstances that occurred before receiving the ORA-00600 message

contents of any trace files generated by the error

the relevant portions of the Alter files

Note: The cause of this message may manifest itself as different errors at different times. Be aware of the history of errors that occurred before this internal error.