ORA-600(17175)错误

又是一个导致实例崩溃的BUG。

 

 

数据库版本10.2.0.4 RAC for Hp-UX 11.31，在出现这个错误的同时还出现了ORA-601的错误：

Wed Dec 1 01:57:55 2010
Errors in file /u01/app/oracle/admin/orcl2/bdump/orcl21_pmon_3250.trc:
ORA-00600: internal error code, arguments: [17175], [255], [], [], [], [], [], []
ORA-00601: cleanup lock conflict
Wed Dec 1 01:57:57 2010
Trace dumping is performing id=[cdmp_20101201015757]
Wed Dec 1 01:58:05 2010
LGWR: terminating instance due to error 472
Wed Dec 1 01:58:05 2010
Errors in file /u01/app/oracle/admin/orcl2/bdump/orcl21_lms1_3291.trc:
ORA-00472: PMON process terminated with error
Wed Dec 1 01:58:05 2010
Errors in file /u01/app/oracle/admin/orcl2/bdump/orcl21_lms2_3293.trc:
ORA-00472: PMON process terminated with error
Wed Dec 1 01:58:05 2010
Errors in file /u01/app/oracle/admin/orcl2/bdump/orcl21_lms3_3295.trc:
ORA-00472: PMON process terminated with error
Wed Dec 1 01:58:05 2010
Errors in file /u01/app/oracle/admin/orcl2/bdump/orcl21_lms0_3289.trc:
ORA-00472: PMON process terminated with error
Wed Dec 1 01:58:05 2010
Errors in file /u01/app/oracle/admin/orcl2/bdump/orcl21_lmon_3283.trc:
ORA-00472: PMON process terminated with error
Wed Dec 1 01:58:05 2010
Errors in file /u01/app/oracle/admin/orcl2/bdump/orcl21_lmd0_3287.trc:
ORA-00472: PMON process terminated with error
Wed Dec 1 01:58:05 2010
Shutting down instance (abort)
License high water mark = 421
Wed Dec 1 01:58:11 2010
Instance terminated by LGWR, pid = 3307
Wed Dec 1 01:58:15 2010
Instance terminated by USER, pid = 3444

在MOS上查询，发现最接近的描述为：Bug 7590297 : ORA-600 [17175] [255] ORA-601: CLEANUP LOCK CONFLICT CRASHED THE DATABASE。出现错误的同样是HP-UX平台，数据库版本10.2.0.3也非常接近。出现了ORA-600 17175的错误和ORA-601错误，而且连17175错误的第二个参数255都和当前的环境是一样的。可惜的是，Oracle并没有对这个BUG给出任何有价值的描述，而是认为需要进一步信息才能判断问题的原因。

对于已知的问题，ORA-600 [17175] in PMON when the Event 10235 Is Set with a Wrong Level描述的现象和当前十分接近，不过当前版本并未设置EVENT。

如果从错误信息看，在SHUTDOWN ABORT后出现了接连两个Instance terminated信息，一个描述是实例被LGWR中止，另一个描述是实例被用户中止。问题有可能出现在用户发出SHUTDOWN ABORT命令后，Oracle的PMON进程尝试清理锁进程是出现了异常。

这个错误应该属于比较罕见的问题，在MOS上也没有太多的信息，应该属于偶然产生的问题。

 

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

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