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

前两天清明节做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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-586451/