OraFAQ Forum: Networking and Gateways » cannot allocate memory

Home » RDBMS Server » Networking and Gateways » cannot allocate memory (Windows 2003 32 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cannot allocate memory [message #414488]

Wed, 22 July 2009 06:17

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.

Report message to a moderator

Re: cannot allocate memory [message #414491 is a reply to message #414488]

Wed, 22 July 2009 06:21

babuknb
Messages: 1736
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

Report message to a moderator

Re: cannot allocate memory [message #414498 is a reply to message #414488]

Wed, 22 July 2009 06:30

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.

Attachment: alert_prod.log
(Size: 194.09KB, Downloaded 2531 times)

Report message to a moderator

Re: cannot allocate memory [message #414502 is a reply to message #414498]

Wed, 22 July 2009 06:35

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Check how may connection are inactive status.

why sga_max_size & sga_target same value?

Report message to a moderator

Re: cannot allocate memory [message #414503 is a reply to message #414498]

Wed, 22 July 2009 06:35

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.