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."
Dig Deeper on Oracle error messages
Related Q&A from Don Burleson
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed...continue reading
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ...continue reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.