-
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
-
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
-
Do you get any Win NT error code with this error?
Sanjay
-
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 ?
-
3 GB Option
Hi,
Will enabling the 3 GB option may help me to overcome the problem.
Or can I go for MTS config ?
-
I think you can do either of the following:
1) Increase value of PROCESSES parameter.
2) Change to MTS.