****Ora-00600 ora-07445错误问题****

[hrb_qiuyb]

最近我的一台数据库主机经常出现如下错误：
Errors in file /home/ora2/app/oracle/product/8.1.7/admin/zhyz2/udump/ora_1740_zhyz2.trc:
ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [11] [4160717848] [231750656]
[0]
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kzckini: nzdsi_initialize] [28
750]

不知是否谁遇到过，给参谋一下,如何解决的。

[苏丹-陈]

只两个错误都是Oracle的内部错误。最好需要Oracle的服务支持。
你到www.itpub.net上面问问。最好是上传你的trace文件和alert log文件。
以便大家共同出出主意 ：）

[penitent]

你看看ora_1740_zhyz2.trc里面写的是什么

[mycode]

2-50 Error Messages
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:
n timeouts
n file corruption
n failed data checks in memory
n hardware, memory, or I/O errors
n 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.

[mycode]

ORA-07445 exception encountered: core dump [string] [string] [string] [string]
[string] [string]
Cause: An operating system exception occurred which should result in the
creation of a core file. This is an internal error.
Action: Contact Oracle Customer Support.

[mycode]

综上，可以看出，最有可能是主机的磁盘存在问题。

[hrb_qiuyb]

To mycode:
不是ORA-07445 exception encountered错，是ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA;

我把一跟踪文件传上:
*** 2002-06-17 09:27:20.263
ksedmp: internal or fatal error
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kzckini: nzdsi_initialize] [28
750]
Current SQL information unavailable - no session.
----- Call Stack Trace -----
Error: stisini(),24 - Can't open /home/ora2/app/oracle/product/8.1.7/bin/oracleError: Stack Initialization Failure
Error: ssdinit() failed 24
Exception signal: 11, code = 800003fff7ff8418
sc_onstack: 00000000160dd490, sc_mask 0000000000000000
ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA; arguments: [11] [4160717848] [370005136]
[0]
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [kzckini: nzdsi_initialize] [28
750]
----- Call Stack Trace -----
Error: stisini(),24 - Can't open /home/ora2/app/oracle/product/8.1.7/bin/oracleError: Stack Initialization Failure
Error: ssdinit() failed 24
Exception signal: 11, code = 800003fff7ff9e68
sc_onstack: 00000000160dd490, sc_mask 0000000000000000
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL

[mycode]

ORA-07445: Message 7445 not found; No message file for product=RDBMS, facility=ORA;

指的是你的出错信息,Oracle系统找不到，它报出的不是Ora本身的错误；而不是告诉你连出错信息的详细信息也查不到。