Error: ORA 12223Text: TNS:internal limit restriction exceeded
---
Cause: Too many TNS connections open simultaneously.
Action: Wait for connections to close and re-try. Explanation:
A layer of the net code has run out of some resource.
Information lower down the error stack may help
identify the resource which is depleted.Diagnosis:
- Check the error stack for any OS errors (see sqlnet.log)
The OS errors at in the error stack normally indicate which
resource is depleted.
- You may also need to get client or listener trace output
to see what was happening when the resource was depleted.
- Check the OS kernel parameters for number of processes, file
handles etc.. Eg: NPROC, MAXUPRC, NFILE, NSTREAM
- This message will frequently appear when swap space is exhausted,
Check the memory usage.
- Check for lots of DEFUNCT process in the process listing. These
use up slots in the process table and would indicate a problem.
Rob Forster wrote in message ...
Received on Mon Dec 07 1998 - 09:49:53 CST
