Printable View
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 ?
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.