Re: Too many TNS connections open simultaneously

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 11 May 1999 09:42:41 -0700
Message-ID: <37385E01.E866AAC3@us.oracle.com>

Philippe

Error: ORA 12223
Text: 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.

HTH. Pete

Philippe Gamba wrote:

> I've got a process that sometimes (around once per week) stoping with
> the following message :
>
> TNS 12223 : "Too many TNS connections open simultaneously"
>
> Who can tell me about what goes wrong in my application and what to look
> for ?
>
> Thanks
> --
> Philippe GAMBA (SO223) - SEMA GROUP TELECOM
> mailto:philippe.gamba_at_grenoble.sema.fr

--

Regards

Pete

---

Pete Sharman                              Email: psharman_at_us.oracle.com
Project Manager                           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

Oracle Corporation

SQL> select standard_disclaimer, witty_remark   2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

---

Received on Tue May 11 1999 - 11:42:41 CDT