DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNS-12540: TNS:internal limit restriction exceeded

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    RDBMS Version:: Oracle 8161
    Operating System and Version:: WinNT 4.0 EE
    Error Number (if applicable):: TNS-12540

    Hi,

    I have configured my oracle backups thru Legato.
    Yesterday while taking Online backup, I got the subject error.
    Detail of error from sqlnet.log is as below :

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
    Time: 23-APR-2002 21:20:42
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12540
    TNS-12540: TNS:internal limit restriction exceeded
    ns secondary err code: 12560
    nt main err code: 510
    TNS-00510: Internal limit restriction exceeded
    nt secondary err code: 8
    nt OS err code: 0


    init.ora parameter
    processes = 160.
    sessions = 190

    Please advise.

    Regards
    Vijay



    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    U got problem with # of open file descriptors per 1 application (process).
    Probably this is internal OS (NT) problem with size of the table of file descriptors.
    I know, how i can solve this situation in unix, but not in NT.

  3. #3
    Join Date
    Aug 2001
    Posts
    75
    The error implies that you have hit a limit of some form. This is usually an OS limit that has been reached.

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


    Here is info from Oracle :-

    Problem Description
    -------------------

    You are receiving an ora TNS-12540 error intermitently
    when trying to make connections to the database. OPS
    and MTS are not being used in this configuration.

    The error might be:

    TNS-12540: TNS:internal limit restriction exceeded

    The alert log has an entry that looks like:

    skgpspawn failed category 27143

    The skgpspawn failed message refers to a failure to spawn
    a new session.


    Solution Description
    --------------------

    Performance monitor shows that the instance that that has
    the TNS-12540 error occurring is using right around 2gb of
    memory. The SGA for the instance is about 1.8gb of memory.
    Reconfiguring the SGA to take less memory allows for connections
    to be made sucessfully.

    The most significant init.ora settings that are a candidate to
    to reduce the size of the SGA are:

    db_block_buffers
    shared_pool_size
    java_pool_size
    sort_area_size
    sort_area_retained_size

    Explanation
    -----------

    Because non Enterprise Windows NT Server limits the amount of memory
    used per process to 2gb, the process for the instance could not
    allocate more memory for new connections.


    References
    ----------

    A Microsoft document that explains what is termed 4GT RAM Tuning can
    be found at:

    http://support.microsoft.com/support.../Q171/7/93.ASP



    Originally posted by vijay8282
    RDBMS Version:: Oracle 8161
    Operating System and Version:: WinNT 4.0 EE
    Error Number (if applicable):: TNS-12540

    Hi,

    I have configured my oracle backups thru Legato.
    Yesterday while taking Online backup, I got the subject error.
    Detail of error from sqlnet.log is as below :

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
    Time: 23-APR-2002 21:20:42
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12540
    TNS-12540: TNS:internal limit restriction exceeded
    ns secondary err code: 12560
    nt main err code: 510
    TNS-00510: Internal limit restriction exceeded
    nt secondary err code: 8
    nt OS err code: 0


    init.ora parameter
    processes = 160.
    sessions = 190

    Please advise.

    Regards
    Vijay



    OCP 8i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width