我申请这个blog是为了督促自己,把自己平时的一些想法和思考结果保留下来。 本博客所有内容均为原创,如有转载请注明作者和出处

ORA-600(qerrmOFBu1)错误

上一篇 / 下一篇  2008-03-31 23:58:27 / 个人分类:Bug

仍然是9201上的一个bug

 

 

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

错误信息为:

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

Wed Jan 26 10:38:19 2005ITPUB个人空间 a5C-Y,{ `z&xI
Error 2068 trapped in 2PC on transaction 5.44.53356. Cleaning up.
1P-B SYR0Error stack returned to user:
9izR0r,o6o)Y0ORA-02068:
以下严重错误源于DATA01ITPUB个人空间(S{ JOCQ/if iI
ORA-01012: not logged on

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

Errors in file d:\oracle\admin\newzb\udump\newzb_ora_648.trc:
%\9T0\ q LmEr F0ORA-00600:
内部错误代码,参数: [qerrmOFBu1], [1013], [], [], [], [], [], []

Mon May 09 17:34:12 2005ITPUB个人空间3O7\1qG5j}GD+L D
Error 3106 trapped in 2PC on transaction 7.0.82718. Cleaning up.ITPUB个人空间}*p6pF~Si
Error stack returned to user:
8ks?e"O"l Z2j&L0ORA-03106:
致命的双工通信协议错误ITPUB个人空间 v X$p ~RJ%f,X}
ORA-02063:
紧接着line(源于DATA01

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

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

An ORA-600[qerrmoFBU1] may be signalled instead of a normal user error.

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

查询Oracle错误文档:

ORA-00028 your session has been killedITPUB个人空间w$v%oJWVdT
Cause: A privileged user killed the session and it is no longer logged in to the database.ITPUB个人空间T[ q*B3Y&X@
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
'^)uy7^ h;xQ"j7DQ?0Cause: 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.ITPUB个人空间8}K8{#t[9n)P8~
Action: Continue with the next operation.

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

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

 


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar