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)