Error: ORA-12223 TNS-12223
Text: TNS:internal limit restriction exceeded
-------------------------------------------------------------------------------
Cause: Too many TNS connections open simultaneously.
Action: Wait for connections to close and re-try.
*** Important: The notes below are for experienced users - See Note 22080.1
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: Unix: 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.
Alpha:
- If Alpha/OSF returning this not necessarily a sqlnet problem.
Alp/OSF uses two task drivers?
Check that Unix Kernel Param 'sem-msl'is greater than the
init.ora <Parameter
![:P](https://www.developpez.net/forums/images/smilies/icon_razz.gif)
ROCESSES>
You can check the OS value of sem-msl using the command
"sysconfig -q ipc | grep msl"
References:
Note 1008370.6 ORA-12223: Using Oracle with SQL*Net on Unix
Note 1060517.6 TNS-12223, TNS-12540, TNS-510 errors during batch
processing.
Note 1073026.6 TNS-12204: ERROR WHEN CONNECTING THROUGH LISTENER
Note 16564.1 Quick Reference for Client/Listener trace
Partager