[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


ORA-12540 TNS: Internal Limit Restriction Exceeded

Posted on 2005-05-09
Medium Priority
Last Modified: 2012-06-21
Hello, Everyone

I just in trouble. I start my services successfully but the above errors appearts

It's urgent

I am trying to work out too but yr help is appriciateable
Question by:Muhammad Ahmad Imran
LVL 22

Assisted Solution

by:Helena Marková
Helena Marková earned 200 total points
ID: 13966082
You can try to increase your swap space on the database server.
LVL 48

Assisted Solution

schwertner earned 400 total points
ID: 13966310
Go to $ORACLE_HOME/network/log and see listener.log.
May be it is full. Clean it.
         Locate the full SQL*Net V2 error stack.
        For client processes see the 'sqlnet.log' file produced by the
        client. For the listener look at the listener.log file.

        If an error stack cannot be locate turn on client or server
        tracing and extract the error stack from the trace file.

        From the error stack the bottom error should identify an Operating
        System error which may give a clue as to which resource is
        being depleted.

        Typical problems are:
        - Out of system memory / swap
        - Out of process slots in the process table
        - Streams resources depleted
        - Out of File Handles

        It is useful to monitor the system with any OS monitoring

Accepted Solution

helpneed earned 400 total points
ID: 13966976

Cause: Too many TNS connections open simultaneously.
Action: Wait for connections to close and re-try.

check for the memory as all the others said


The errors being received indicate that the server has reach the limit for  the maximum number of users or processes.  
On Sun Solaris, the parameters for  these limits are defined in the /etc/system file with the following lines:
         set max_nprocs=xxx  
      set maxusers=xxx    

The sysconf utility can be used to see what the current values set for these  parameters in case they are not explicitly defined in the system file.    When the machine is rebooted, the machine will read the parameter files and  setup for the new parameters.

LVL 14

Author Comment

by:Muhammad Ahmad Imran
ID: 13983119
Thanks All

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question