win_64位平臺(tái)報(bào)ora-12531

配置256g內(nèi)存的機(jī)器，監(jiān)聽時(shí)連得上時(shí)連不上，然后查看監(jiān)聽日志，報(bào)

TNS-12531: TNS:cannot allocate memory，也不是次次都報(bào)，重復(fù)連個(gè)幾次，就這樣了；

查下MOS說(shuō)明：

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=sx***v,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.

說(shuō)明一下：

第三個(gè) SharedSection 值 (512) 是為"非交互式"窗口站與相關(guān)聯(lián)的每個(gè)桌面桌面堆的大小。如果不存在此值為非交互式窗口站桌面堆的大小將與為交互式窗口站 （第二個(gè) SharedSection 值） 指定的大小相同。

檢查了一下這個(gè)值，為2048已經(jīng)調(diào)大，如果加大，確實(shí)能緩解這個(gè)問(wèn)題，但此時(shí)連接的會(huì)話并不多，才73個(gè)，那么問(wèn)題明顯不在這；是誰(shuí)把這非交互式堆棧耗完了呢，看下了進(jìn)程數(shù)，全為conhost&cmd.exe進(jìn)程，也就是這玩意用完了；

簡(jiǎn)單暴力點(diǎn)，直接：taskkill /im:conhost.exe /f，沒(méi)有再報(bào)錯(cuò)了；

官方也明確說(shuō)了，這是個(gè)BUG

在11.2.0.3.10中修復(fù)；

驗(yàn)證方法：

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

臨時(shí)解決辦法是殺了就好了,如果做進(jìn)程分析，可以考慮用windbg做下，

首先導(dǎo)入SRV*C:\Symbols*http://msdl.microsoft.com/download/symbols

open一個(gè)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_amd64/dbg_amd64.msi

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