Error Ora 12540
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-01159: internal connection limit has been reached; listener has shut down TNS: 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 resouTNS: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 http://www.dba-oracle.com/t_ora_12540_tns_internal_limit_restriction_exceeded.htm 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:: 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 http://www.dbasupport.com/forums/showthread.php?24027-TNS-12540-TNS-internal-limit-restriction-exceeded 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 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 7
Library mySQL Code Library PHP Code Library JavaScript http://www.freelists.org/post/oracle-l/ORA12540-TNSinternal-limit-restriction-exceeded,1 Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board error ora 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 error ora 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 182 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
4 Feb 2004 17:37:16 -0500 You've hit the number of concurrently open TCP connections on the box. You may try cman and connection pooling, but it would involve restarting the database and setting "POOL" parameter for the dispatchers. The machine itself doesn't need to be restarted. On 02/04/2004 05:23:42 PM, Jordi Adame V wrote: > When running a Pro*C application (64 bits) i get this error: > > ORA-12540: TNS:internal limit restriction exceeded > > My system: > HP-UX B.11.11 > Oracle 9.2.0.1.0 > > is there any way to solve this without changing kernel parameters? > > regards, > > Jordi > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- Follow-Ups: Re: ORA-12540: TNS:internal limit restriction exceededFrom: Paul Drake Re: ORA-12540: TNS:internal limit restriction exceededFrom: Jordi Adame V References: ORA-12540: TNS:internal limit restriction exceededFrom: Jordi Adame V Other related posts:» ORA-12540: TNS:internal limit restriction exceeded » Re: ORA-12540: TNS:internal limit restriction exceeded » Re: ORA-12540: TNS:internal limit restriction exceeded » Re: ORA-12540: TNS:internal limit restriction exceeded Home oracle-l Archive 02-2004 » Previous by Date» Next by Date » Related Pos