DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2000
    Maputo, Maputo-Mozambique
    Hi Folks!
    I'm running Oracle on UX-HP version 10.20; Everyday I get the following error on the production database:

    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
    HPUX Error: 12: Not enough space

    What is the solution?

    In god i trust

  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland
    In /stand/system file you have defined probbaly too few files that can be opned at a time. Increase and reboot.

    I had once a similar problem but it was related to semaphores.

  3. #3
    Join Date
    Apr 2001
    I had similar error after I shutdown DB and try to restart it.
    ORA- 12540, 00000, "TNS:internal limit restriction exceeded"

    The reason was TNS still had too many connection while DB was down.
    In my case, stop and restart the listener took care of it.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.