又是一个导致实例崩溃的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上也没有太多的信息，应该属于偶然产生的问题。