96328612c9f0d8cec9.png (227.24 KB, 下载次数: 140)
2021-8-30 17:04 上传
操作系统为：WINDOWS 2008 R2 SP1企业版，
ORACLE 11.2.0.4 64位
内存32G还空闲8G,CPU空闲
作者: 郑全 时间: 2021-8-30 17:12
MOS上有一篇文档，暂时按这个修改为1024
但要重启生效.
Windows: Oracle Net or Connections Via the Listener Fail with TNS-12531 On Windows 64-bit Platform (Doc ID 1384337.1)
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Net Services - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Microsoft Windows x64 (64-bit)
Microsoft Windows x64 (64-bit) - Version: 2008 R2
TNS-12531 TNS: Failed to allocate memory
Symptoms
Attempting to connect via the listener or remotely to a database running on Windows.
The following error is thrown:Getting the error 'TNS-12531: TNS:cannot allocate memory'
It is possible that no other memory related errors are being thrown at the same time.
It is also possible that the error is fleeting or seems to correct itself.
Changes
There are no significant changes in the environment. It is possible that incoming traffic to the listener has increased and caused this error to occur.
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.
This change in the registry will require a restart of the Windows server in order for the change to take effect.
作者: 郑全 时间: 2021-8-30 17:16
注册表项的第二个值是每个与交互式窗口站关联的桌面堆 SharedSection 的大小。 在 WinSta0 应用程序交互窗口站中创建的每个桌面都需要 (堆) 。 该值以千字节 (KB) 为单位。
第三个值是与非交互窗口站关联的每个桌面的 SharedSection 桌面 堆大小。 该值以千字节 (KB) 为单位。
建议不要为第二个值设置超过 20480 KB SharedSection 的值。
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |