Home » RDBMS Server » Networking and Gateways » ora-12540 TNS internal limit restriction exceeded
ora-12540 TNS internal limit restriction exceeded [message #123553] Mon, 13 June 2005 23:01 Go to next message
srtor
Messages: 3
Registered: March 2005
Junior Member
I am using xp pro (sp2). I am consistently getting this message when trying to access the database using SQL/plus. Can anybody suggest any help?


Cheers

Fast Eddy
Re: ora-12540 TNS internal limit restriction exceeded [message #123590 is a reply to message #123553] Tue, 14 June 2005 01:39 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

Below is the info & corrective actions that can be taken about this error:

TNS-12540/ORA-12540: TNS:internal limit restriction exceeded and TNS-00510: Internal limit restriction exceeded
Cause: An internal limit has been exceeded. Possible limits include:
Number of open connection that Oracle Net can process simultaneously

Number of memory buffers which can be used simultaneously

Number of processes a particular database instance is allowed

The first two are examples of hard limits. The third is an example of a limit which can be increased by setting PROCESSES parameter in the database initialization file to a larger value. In this case, a TNS-12500/ORA-12500 error is also returned. In some cases, these errors can be caused by the same conditions which cause TNS-12549/ORA-12549 and TNS-00519 errors.

Action: Perform these steps:
Wait for the open connections to close and retry. If the error persists, then check the sqlnet.log or listener.log file for detailed error stack information.


...Girish

Source: http://zuse.esnig.cifom.ch/database/doc_oracle/Oracle10G/network.101/b10775/troublestng.htm#CEGDGHBJ
icon7.gif  Re: ora-12540 TNS internal limit restriction exceeded [message #340938 is a reply to message #123590] Fri, 15 August 2008 01:37 Go to previous messageGo to next message
catalyst
Messages: 3
Registered: August 2008
Location: Pakistan
Junior Member
Hi folks,

If you are using windows xp, this error can be due to switched users. Windows xp allows the facility to switch user without logging out.
So if this error appear but you can log in via SQLPLUS prompt using "username/password@servicename" but you cannot login using "username/password", then it is certainly due to above mentioned fact.

Cheers

Re: ora-12540 TNS internal limit restriction exceeded [message #340990 is a reply to message #340938] Fri, 15 August 2008 07:58 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Please take a little time to look at the questions you are answering and notice that the last response was 3 years ago. This is the second message you have answered like this.
Re: ora-12540 TNS internal limit restriction exceeded [message #341014 is a reply to message #340990] Fri, 15 August 2008 09:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nevertheless it is an interesting information. Cool

Regards
Michel
Re: ora-12540 TNS internal limit restriction exceeded [message #341020 is a reply to message #123553] Fri, 15 August 2008 09:30 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>So if this error appear but you can log in via SQLPLUS prompt using "username/password@servicename" but you cannot login using "username/password", then it is certainly due to above mentioned fact.

My view of reality is that with recent (V10) releases only user "oracle" can login as a local user on the database server itself. The file permissions preclude users outside the "dba" group from running utilities such as sqlplus.

When @TNS_ALIAS is used then it is the oracle user itself which invokes the acess & therefore succeeds.

Of course, others are free to disagree.
Re: ora-12540 TNS internal limit restriction exceeded [message #341231 is a reply to message #341020] Sun, 17 August 2008 22:53 Go to previous messageGo to next message
catalyst
Messages: 3
Registered: August 2008
Location: Pakistan
Junior Member
Hi folks

Good to see the forum live enough Smile. I toiled hard enough to find this. In the meantime I tried to find the reason here at OraFaq, but no reason seem to be applicable to my problem.

So i thought maybe someone else will come again at this forum who is working on some older oracle versions. It might save his time. I am really sorry if this information is of no worth

Regards
Re: ora-12540 TNS internal limit restriction exceeded [message #351982 is a reply to message #340990] Sat, 04 October 2008 08:00 Go to previous messageGo to next message
thomassaju
Messages: 1
Registered: April 2008
Junior Member
joy_division wrote on Fri, 15 August 2008 07:58
Please take a little time to look at the questions you are answering and notice that the last response was 3 years ago. This is the second message you have answered like this.


I am using Windows XP and when tried login like username@connect string, it worked.

Thanks.
Re: ora-12540 TNS internal limit restriction exceeded [message #351986 is a reply to message #351982] Sat, 04 October 2008 10:06 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
thomassaju wrote on Sat, 04 October 2008 15:00
joy_division wrote on Fri, 15 August 2008 07:58
Please take a little time to look at the questions you are answering and notice that the last response was 3 years ago. This is the second message you have answered like this.


I am using Windows XP and when tried login like username@connect string, it worked.

Thanks.

Good for you.

Regards
Michel

Previous Topic: database link is not working on 3rd party tools
Next Topic: Oracle Internet Directory and ODBC connections....
Goto Forum:
  


Current Time: Thu Dec 08 18:27:54 CST 2016

Total time taken to generate the page: 0.05840 seconds