Connection Was Refused With Error Ora-12518
Contents |
connection Posted by Anil Kumar on June 29, 2013 All Posts, Database, Oracle DBA 2 Comments Fixed ORA-12518: TNS:listener could ora-12518 solution not hand off client connection 1 (20%) 1 vote You try listener refused the connection with the following error ora 12518 to connect with Oracle database and get Ora-12518 listener could not hand off client connection error. ora 12518 sql developer Now what action is to be taken to get rid of above error? Follow below steps to resolve the issue. Connect with oracle database: C:\>sqlplus / as
Listener Could Not Hand Off Client Connection Sqlplus
sysdba SQL>conn testuser/test@mydb And you got the ERROR: ORA-12518: TNS: listener could not hand off client connection Solution-1: First check your database whether it is in start mode or not. SQL> shutdown immediate; SQL> Startup; Solution-2: If first is not working You have to increase PROCESSES initialization parameter in Oracle database. First use the following tns-00534: failed to grant connection ownership to child command to check the existing value of the PROCESSES. show parameter processes As we have already started our database normally or using spfile, then run following command to alter system processes to 450. alter system set processes=450 scope=spfile; If you have started your database using pfile, process parameter must be set in pfile. Solution-3: If both the above solutions are not working. If you are getting ORA-12518 because of a shared server issue then you first need to use the below command to shutdown the dispatcher. SQL> alter system shutdown immediate 'D001'; Then add on new dispatchers. SQL> alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=3)'; Resolving ORA-12518 requires you to evaluate the syntax depending on your dispatcher value in the Spfile.ora or init.ora files. When you increase DISPATCERS to resolve ORA-12518 you should also keep an eye on the shared server ratio. Resolved ORA-12541: TNS no listener error ORA-28001: The Password Has Expired I hope you have successfully resolved your Ora-12518 issue. Get Fr
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please tns-12518 tns-12547 tns-12560 tns-00517 type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral
Logging_listener_name=on
Database Discussions This discussion is archived 14 Replies Latest reply on Jan 27, 2010 7:32 PM by 749543 ORA-12518 Tns: Listener
Ibm/aix Risc System/6000 Error: 32: Broken Pipe
could not hand off client conenction 505459 May 31, 2007 9:02 AM Dear exeprts, Plz tell me how can I resolve ORA-12518 Tns: Listener could not hand off client conenction. 166579Views Tags: none (add) This http://itbloggertips.com/2013/06/fixed-ora-12518-tnslistener-could-not-hand-off-client-connection/ content has been marked as final. Show 14 replies 1. Re: ORA-12518 Tns: Listener could not hand off client conenction 167351 May 31, 2007 9:34 AM (in response to 505459) Hi! In most cases it's a network problem. On HP-UX it can be a bug. What version of Oracle are you using and what platform? Regards, PP Like Show 0 Likes(0) Actions 2. Re: ORA-12518 Tns: Listener could not hand off https://community.oracle.com/thread/516403 client conenction 505459 May 31, 2007 9:47 AM (in response to 167351) Dear PP, I am using Oracle 10g XE on Windows Platform Thanks Like Show 0 Likes(0) Actions 3. Re: ORA-12518 Tns: Listener could not hand off client conenction 167351 May 31, 2007 9:53 AM (in response to 505459) Check your EventLog for errors regarding network connections and check the alert log of your database. You can also get this error when your database crashed. Regards, PP Like Show 0 Likes(0) Actions 4. Re: ORA-12518 Tns: Listener could not hand off client conenction 551261 May 31, 2007 10:59 AM (in response to 167351) Hi, Check the status of oracle service in windows services. start--->run--->services.msc there u can find the service by name OracleInstancename. Thanks, Kumar. Like Show 0 Likes(0) Actions 5. Re: ORA-12518 Tns: Listener could not hand off client conenction Madrid May 31, 2007 5:38 PM (in response to 505459) ORA-12518: TNS:listener could not hand off client connection Your server is probably running out of memory and need to swap memory to disk. One cause can be an Oracle process consuming too much memory. A possible workaround is to set following parameter in the listener.ora and restart the listener: DIRECT_HANDOFF_TTC_LISTENER=OFF You might need to increase the value of la
log in tour help Tour Start here for http://dba.stackexchange.com/questions/110819/oracle-intermittently-throws-ora-12516-tnslistener-could-not-find-available-h a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or error ora posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. connection was refused Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle intermittently throws “ORA-12516, TNS:listener could not find available handler with matching protocol stack” up vote 2 down vote favorite 3 While testing the Oracle XE connection establishing mechanism I bumped into the following issue. Although connections are closed on each iteration, after 50-100 connections Oracle starts throwing intermittently the following exception: java.sql.SQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489) ~[ojdbc6-11.2.0.4.jar:11.2.0.4.0] at oracle.jdbc.driver.PhysicalConnection.