OraFAQ Forum: Networking and Gateways » ORA-12540: TNS:internal limit restriction exceeded

Home » RDBMS Server » Networking and Gateways » ORA-12540: TNS:internal limit restriction exceeded

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

ORA-12540: TNS:internal limit restriction exceeded [message #6236]

Fri, 04 April 2003 23:42

ram
Messages: 95
Registered: November 2000

Member

when i try to login to sqlplus i get this error message
ORA-12540: TNS:internal limit restriction exceeded

how do i rectify this

thank in advance
ram

Report message to a moderator

Re: ORA-12540: TNS:internal limit restriction exceeded [message #6237 is a reply to message #6236]

Sat, 05 April 2003 01:29

Barbara Boehmer
Messages: 9105
Registered: November 2002
Location: California, USA

Senior Member

From the Oracle on-line documentation (note: ORA-12540 is the same as TNS-12540):

"TNS-12540 TNS:internal limit restriction exceeded
Cause: Too many TNS connections open simultaneously.
Action: Wait for connections to close and retry."

Explanation of possible cause, found on a newsgroup, quoting metalink:

"The previous SQL*Plus session terminated abnormally which left a shadow process which was not properly cleaned up. If more than 3 of these shadow processes have been left, the next SQL*Plus session gets an error and is not able to connect."

Suggestions provided by Mahesh Rajendran to another user with the same problem:

"talk to your sysAdmin about increasing the values of
max_nprocs
maxusers
if these parameters are not explicitly defined ( most unix installations dont) ask him to use sysconf"

Report message to a moderator

Previous Topic:	validnode_checking for 1 database out of many
Next Topic:	Connecting VB to Oracle without Oracle Client.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 09:32:10 CDT 2025