TNS-12531: TNS:cannot allocate memoryThere is plenty of memory in the server (8 GB), which is running Windows 2003 Enterprise and Oracle 9.2, so I do not know which pool/group of memory it is refering too.
The server is currently set in dedicated mode, but I am thinking of changing it to shared to see if this helps. Any ideas would be appreciated.
As for memory, if you are running 32-bit Oracle on Windows with 8 gig, then your SGA cannot be more than 2 gig unless you are using 4GT or AWE.
Metalink says this about the TNS-12531 error: "The issue here seems to be that we are running out of desktop heap memory. Please refer to Bug 3186475. This problem may happen if you are running a lot of Windows services which consume same default desktop heap."
This was first published in November 2005