ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-07445: exception encountered: core dump [CommonClientExit()+101] [SIGSEGV]

ORA-07445: exception encountered: core dump [CommonClientExit()+101] [SIGSEGV]

原创 Linux操作系统 作者:tolywang 时间:2009-04-07 11:29:09 0 删除 编辑

前两天清明节做Oracle9.2.0.4  RAC节点加入动作(加入第三个节点) ,  关闭节点1的时候发生一个ORA-07445错误, 这个错误直接在关闭的命令后反映出来的,并且在alert log中有记录 。如下:


ARC0: Evaluating archive   log 3 thread 1 sequence 28594
ARC0: Beginning to archive log 3 thread 1 sequence 28594
Creating archive destination LOG_ARCHIVE_DEST_1: '/ocfs_arch1/intel/1_28594.dbf'
ARC0: Completed archiving  log 3 thread 1 sequence 28594
Sat Apr  4 06:55:53 2009
Thread 1 advanced to log sequence 28596
  Current log# 2 seq# 28596 mem# 0: /ocfs_ctrl_redo/intel/redo02.log
  Current log# 2 seq# 28596 mem# 1: /ocfs_data/intel/redo02b.log
Sat Apr  4 06:55:53 2009
ARC0: Evaluating archive   log 1 thread 1 sequence 28595
ARC0: Beginning to archive log 1 thread 1 sequence 28595
Creating archive destination LOG_ARCHIVE_DEST_1: '/ocfs_arch1/intel/1_28595.dbf'
ARC0: Completed archiving  log 1 thread 1 sequence 28595
Sat Apr  4 08:09:27 2009
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 183
All dispatchers and shared servers shutdown
Sat Apr  4 08:09:39 2009
ALTER DATABASE CLOSE NORMAL
Sat Apr  4 08:09:39 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Apr  4 08:09:39 2009
Shutting down archive processes
Archiving is disabled
Sat Apr  4 08:09:39 2009
ARCH shutting down
Sat Apr  4 08:09:39 2009
ARCH shutting down
Sat Apr  4 08:09:39 2009
ARC0: Archival stopped
Sat Apr  4 08:09:39 2009
ARC1: Archival stopped
Sat Apr  4 08:09:44 2009
Thread 1 closed at log sequence 28596
Successful close of redo thread 1.
Sat Apr  4 08:09:45 2009
Completed: ALTER DATABASE CLOSE NORMAL
Sat Apr  4 08:09:45 2009
ALTER DATABASE DISMOUNT
Sat Apr  4 08:09:45 2009
Errors in file /u01/product/admin/intel/bdump/intel1_lck0_2167.trc:
ORA-07445: exception encountered: core dump [CommonClientExit()+101] [SIGSEGV] [Address not mapped to object] [0x49] [] []
Sat Apr  4 08:09:47 2009
Errors in file /u01/product/admin/intel/bdump/intel1_pmon_2116.trc:
ORA-00480: LCK* process terminated with error
Sat Apr  4 08:09:47 2009
PMON: terminating instance due to error 480
Sat Apr  4 08:09:47 2009
System state dump is made for local instance
Sat Apr  4 08:09:52 2009
Instance terminated by PMON, pid = 2116

 

后来查询发现是个Bug :   5113249  ,  看来以后得多用 Oracle 10.2.0.4 版本了 。

 

Bug No. 5113249
Filed 22-MAR-2006 Updated 11-OCT-2007
Product Oracle Server - Enterprise Edition Product Version 9.2.0.5
Platform Linux x86 Platform. Version No Data
Database Version 9.2.0.5 Affects Platforms Port-Specific
Severity Severe Loss of Service Status Closed, Verified by Filer
Base Bug N/A Fixed in Product Version 9.2.0.99

Problem statement:

LCK GENERATES ORA-7445 [COMMONCLIENTEXIT()+101] DURING SHUTDOWN


 

*** 03/22/06 11:37 pm ***

*** 03/23/06 12:10 am ***

*** 03/23/06 12:47 am *** (CHG: Asg->NEW OWNER)

*** 03/23/06 02:58 am ***

*** 03/24/06 12:52 am *** (CHG: G/P->P Asg->NEW OWNER)

*** 03/24/06 12:52 am ***

*** 03/24/06 12:53 am *** (CHG: SubComp->RAC)

*** 03/27/06 11:34 am *** (CHG: Asg->NEW OWNER)

*** 03/27/06 06:48 pm ***

*** 03/27/06 11:40 pm ***

*** 03/28/06 09:51 am ***

*** 03/28/06 12:57 pm ***

*** 03/28/06 12:57 pm *** (CHG: Sta->10)

*** 03/28/06 01:02 pm ***

*** 03/29/06 03:18 am ***

*** 03/29/06 03:19 am *** (CHG: Sta->16)

*** 03/29/06 02:40 pm ***

*** 03/29/06 02:40 pm *** (CHG: Sta->10)

*** 03/29/06 11:55 pm *** (CHG: Sta->16)

*** 03/29/06 11:55 pm ***

*** 03/30/06 04:15 am ***

*** 03/30/06 06:08 am *** ESCALATED

*** 03/30/06 06:08 am ***

*** 03/30/06 07:21 am ***

*** 03/30/06 07:21 am *** (CHG: Sta->10)

*** 03/30/06 08:41 am *** (CHG: Sta->16)

*** 03/30/06 09:55 am ***

*** 03/30/06 09:55 am *** (CHG: Sta->11 Asg->NEW OWNER)

*** 03/30/06 09:44 pm ***

*** 03/31/06 04:09 am *** (CHG: Asg->NEW OWNER)

*** 03/31/06 04:09 am ***

*** 04/07/06 03:26 am ***

*** 04/12/06 11:10 pm ***

*** 04/19/06 12:46 am ***

*** 04/20/06 12:11 am *** (CHG: Sta->30)

*** 04/20/06 12:11 am ***

*** 04/21/06 03:34 am *** (CHG: Sta->11)

*** 04/21/06 03:34 am ***

*** 05/01/06 09:52 pm ***

*** 05/09/06 11:18 pm ***

*** 05/10/06 10:14 am *** (CHG: Sta->30)

*** 05/10/06 10:14 am ***

*** 05/10/06 04:41 pm ***

*** 05/10/06 04:55 pm ***

*** 05/10/06 11:27 pm *** (CHG: Sta->11)

*** 05/10/06 11:27 pm ***

*** 05/10/06 11:28 pm ***

*** 05/10/06 11:28 pm ***

*** 05/11/06 10:37 am ***

*** 05/12/06 03:53 pm *** (CHG: Sta->30)

*** 05/12/06 03:53 pm ***

*** 05/15/06 12:51 am *** (CHG: Sta->11)

*** 05/15/06 12:51 am ***

*** 05/16/06 11:57 am *** (CHG: Sta->30)

*** 05/16/06 11:57 am ***

*** 05/17/06 01:32 am ***

*** 05/17/06 04:17 am *** (CHG: Sta->11)

*** 05/17/06 04:17 am ***

*** 05/17/06 12:51 pm *** (CHG: Fixed->9.2.0.5)

*** 05/17/06 12:51 pm *** ESCALATION -> CLOSED

*** 05/17/06 12:51 pm *** (CHG: Sta->90)

*** 05/17/06 05:23 pm ***

*** 05/18/06 01:42 pm *** (CHG: Fixed->9.2.0.99)

*** 05/18/06 01:42 pm ***

*** 07/17/06 10:50 am *** (CHG: Asg->NEW OWNER)

 

 

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

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13747802