Oracle Error 12540
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog ora-12540 windows
ORA-12540: TNS:Tns-01159
Internal Limit Restriction Exceeded Tips Oracle Error Tips by Stephanie F. Question: The basic error we're getting is ORA-12540 when we're trying to allocate sessions on a Redhat Linux 7.1 server running Oracle 8.1.7.4. Here is some example output of the DB error our program is catching: Error while trying to retrieve text for error ORA-12540 We have tried raising the kernel limits as follows: kernel.shmmax = 400000000 kernel.shmall = 400000000 kernel.shmseg = 32 kernel.sem = 10000 32000 100 100 We have tried configuring the Oracle DB in dedicated and MTS modes and it doesn't seem to make a lot of difference. What seems to happen is when the Oracle DB is running in Dedicated mode, it starts allocated new processes to handle the connections and then we seem to get to about 512 processes across the system and then we see the failure. We have tried altering the number of processes, as above, but it doesn't seem to make a lot of difference and we still get ORA-12540. So what we need to understand is what is causing the error and how we can fix it. Answer: Using the oerr utility to look up the ORA-12540 error yields the following: ORA-12540: TNS:internal limit restriction exceeded Cause: Too many TNS connections open simultaneously. Action: Wait for connections to close and re-try. This error is not an indication of a network problem unless it occurs on all connections (in other words you have never been able to connect). If so it is a .ora configuration problem. If you can make connections up to a certain point but then fails it is an indication of a resource limitation at the os level (this sounds like your scenario). Typical problems are: Out of system memory / swap Out of process slots in the process table Streams resources depleted Physical conne
TNS:internal limit restriction exceeded If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: TNS-12540: TNS:internal limit restriction exceeded Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-24-2002,01:16 PM #1 vijay8282 View Profile View Forum Posts Senior Member Join Date May 2001 Location Delhi Posts 340 RDBMS Version:: http://www.dba-oracle.com/t_ora_12540_tns_internal_limit_restriction_exceeded.htm Oracle 8161 Operating System and Version:: WinNT 4.0 EE Error Number (if applicable):: TNS-12540 Hi, I have configured my oracle backups thru Legato. Yesterday while taking Online backup, I got the subject error. Detail of error from sqlnet.log is as below : VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.6.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production Time: 23-APR-2002 21:20:42 Tracing not turned on. Tns error http://www.dbasupport.com/forums/showthread.php?24027-TNS-12540-TNS-internal-limit-restriction-exceeded struct: nr err code: 0 ns main err code: 12540 TNS-12540: TNS:internal limit restriction exceeded ns secondary err code: 12560 nt main err code: 510 TNS-00510: Internal limit restriction exceeded nt secondary err code: 8 nt OS err code: 0 init.ora parameter processes = 160. sessions = 190 Please advise. Regards Vijay -------------------------- The Time has come .... Reply With Quote 04-24-2002,02:18 PM #2 Shestakov View Profile View Forum Posts Senior Advisor Join Date Sep 2001 Location NJ, USA Posts 1,287 U got problem with # of open file descriptors per 1 application (process). Probably this is internal OS (NT) problem with size of the table of file descriptors. I know, how i can solve this situation in unix, but not in NT. Reply With Quote 04-24-2002,02:23 PM #3 sanjay92 View Profile View Forum Posts Visit Homepage Junior Member Join Date Aug 2001 Posts 75 The error implies that you have hit a limit of some form. This is usually an OS limit that has been reached. Typical problems are: - Out of system memory / swap - Out of process slots in the process table - Streams resources depleted - Out of File Handles Here is info from Oracle :- Problem Description ------------------- You are receiving an ora TNS-12540 error intermitently when trying to make connec
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board oracle error PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle oracle error 12540 Error: ORA-12540 Error Description: TNS:internal limit restriction exceeded Error Cause: Too many TNS connections open simultaneously. Action: Wait for connections to close and re-try. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 68 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
internal limit restriction exceeded [message #123553] Mon, 13 June 2005 23:01 srtor Messages: 3Registered: 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 Report message to a moderator Re: ora-12540 TNS internal limit restriction exceeded [message #123590 is a reply to message #123553] Tue, 14 June 2005 01:39 girish.rohini Messages: 744Registered: 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 Report message to a moderator Re: ora-12540 TNS internal limit restriction exceeded [message #340938 is a reply to message #123590] Fri, 15 August 2008 01:37 catalyst Messages: 3Registered: 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 e