ORA-600(qerrmOFBu1)错误

仍然是9201上的一个bug。

 

 

协助其他部门进行数据库的迁移，迁移之后习惯性的检查了一下alert文件，发现了这个ORA-600错误。

错误信息为：

Errors in file d:\oracle\admin\newzb\udump\newzb_ora_1488.trc:
ORA-00600: 内部错误代码，参数: [qerrmOFBu1], [28], [], [], [], [], [], []

Wed Jan 26 10:38:19 2005
Error 2068 trapped in 2PC on transaction 5.44.53356. Cleaning up.
Error stack returned to user:
ORA-02068: 以下严重错误源于DATA01
ORA-01012: not logged on

还有一组类似的错误信息为：

Errors in file d:\oracle\admin\newzb\udump\newzb_ora_648.trc:
ORA-00600: 内部错误代码，参数: [qerrmOFBu1], [1013], [], [], [], [], [], []

Mon May 09 17:34:12 2005
Error 3106 trapped in 2PC on transaction 7.0.82718. Cleaning up.
Error stack returned to user:
ORA-03106: 致命的双工通信协议错误
ORA-02063: 紧接着line（源于DATA01）

查询METALINK，这个错误是由于访问远端对象时，出现错误信息，而这个远端的错误信息没有被处理，因此以ORA-600错误的形式出现，而远端错误的错误号为600错误的第二个参数。关于qerrmOFBU1错误的详细描述可以参考：Doc ID:  Note:209363.1。

这个错误对应的bug信息为：Doc ID:  Note:2361148.8：

也就是说，这里实际上应该是远端错误ORA-1013和ORA-28。

查询Oracle错误文档：

ORA-00028 your session has been killed
Cause: A privileged user killed the session and it is no longer logged in to the database.
Action: Contact the database administrator. The administrator may be attempting to perform. an operation that requires users to be logged out. When the database administrator announces that the database is available, log in and resume work.

ORA-01013 user requested cancel of current operation
Cause: The user interrupted an Oracle operation by entering CTRL-C, Control-C, or another canceling operation. This forces the current operation to end. This is an informational message only.
Action: Continue with the next operation.

也就是说，导致远端错误的原因是由于用户自己中止，或被DBA手工KILL掉。因此这两种错误都可以被认为是正常的情况。

这个错误信息误报的问题在9202中被修正。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-220483/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-220483/