ORA-12518, TNS:listener could not hand off client connection

The solution to this question is to increase the number of processes :

1. Open command prompt 
2. sqlplus / as sysdba; //login  sysdba user
3. startup force;
4. show parameter processes;  // This shows 150(some default) processes allocated, then increase the count to 800
5. alter system set processes=800 scope=spfile;

As Tried and tested.

Related Posts:

  1. Server Tomcat v8.0 Server at localhost failed to start. after declaring servlet name and mapping in web.xml file
  2. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  3. Unable to compile class for JSP
  4. java.lang.NumberFormatException: null i
  5. WebServlet cannot be resolved to a type
  6. The request sent by the client was syntactically incorrect.-Spring MVC + JDBC Template
  7. How to use if-else option in JSTL
  8. how to fix Cannot call sendRedirect() after the response has been committed?
  9. What is the difference between JSF, Servlet and JSP?
  10. How to loop over something a specified number of times in JSTL?
  11. org.apache.jasper.JasperException
  12. How can I view .JSP files
  13. How to specify the default error page in web.xml?
  14. how to fix oracle ORA-01722 invalid number error
  15. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  16. Spring Boot – Unable to resolve Whitelabel Error Page
  17. HTTP Status 405 – HTTP method is not supported by this URL
  18. What is Java Servlet?
  19. Image is not showing in browser?
  20. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  21. The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path
  22. The superclass “javax.servlet.http.HttpServlet” was not found on the Java Build Path
  23. What does request.getParameter return?
  24. How to request.getParameterNames into List of strings?
  25. SQL Error: ORA-00942 table or view does not exist
  26. Error ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired in oracle11g
  27. Session TimeOut in web.xml
  28. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
  29. java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
  30. What is WEB-INF used for in a Java EE web application?
  31. What is the difference between response.sendRedirect() and request.getRequestDispatcher().forward(request,response)
  32. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  33. How to solve javax.net.ssl.SSLHandshakeException Error?
  34. Uri not Absolute exception getting while calling Restful Webservice
  35. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  36. Oracle SQL query for Date format
  37. org.apache.jasper.JasperException: Unable to compile class for JSP:
  38. Error while trying to retrieve text for error ORA-01019
  39. Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
  40. IO Error: The Network Adapter could not establish the connection
  41. The import org.apache.commons cannot be resolved in eclipse juno
  42. Using if-else in JSP
  43. java.lang.IllegalStateException: Cannot (forward | sendRedirect | create session) after response has been committed
  44. How to solve the “failed to lazily initialize a collection of role” Hibernate exception
  45. HTTP Status 500 Error instantiating servlet class
  46. What does this expression language ${pageContext.request.contextPath} exactly do in JSP EL?
  47. An established connection was aborted by the software in your host machine tomcat jackson
  48. Convert timestamp to date in Oracle SQL
  49. Response has aready been committed
  50. How to display databases in Oracle 11g using SQL*Plus
  51. Hibernate dialect for Oracle Database 11g?
  52. Query to display all tablespaces in a database and datafiles
  53. what is the difference between doGet() and doPost() in term of the flow?
  54. Static Final Long serialVersionUID = 1L
  55. Download a file by jQuery.Ajax
  56. getOutputStream() has already been called for this response
  57. The import javax.servlet can’t be resolved 
  58. What is the meaning of ? (question mark) in a URL string?
  59. No Spring WebApplicationInitializer types detected on classpath

Leave a Comment