客户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对系统的影响是非常有限的。