oracle 10.2.0.5遇ora-07445、ora-00108 hang住

qq69033472

今天突然遇到个问题
oracle 版本10.2.0.5
os版本linux 5.9

数据库hang住的时候，os hostname变了，但是没人修改过hostname，把hostname修改回来，oracle正常了，请教这有可能是bug导致的么？
（之前hostname是localhost.localdomain，oracle hang住的时候，hostname是n003-000-000-000.static.ge.com）

alter信息如下：
Wed Mar 12 16:08:44 CST 2014
Errors in file /Data/apps/oracle/admin/detail/bdump/detail_ora_15666.trc:
ORA-07445: exception encountered: core dump [kslgetl()+120] [SIGSEGV] [Address not mapped to object] [0x000000210] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Wed Mar 12 16:08:47 CST 2014
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=n003-000-000-000.static.ge.com)(PORT=1521))'
Wed Mar 12 16:08:48 CST 2014
Setting recovery target incarnation to 2
Wed Mar 12 16:08:48 CST 2014
Successful mount of redo thread 1, with mount id 808035340
Wed Mar 12 16:08:48 CST 2014
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Mar 12 16:08:48 CST 2014
ALTER DATABASE OPEN
Wed Mar 12 16:08:49 CST 2014
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Wed Mar 12 16:08:51 CST 2014
Started redo scan
Wed Mar 12 16:08:51 CST 2014
                                                                                                                                                      181431,1      99%
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11509.trc
Wed Mar 12 15:57:22 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=38
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11618.trc
Wed Mar 12 15:57:48 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=39
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11669.trc
Wed Mar 12 15:58:40 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=40
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11708.trc
Wed Mar 12 15:58:52 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=41
Wed Mar 12 15:59:34 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=42
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11787.trc
Wed Mar 12 15:59:35 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=43
Wed Mar 12 15:59:50 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=44
Wed Mar 12 16:00:35 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=45
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11847.trc
Wed Mar 12 16:00:49 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=46
Wed Mar 12 16:01:38 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=47
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11905.trc
Wed Mar 12 16:01:55 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=48
Wed Mar 12 16:02:29 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=49
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11930.trc
Wed Mar 12 16:02:56 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=50
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_11981.trc
Wed Mar 12 16:03:53 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=51
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_12037.trc
Wed Mar 12 16:04:09 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=52
Wed Mar 12 16:04:24 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=53
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_12045.trc
Wed Mar 12 16:04:52 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=54
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_12116.trc
Wed Mar 12 16:05:50 CST 2014
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=55
System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_12172.trc

qq69033472

Maclean Liu(刘相兵 发表于 2014-3-12 16:53
WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=54

系统基本是 hang住了

这个库是测试库，这两天开发只做一些select 查询，4点左右，数据库就强制shutdown了，没有4点左右的awr了，只有1点到2点的了

Maclean Liu(刘相兵

WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=54

系统基本是 hang住了

需要当时的AWR和 System State dumped to trace file /Data/apps/oracle/admin/detail/udump/detail_ora_12172.trc