Oracle version : 12.1.0.2.0
Microsoft Windows server 2012
RAM: 1TB (680GB free memory while getting this error)
One of our customer wants to run 80 SIDS and 80 listeners (each listener for
each database).. After all listeners are running, we are seeing TNS-12531: TNS:
cannot allocate memory. From Doc ID
1384337.1(https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=422793106930444&id=1384337.1&_afrWindowMode=0&_adf.ctrl-state=qi0lglvuc_210)
We got to know that changing third argument of
\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session
Manager\SubSystems\: will help us, Increasing this third value and check
whether TNS error disappears. There is no optimum value, it depends from one
system to another.
However we are planning to increase it, I see that there is no optimum value
for setting and maximum value is 8192.
Current value is
C:\Windows\system32\csrss.exe ObjectDirectory=\Windows
SharedSection=1024,20480,2048 Windows=On SubSystemType=Windows
ServerDll=basesrv,1 ServerDll=winsrv:UserServerDllInitialization,3
ServerDll=sxssrv,4 ProfileControl=Off MaxRequestThreads=16
We are planning to change it to 4096 Before proceeding further we want to know
1) how SharedSection is used for non-interactive processes running as
Local System? If we keep it 4096 will that impact the performance?
2) Any tools to monitor heap memory usage (sysads here tried installing
dheapmon and livekd, which is unable to do so on windows sever 2012)
3) Is there any other solution to work around on this?
Note: No traffic from application, just few connections.
Shared server configuration
