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....
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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
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 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
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.