Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

5

积分

0

好友

0

主题
1#
发表于 2011-12-26 12:21:01 | 查看: 11699| 回复: 9
oracle蓝屏问题11.2.0.zip (2.56 MB, 下载次数: 1109)

附件中是蓝屏的详细,请高手多指点指点,谢谢!
2#
发表于 2011-12-26 20:17:47
诊断信息:

1. 你安装的是 11.2 GI的哪个版本? 11.2.0.2 or 11.2.0.3  or 11.2.0.1 ?

2. MOS上的 相关信息

Windows: Can not Install Clusterware on x64 with More Than 32 Processors/Cores/Threads [ID 1177387.1]


  1. Applies to:
  2. Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
  3. Microsoft Windows x64 (64-bit)
  4. Symptoms
  5. Oracle Clusterware installation(10.2 - 11.1 CRS or 11.2 Grid Infrastructure) fails with a blue screen, WinDbg shows BugCheck D1 (DRIVER_IRQL_NOT_LESS_OR_EQUAL) against orafencedrv.sys or orafenceservice.sys or ntkrnlmp.exe on x64 Windows cluster with more than 32 Logical Processor(s).

  6. OR

  7. Oracle Clusterware fails to start with same symptoms after Logical Processor(s) are increased to above 32


  8. To find out the number of Logical Processor(s):

  9. ~~~~
  10. Run "msinfo32" from the command line or via the "Run" option.
  11. There will be a section like this.
  12. ~~~~~
  13. ...
  14. System Type x64-based PC
  15. Processor Intel(R) Xeon(R) CPU           E7540  @ 2.00GHz, 2000 Mhz, 6 Core(s), 12 Logical Processor(s)
  16. Processor Intel(R) Xeon(R) CPU           E7540  @ 2.00GHz, 2000 Mhz, 6 Core(s), 12 Logical Processor(s)
  17. Processor Intel(R) Xeon(R) CPU           E7540  @ 2.00GHz, 2000 Mhz, 6 Core(s), 12 Logical Processor(s)
  18. Processor Intel(R) Xeon(R) CPU           E7540  @ 2.00GHz, 2000 Mhz, 6 Core(s), 12 Logical Processor(s)
  19. ....

  20. This shows 4 physical CPUs each of which has 12 Logical Processors. This equals 48 ( 4 x 12 ) processors as far as the orafenceservice.sys is concerned and will cause the problem mentioned in this note.

  21. Cause
  22. The issue is caused by bug 10637621, relevant information can be seen in the following bugs:

  23. Bug:9901433 BLUE SCREEN OCCURED DURING INSTALLING CLUSTERWARE for 11.1.0.7.
  24. Bug:10027132 DURING INSTALLATION GI WIN X64 11.2 SERVER BUGCHECKS 0XD1 IN ORAFENCESERVIC.SYS and was determined to be a duplicate of Bug:9901433.
  25. Bug:10637621 11.2.0.2 WIN GI INSTALL @ BUGCHECKS WITH 0XD1 IN ORAFENCESERVICE.SYS

  26. The x64 fencing code currently has a limit of 32 processors.

  27. Solution
  28. bug 10637621 is fixed in :

  29.   10.2.0.4 Patch 43 patch 11731126
  30.   10.2.0.5 Patch 9 patch 12332704
  31.   11.2.0.2 Patch 3 patch 11731184

  32. It's recommended to apply latest patches to fix the issue; if patch is unavailable, please engage Oracle Support to request.


  33. As the issue affects initial clusterware configuration, here's a few workarounds:

  34. 1. Reduce number of CPUs to below 32, install clusterware, apply necessary patches and restore original number of CPUs.

  35. 2. OR install on node with less than 32 CPU, apply necessary patches and clone it to target cluster.

  36. 3. Or for 11.2.0.2 and above, utilize new feature Software Update Option to apply the patch before clusterware is configured. Refer to screenshots for details.

  37. References
  38. BUG:10027132 - DURING INSTALLATION GI WIN X64 11.2 SERVER BUGCHECKS 0XD1 IN ORAFENCESERVIC.SYS
  39. BUG:10637621 - 11.2.0.2 WIN GI INSTALL BUGCHECKS WITH 0XD1 IN ORAFENCESERVICE.SYS
  40. BUG:9901433 - BLUE SCREEN OCCURED DURING INSTALLING CLUSTERWARE.
复制代码



Hdr: 10027132 11.2.0.1 PCW 11.2.0.1 OSD PRODID-5 PORTID-233 9901433
Abstract: DURING INSTALLATION  GI WIN X64 11.2 SERVER BUGCHECKS 0XD1 IN ORAFENCESERVIC.SYS

----

PROBLEM:
--------
Windows Win2008 R2 x64
Two Node Dell 910 cluster.
During the installation process of 11.2 GI, when the GI Configuration
Assistant runs the server on which the installer runs will bug check with xD1
in OraFenceService.SYS ( OraFenceService+5456 )

This will occur no matter which of the two nodes is used as install node.
This is also reproducable on another idential 2 node cluster.

Unless the server is configured to not reboot on a bugcheck the server will
go into a tight reboot cycle always with the same bugcheck code on the same
driver.

DIAGNOSTIC ANALYSIS:
--------------------
From the buchcheck analysis it appears that the OraFenceService.sys is loaded
and then tries to write to NonPagedPoolExpansionStart but this fails.
-------
WRITE_ADDRESS: unable to get nt!MmNonPagedPoolExpansionStart
-------

The same issue occurs when the server goes into a reboot cycle after the
initial bugcheck during the GI install.  

WORKAROUND:
-----------
None.

RELATED BUGS:
-------------

REPRODUCIBILITY:
----------------

TEST CASE:
----------

STACK TRACE:
------------
******************************************************************************
*
*                                                                             
*
*                        Bugcheck Analysis                                    
*
*                                                                             
*
******************************************************************************
*

DRIVER_IRQL_NOT_LESS_OR_EQUAL (d1)
An attempt was made to access a pageable (or completely invalid) address at
an
interrupt request level (IRQL) that is too high.  This is usually
caused by drivers using improper addresses.
If kernel debugger is available get stack backtrace.
Arguments:
Arg1: 0000000000000000, memory referenced
Arg2: 0000000000000002, IRQL
Arg3: 0000000000000008, value 0 = read operation, 1 = write operation
Arg4: 0000000000000000, address which referenced memory

Debugging Details:
------------------


WRITE_ADDRESS: unable to get nt!MmNonPagedPoolExpansionStart
0000000000000000

CURRENT_IRQL:  2

FAULTING_IP:
+0
00000000`00000000 ??              ???

PROCESS_NAME:  System

DEFAULT_BUCKET_ID:  VISTA_RC

BUGCHECK_STR:  0xD1

TRAP_FRAME:  fffff88002c78d60 -- (.trap fffff88002c78d60)
............
MODULE_NAME: OraFenceService

IMAGE_NAME:  OraFenceService.SYS

DEBUG_FLR_IMAGE_TIMESTAMP:  4b4fd03c

SYMBOL_NAME:  OraFenceService+5456

FAILURE_BUCKET_ID:  X64_0xD1_W_OraFenceService+5456

BUCKET_ID:  X64_0xD1_W_OraFenceService+5456

Followup: MachineOwner
---------

回复 只看该作者 道具 举报

3#
发表于 2011-12-26 20:25:07
Action Plan:

1.  在命令行中 执行"msinfo32" 命令  会显示 处理器信息,如下图

win_cpu_info.png

在你的机器上运行,并上传结果

2.  若安装的是11.2.0.2 的GI ,那么尝试 放弃11.2.0.2 而安装11.2.0.3 GI

3.  或者在11.2.0.2 的基础上 utilize new feature Software Update Option 使用软体更新功能后再安装, 详见 附件的PDF文档:

10637621.pdf (307.09 KB, 下载次数: 1708)

回复 只看该作者 道具 举报

4#
发表于 2011-12-26 22:22:06
也可以参考 RAC 11gR2 on Windows installation http://t.askmaclean.com/thread-133-1-1.html 这个文档来安装

回复 只看该作者 道具 举报

5#
发表于 2012-1-8 00:21:20
我也遇到了同样的问题。
但我找不到oracle rac 11.2.0.3 的安装程序。
版主给个下载地址不了。

回复 只看该作者 道具 举报

6#
发表于 2012-1-8 00:23:14
你好

11.2.0.3 补丁可以从metalink (My Oracle Support)的Patch 专栏上下载, 前提是你有一个可用的metalink 账号或者CSI。

个人是无权传播 商业软件的。

回复 只看该作者 道具 举报

7#
发表于 2012-1-8 00:26:27
这个补丁是不是就是解决cpu核数>32的情况?

回复 只看该作者 道具 举报

8#
发表于 2012-1-8 00:29:51
11.2.0.3 是Oracle 11gR2 发布以来 第二个大的补丁集 Patchset ,  Patchset 是Oracle 修复以往基础版本上bug的一种手段, 一般一个Patchset 会修复上百个Bug, 也会引入部分的新特性。  

具体patchset 修复了那些问题 , 请具体参考 随patchset 附带的readme信息。

回复 只看该作者 道具 举报

9#
发表于 2012-1-8 00:33:13
好的,谢谢版本。我再试试。能不能过年,就看能不能安装成功了。

回复 只看该作者 道具 举报

10#
发表于 2012-1-8 11:23:04
貌似Window 2008 是有专门的版本 请下载专门的版本

还有Win2008 是正版不

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 02:10 , Processed in 0.065169 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569