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

Thread: Ora-12540

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi

    I m getting this error.

    Running Oracle 816 on NT 4.0 .
    Processes - 160
    Sessions - 190

    How can i find max no of TNS conectins to database ?

    Oracle says

    TNS-12540 TNS:internal limit restriction exceeded

    Cause: Too many TNS connections open simultaneously.

    Action: Wait for connections to close and retry.



    Help

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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Most likely it is a resource issue. Do you have enough physical menory and swap space? Is there any OS limitation on concurrent network users?

    Sanjay

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Do you get any Win NT error code with this error?

    Sanjay

  4. #4
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    RAM on my server is 2 GB.

    Pagefile is of 10 GB.

    No WinNT Err is observed with this error.

    My oracle.exe is taking memory equal to 1.5 GB.

    What to DO now ?



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

  5. #5
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    3 GB Option

    Hi,

    Will enabling the 3 GB option may help me to overcome the problem.


    Or can I go for MTS config ?


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

  6. #6
    Join Date
    Mar 2002
    Posts
    13
    I think you can do either of the following:

    1) Increase value of PROCESSES parameter.

    2) Change to MTS.

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