Home » RDBMS Server » Networking and Gateways » cannot allocate memory (Windows 2003 32 bit)
cannot allocate memory [message #414488] Wed, 22 July 2009 06:17 Go to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
i am receiving this error on my oracle apps 11.5.10.2 server.
TNS-12531: TNS:cannot allocate memory and after this my forms user are unable to connect.
Re: cannot allocate memory [message #414491 is a reply to message #414488] Wed, 22 July 2009 06:21 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

TNS-12531: TNS:cannot allocate memory 
Cause: Sufficient memory could not be allocated to perform the desired activity.
 
Action: Either free some resource for TNS, or add more memory to the machine. 
For further details, turn on tracing and reexecute the operation 
Re: cannot allocate memory [message #414498 is a reply to message #414488] Wed, 22 July 2009 06:30 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
oracle database is 10g r2 and it's single node installation.
memory on machine is 8 GB but only 3 GB is using at maximum level.
Re: cannot allocate memory [message #414502 is a reply to message #414498] Wed, 22 July 2009 06:35 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Check how may connection are inactive status.

why sga_max_size & sga_target same value?
Re: cannot allocate memory [message #414503 is a reply to message #414498] Wed, 22 July 2009 06:35 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
i dont know it's DB issue or memory issue or network issue bcz in forms log file it's network dead error.
while in DB and Listner log it's memory error.
every thing was working fine but suddenly this error start coming.
  • Attachment: ifsrv60.log
    (Size: 12.45KB, Downloaded 344 times)
Re: cannot allocate memory [message #414504 is a reply to message #414503] Wed, 22 July 2009 06:39 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
106 inactive and 25 active after restart now.
  • Attachment: prod.log
    (Size: 43.54KB, Downloaded 210 times)
Re: cannot allocate memory [message #414544 is a reply to message #414504] Wed, 22 July 2009 09:29 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Post your sqlnet.ora

Is there any problem with your network?

Check OS log from eventvwr.msc

[Updated on: Wed, 22 July 2009 09:31]

Report message to a moderator

Previous Topic: TNS issue
Next Topic: ORA-12170: TNS: Connect timeout occurred
Goto Forum:
  


Current Time: Sat Dec 10 18:54:16 CST 2016

Total time taken to generate the page: 0.04941 seconds