win_64位平台报ora-12531

标签：ora-12531   cmd   exe   

配置256g内存的机器，监听时连得上时连不上，然后查看监听日志，报

TNS-12531: TNS:cannot allocate memory，也不是次次都报，重复连个几次，就这样了；

查下MOS说明：

Windows: Oracle Net or Connections Via the Listener Fail with TNS-12531 On Windows 64-bit Platform (文档 ID 1384337.1)

CAUSE

This can be caused by an inadequate setting for Desktop Heap Size. Even if this is a 64-bit OS with high amount of memory, there is still a limitation that generates this error.
Of course, it can also be caused when the memory is actually low.  Check the resource consumption at the time of this problem.  If there is no apparent memory shortage, 
the solution documented here may resolve the issue.

SOLUTION

Check and edit the Desktop Heap size located here in the registry:

Launch regedt32 and go to:

\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\SubSystems\

In the right pane, click on Windows and pull down Edit then select Modify.

You should see a string that resembles this in its entirety:

%SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows SharedSection=1024,20480,768 Windows=On SubSystemType=Windows ServerDll=basesrv,1 ServerDll=winsrv:UserServerDllInitialization,3 ServerDll=winsrv:ConServerDllInitialization,2 ServerDll=sxssrv,4 ProfileControl=Off MaxRequestThreads=16

Focus on this section:

Windows SharedSection=1024,20480,768

The third argument is the maximum amount of heap memory allocated to non interactive desktops. 
Increase this third value and check when the TNS error disappears. There is no optimum value. It
varies on each MS Windows server.

说明一下：

第三个 SharedSection 值 (512) 是为"非交互式"窗口站与相关联的每个桌面桌面堆的大小。如果不存在此值为非交互式窗口站桌面堆的大小将与为交互式窗口站 （第二个 SharedSection 值） 指定的大小相同。

检查了一下这个值，为2048已经调大，如果加大，确实能缓解这个问题，但此时连接的会话并不多，才73个，那么问题明显不在这；是谁把这非交互式堆栈耗完了呢，看下了进程数，全为conhost&cmd.exe进程，也就是这玩意用完了；

简单暴力点，直接：taskkill /im:conhost.exe /f，没有再报错了；

官方也明确说了，这是个BUG

在11.2.0.3.10中修复；

验证方法：

C:\Users\oradba>%ORACLE_HOME%\bin\cluvfy comp nodecon -n all

临时解决办法是杀了就好了,如果做进程分析，可以考虑用windbg做下，

首先导入SRV*C:\Symbols*http://msdl.microsoft.com/download/symbols

open一个dmp文件，

windbg常用命令：

下载WinDGG:http://msdn.microsoft.com/en-us/windows/hardware/hh852365

64bit:http://download.microsoft.com/download/A/6/A/A6AC035D-DA3F-4F0C-ADA4-37C8E5D34E3D/setup/WinSDKDebuggingTools/dbg_x86.msi

32bit:http://download.microsoft.com/download/A/6/A/A6AC035D-DA3F-4F0C-ADA4-37C8E5D34E3D/setup/WinSDKDebuggingTools/dbg_x86.msi

本文出自 “snowhill” 博客，请务必保留此出处http://snowhill.blog.51cto.com/339421/1971224

win_64位平台报ora-12531

标签：ora-12531   cmd   exe   

原文地址：http://snowhill.blog.51cto.com/339421/1971224