建立物化视图导致数据库实例崩溃

这个BUG是在9204上碰到的最严重的一个bug，在建立物化视图的时候，直接导致了实例的崩溃。

物化视图的创建脚本就不贴出来了，语句比较长，其中大部分表是通过数据库链访问，而且还包括了树状查询，但是，物化视图功能并不复杂，既不是REFRESH FAST也不是ON COMMIT，更不是基于查询重写的。

用户进程包括如下的错误信息：

ORA-07445: exception encountered: core dump [00000001009FC6B0] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
Current SQL statement for this session:
CREATE SUMMARY "MIS2"."MIS2_GPO_ORDER_ITEM" COMPILE

而从后台PMON进程的日志文件可以看到下面的错误：

Oracle process number: 2
Unix process pid: 7920, image: oracle@newreport (PMON)

ORA-07445: exception encountered: core dump [0000000100AE6CF4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CCF32C8] [] []

.

.

.

ORA-07445: exception encountered: core dump [0000000100AE6640] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CCF32C8] [] []
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [0000000100AE6CF4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CCF32C8] [] []

.

.

.

ORA-07445: exception encountered: core dump [0000000100AE6640] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CCF32C8] [] []
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [0000000100AE6640] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CCF32C8] [] []
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [0000000100AE6CF4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7CCF32C8] [] []

用户进程7445错误的第一个错误参数是qsmkzii_init_qsmksinline。而PMON进程后台文件的错误函数分别是kksheqd和kkshlcu。

根据这些信息在METALINK上查询发现，最接近的bug为：Bug 3004764。

Bug 3004764 PMON may crash the instance with ORA-7445[KKSHEQD] / ORA-7445[KKSHLCU]

This note gives a brief overview of bug 3004764.

Affects:

Product (Component)	(Rdbms)
Range of versions believed to be affected	Versions >= 9.0.1.4 but < 10G
Versions confirmed as being affected	(None Specified)
Platforms affected	Generic (all / most platforms affected)

It is believed to be a regression in default behaviour thus:

· Regression introduced in 9.0.1.4

 Regression introduced in 9.2.0.2

Fixed:

This issue is fixed in

9.2.0.5 (Server Patch Set) 10g Production Base Release

Symptoms:

• Instance may crash
• Process may Dump / Abend / Abort
• Dump in or under kkshlcu

Related To:

• (None Specified)

Description

PMON may crash the instance by dumping with ORA-7445[KKSHEQD] or ORA-7445[KKSHLCU] when cleaning up a dead process if the process being cleaned up died (or was killed) at a specific point in the code.

The problem only occurs for specific scenarios and is most likely to occur if the aborted session was running DDL at the time it died.

这还是第一次碰到可以导致实例崩溃的BUG，不过想要避免这个bug也不算太过于困难。实践再一次证明，越复杂的功能越容易导致bug的产生。

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

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