Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-07445错误

snail.zhm2815Sep 26 2012 — edited Oct 2 2012
OS version:AIX 61006
DB version:11.2.0.3.0

服务器hang住了,重启后查找原因,在alert 日志中发现如下错误:

Fri Sep 21 10:00:58 2012
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x700000018] [PC:0x10123F554, kglic0()+788] [flags: 0x0, count: 1]
Errors in file /oracle/product/diag/rdbms/rls/rls/trace/rls_m000_28377508.trc (incident=16977):
ORA-07445: 出现异常错误: 核心转储 [kglic0()+788] [SIGSEGV] [ADDR:0x700000018] [PC:0x10123F554] [Address not mapped to object] []
Incident details in: /oracle/product/diag/rdbms/rls/rls/incident/incdir_16977/rls_m000_28377508_i16977.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Sep 21 10:03:51 2012
Dumping diagnostic data in directory=[cdmp_20120921100351], requested by (instance=1, osid=28377508 (M000)), summary=[incident=16977].

从 10:00:00开始到夜晚 22:00:00每一个小时出现一次这个错误,怀疑是在收集快照时发生的错误,通过数据库查已经生成的快照信息,也是到早晨9:00:00为止。
夜晚 22:00:00 左右的时候,伴随着ora-07445错误,有ora-00445错误出现,如下所示:

Fri Sep 21 22:00:04 2012
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Fri Sep 21 22:00:32 2012
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1F9800003F48] [PC:0x10123F57C, kglic0()+828] [flags: 0x0, count: 1]
Errors in file /oracle/product/diag/rdbms/rls/rls/trace/rls_m000_30212172.trc (incident=17193):
ORA-07445: 出现异常错误: 核心转储 [kglic0()+828] [SIGSEGV] [ADDR:0x1F9800003F48] [PC:0x10123F57C] [Address not mapped to object] []
Incident details in: /oracle/product/diag/rdbms/rls/rls/incident/incdir_17193/rls_m000_30212172_i17193.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Sep 21 22:00:35 2012
Dumping diagnostic data in directory=[cdmp_20120921220035], requested by (instance=1, osid=30212172 (M000)), summary=[incident=17193].
Fri Sep 21 22:02:35 2012
Errors in file /oracle/product/diag/rdbms/rls/rls/trace/rls_mmon_27852936.trc (incident=16177):
ORA-00445: 后台进程 "m001" 在 120 秒之后仍没有启动
Incident details in: /oracle/product/diag/rdbms/rls/rls/incident/incdir_16177/rls_mmon_27852936_i16177.trc
Fri Sep 21 22:03:05 2012
PMON failed to acquire latch, see PMON dump
Fri Sep 21 22:04:05 2012
PMON failed to acquire latch, see PMON dump
Fri Sep 21 22:05:35 2012
PMON failed to acquire latch, see PMON dump
Fri Sep 21 22:07:11 2012
Errors in file /oracle/product/diag/rdbms/rls/rls/trace/rls_smco_4325680.trc (incident=16393):
ORA-00445: 后台进程 "W001" 在 120 秒之后仍没有启动
Incident details in: /oracle/product/diag/rdbms/rls/rls/incident/incdir_16393/rls_smco_4325680_i16393.trc
Fri Sep 21 22:08:07 2012
PMON failed to acquire latch, see PMON dump
Fri Sep 21 22:09:07 2012
PMON failed to acquire latch, see PMON dump
Fri Sep 21 22:09:17 2012
Errors in file /oracle/product/diag/rdbms/rls/rls/trace/rls_smco_4325680.trc (incident=16394):
ORA-00445: 后台进程 "W003" 在 120 秒之后仍没有启动
Incident details in: /oracle/product/diag/rdbms/rls/rls/incident/incdir_16394/rls_smco_4325680_i16394.trc
Fri Sep 21 22:10:37 2012
PMON failed to acquire latch, see PMON dump
Fri Sep 21 22:11:37 2012
PMON failed to acquire latch, see PMON dump
Fri Sep 21 22:12:54 2012

然后alert日志中只有 PMON failed to acquire latch, see PMON dump 错误。

我在oracle metalink上搜索 kglic0()+ 发现两个类似的bug:bug 12340939 和 bug 13550185,后来详细比较了这两个bug,发现我这的情况和bug 12340939几乎完全一样,但是看bug的描述文档中说在 11.2.0.3中已经修复。
请教各位大大,帮忙解释下,谢谢!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2012
Added on Sep 26 2012
3 comments
1,314 views