遭遇ora-7445错误

昨天一台hp平台上的oracle数据库突然报了个ORA-07445: exception encountered: core dump [skgslsgf()+16] [SIGBUS] [unknown code] [0x000000010] [] []，查了oracle的错误文档，竟然是个内部bug。

数据库版本
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE    9.2.0.6.0       Production
TNS for HPUX: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production

操作系统版本
# uname -a
HP-UX xxx B.11.11 U 9000/800 2179175859 unlimited-user license

错误信息
ORA-07445 exception encountered: core dump [string] [string] [string] [string] [string] [string]
Cause: An operating system exception occurred which should result in the creation of a core file. This is an internal error.
Action: Contact Oracle Support Services.

metalink上Note:360309.1文档也记录了这个错误，该错误可以发生在9.2.0.5.0至10.2.0.2的任何平台的数据库中。

cause

This is bug:4008133
SELECT FROM V$LOCKED_OBJECT GETS ORA-7445[SKGSLSGF()+16]

Details:It was possible for a query against the v$lock family of views to core
dump under rare circumstances.


除了升级到11g，oracle也没有给出具体的解决方案。近期升级是不可能的了，好在这个bug不太会影响数据，先记录下来，再找解决方案。