|
|
| 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"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
