ORA-12540: TNS: Internal Limit restricted.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-12540: TNS: Internal Limit restricted.

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Angry

    Hi all,

    We have started getting foll. errors all of a sudden in our Development database, which is in Oracle 81730 on Win NT.

    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12540: TNS:internal limit restriction exceeded
    TNS-12560: TNSrotocol adapter error
    TNS-00510: Internal limit restriction exceeded
    32-bit Windows Error: 8: Exec format error

    This is in listener.log file.

    Phy.Mem of the server is 2.6 GB.
    SGA size is about 1 GB.

    This is a development server. So, there is not too much load also on this server.

    What could be the reason of this problem.

    Thanks in Adv.

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Error: TNS 510
    Text: Internal limit restriction exceeded
    -------------------------------------------------------------------------------
    Cause: Too many files or sockets open simultaneously (or some other resource has been depleted).
    Action: For further details, trace the operation for protocol
    details.


    To increase the number of filehandles in non-paged memory you must increase physical memory on windowsNT. It appears that your user load has exceeded the capabilities of your current setup.


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