OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » ORA 12540

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

ORA 12540 [message #285501]

Tue, 04 December 2007 22:39

vivacious
Messages: 5
Registered: December 2007

Junior Member

Hi,

I noticed an error while installing Oracle 9i on my desktop,the error said:ORA 12540:TNS:internal limit restriction exceeded.What does this mean and how do I troubleshoot it?

Report message to a moderator

Re: ORA 12540 [message #285503 is a reply to message #285501]

Tue, 04 December 2007 22:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

This message is a bit misleading and indicates a resource problem.

Check the listener.log file for more information regarding O.S. errors.

The listener.log file is typically in $ORACLE_HOME/network/log or %ORACLE_HOME%\network\log directory.

Possible problems are:
* Out of memory or swap space
* Out of File Handles
* Maximum size of memory segment reached
* Maximum number of threads reached
* Out of sockets
...

http://www.dbmotive.com/oracle_error_codes.php?errcode=12540

Report message to a moderator