问题描述
客户11.2.0.3 RAC出现了ORA-600[k21gil:gtx]错误。
错误信息为:
Sat Sep 22 18:45:52 2012 Auto-tuning: Shutting down background process GTX1 Sat Sep 22 19:00:20 2012 Auto-tuning: Starting background process GTX1 Starting background process GTX1 Sat Sep 22 19:00:20 2012 GTX1 started WITH pid=584, OS id=21107 Sat Sep 22 19:02:41 2012 Auto-tuning: Starting background process GTX2 Starting background process GTX2 Sat Sep 22 19:02:42 2012 GTX2 started WITH pid=482, OS id=25715 Sat Sep 22 19:12:48 2012 Auto-tuning: Shutting down background process GTX2 Sat Sep 22 19:23:12 2012 Auto-tuning: Shutting down background process GTX1 Sat Sep 22 19:23:15 2012 Errors IN file /opt/app/oracle/product/11.2.0/diag/rdbms/orcl/orcl1/trace/orcl1_ora_3848.trc (incident=316569): ORA-00600: internal error code, arguments: [k2qgil:gtx], [1], [1], [], [], [], [], [], [], [], [], [] Incident details IN: /opt/app/oracle/product/11.2.0/diag/rdbms/orcl/orcl1/incident/incdir_316569/orcl1_ora_3848_i316569.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. Sat Sep 22 19:23:20 2012 Dumping diagnostic DATA IN directory=[cdmp_20120922192320], requested BY (instance=1, osid=3848), summary=[incident=316569]. Sat Sep 22 19:23:21 2012 Sweep [inc][316569]: completed Sweep [inc2][316569]: completed Sat Sep 22 19:34:22 2012 Auto-tuning: Starting background process GTX1 Starting background process GTX1 Sat Sep 22 19:34:22 2012 GTX1 started WITH pid=568, OS id=27173
专家解答
这个错误在MOS上只有一个11.1.0.7上的错误记录,Oracle人为需要进一步信息进行判断,没有明确的bug描述。根据错误信息不难判断,问题发生在GTX进程启动时。报错函数也体现了问题和GTX进程有关。而Oracle的GTX进程是Global Transaction Process,用来维护CLUSTER中XA全局事务的全局信息。
在报错发生后,Oracle后续成功启动了GTX进程,说明报错只是偶然性发生。既然Oracle目前没有任何的BUG描述,这个错误只能暂时忽略,目前看这个bug对系统的影响是非常有限的。
最后修改时间:2019-04-14 10:54:07
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。