ORA-12540 TNS: Internal Limit Restriction Exceeded

Posted on 2005-05-09
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:leoahmad
    LVL 22

    Assisted Solution

    You can try to increase your swap space on the database server.
    LVL 47

    Assisted Solution

    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
    LVL 5

    Accepted Solution


    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

    Thanks All

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now