Oracle Error Case: TNS-00510

TNS-00510 Internal Limit restriction exceeded

Cause Too Many files or sockets open simultaneously (or some other resource has).

Action for further details, trace the operation for protocol details.

TNS-12500 Tns:listener failed to start a dedicated server process

Cause the process of starting up a dedicated server process failed. The executable could is found or the environment may is set up incorrectly.

Action Turn on tracing in the ADMIN level and re-execute the operation. Verify that's Oracle Server executable is present and has execute permissions enabled. Ensure that's Oracle environment is specified correctly in LISTENER. ORA. The Oracle Protocol Adapter that are being called may isn't installed on the local hard drive. Check that the correct Protocol Adapter are successfully linked. If the error persists, contact Oracle Customer Support.

TNS-12540 tns:internal Limit restriction exceeded

Cause Too many TNS connections open simultaneously.

Action wait for connections to close and retry.

TNS-12560 Tns:protocol Adapter Error

Cause A Generic protocol adapter error occurred.

Action Check addresses used for proper protocol specification. Before reporting this error, look in the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off Tracing the operation is complete.

Q: Does the number of processes cause a listener error?

Tns-12500:tns:listener failed to start a dedicated server process

Tns-12540:tns:internal Limit restriction exceeded

Tns-12560:tns:protocol Adapter Error

Tns-00510:internal Limit restriction exceeded

Ibm/aix RISC system/6000 Error:11:resource temporarily unavailable

We found the error message as above in the Listener log. The maximum number of processes per user on the server is set to the maximum number of processes in Oracle is 600. The maximum utilization of the process is 482, and the maximum utilization per session is 490. The number of sessions is set to 840.

As I understand it, it seems that there is no problem with the number of processes. We have confirmed this by not building the memory paging space correctly on this machine, however, some people still tell us to increase the number of processes at the beginning. I disagree with this view. Did I miss something?

A: The TNS-510 error message shows that too many files or sockets are open at the same time (or some other resource is exhausted). This is a limitation of the operating system, not Oracle. You need to make sure that your AIX platform can handle so many files that you open on the server. This is a "all" file, not just an Oracle database file. Also, you need to make sure that your AIX server handles all the number of Oracle processes correctly, not just dedicated server processes. Oracle's starting parameter processes limits the number of dedicated server processes. But there are background processes (Smon, Pmon, LGWR, etc.) and processes that support parallel statements, not to mention your listeners. I think you should configure AIX to allow more processes for each UNIX user.