急啊！各位有ORA-00600错误解决方法吗?

lancelotg

00600错误后面都带很多参数的，你根据后面的参数去metalink上去查询一下，看看是否有解决方法，如果没有，可能需要咨询oracle公司的support了。

还有，你把600错误后面的参数贴出来，看看大家有没有碰到过？

wanggi

它在LOG档中留下的错误信息是这样：　
ORA-00600: \244\272\263\241\277\371\273~\275X, \260\321\274\306: [kghsstream_copyn], [], [], [], [], [], [], []

看不懂这是什么意思？

lancelotg

to wanggi：在metalink上看了一下，好像没看到你的参数kghsstream_copyn，看来你最好去咨询一下oracle的support。

wanggi

To lancelotg:　是啊，都不知道它那记录的是什么东东。一点也不明白。看来也只有找ORACLE　SUPPORT了，
请问大家一下，00600是不是数据库本来的一个BUG？

dwilson

这是引起ORA－00600错误的原因，建议对照核查：
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: 1.timeouts 2.file corruption 3.failed data checks in memory 4.hardware, memory, or I/O errors 5.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.

dwilson

这是提供的一些解决操作，可能还是需要OCS，希望对你有用：
Report this error to Oracle Customer Support after gathering the following information: 1.events that led up to the error 2.the operations that were attempted that led to the error 3.the conditions of the operating system and databases at the time of the error 4.any unusual circumstances that occurred before receiving the ORA-00600 message 5.contents of any trace files generated by the error 6.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.

wanggi

To dwilson
Thank you very much for me the issue. I will try it use your solution.

wanggi

我们已经没有买ORACLE　SUPPORT服务了，刚过期一个多月，怎么办，还有没有其它的办法？

lancelotg

如果你有测试环境的话，把erp的备份恢复到测试环境中看看是否仍然报错。

wanggi

奇怪，这个星期突然又正常，（我系统中设定脚本每个星期都会让应用与数据库自动重启一次）。是在这次重启后，再试着做那笔工单完工入库，没想到又没有报这个错误。不知做何解释。之前好像也没有对系统做其它的动作