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 are receiving the above-error in our listener log. Max number of processes per user on the server is set at 600, and max number of process in Oracle is 600. Max utilization on the processes is 482 and max utilization on sessions is 490. The number of sessions is set to 840.
From what I'm reading, it appears to me the number of processes is fine. We have confirmed that our paging space is setup incorrectly on this box, yet someone is telling me to increase the number of processes in the init. I disagree. Am I overlooking something?
This was first published in April 2004