Fixing the ORA-12519: TNS:no appropriate service handler found error

Ken Ng

Father. Technologist. Photographer. Blogger. Shares his thoughts on the everything technology that amuses him on a anytime he can while regularly abuses his Mac, iPhone and iPad. Devices with APS-C CMOS sensors seems to be a favourite passtime and his job involves selling mules to connect stuff.

You may also like...

55 Responses

  1. Christian says:

    This was great. I will be sure to link to this on an post I writing today on using Oracle BI Apps with an Oracle XE database. Upon my attempt, I bumped into the same issue as you did. Ultimately I bumped into another issue that was and impassible restriction of Oracle XE and had to chuck the idea. But good post by you none the less.

  2. Thanks for the good article. It helped a lot. I wrote an blog entry in german myself and referenced to your one.

  3. Ken Ng says:

    Thanks for the linkback! Glad I helped in my little way.

  4. thaaaaaaaaaaaanks! It helped me a lot.
    I solved 2 minutes before a Demo.

    Thanks again men!


  5. Ken Ng says:

    Glad I was able to help ๐Ÿ˜€ That’s why I posted the blog post in the first place!

  6. Sameer says:

    Thanks a lot. it worked for me

  7. mihai says:

    I spent three days trying to resolve this problem, but after that, in a morning after drinking a beer, I found this article and it resolved the problem. Thanks, great work.

  8. Yenny says:

    Tried but couldn’t get it to work. Or at least not as I want. Still with the value setted to 150, after 45 concurrent calls it throws the exception. =(

  9. ..tia.. says:

    Thanks a lot! anybody else that hates Oracle docs/error descriptions?

  10. Anonymous says:

    LOL. Ditto!

  11. Onetwo says:

    Fixed my issue! thanks a million!

  12. Anonymous says:

    Glad my post was helpful ๐Ÿ™‚

  13. Santoshkosgi says:

    thanks a lot…..i was tryin to figure out this since a month but couldn’t…… was very useful post for me

  14. Apalop says:

    Thanks a lot!!! 2 days creating a deleting weblogic domains thinking it was a WLP problem

  15. Suhas Phanasalkar says:

    Thank you so much! This is really helpful.

  16. Jon Perry says:

    Thanks so much. A lot of time and effort saved by reading this.

  17. Andyj748 says:

    Excellent help. Thanks.

  18. Robin says:

    Super duper! Was fighting with same issue for some time today…

  19. Anonymous says:

    Glad I’m able to help ๐Ÿ™‚

  20. carlossc says:

    Thanks a lot.

  21. Kevin says:

    Thank you.ย  This fixed my problem.

  22. Perlcat says:

    I think it was the beer that did it.

  23. ratnakar srivastava says:

    Thanks a lot this doc is really awesome

  24. Guest says:

    I was analyzing for hours. This article was the solution for my problem. Thanks a lot.

  25. Esso6919 says:

    thank you — muchas gracias !

  26. Matejbor says:

    Thank you for the idea but I cannot agree that this is the solution. It is merely a bypass. There was the same option in Snow Leopard and I didn’t want to use it as I didn’t want my computer waking up with the lid down. But still after sleep I got a connection with my mouse every time. This obviously remains a bug.

  27. Ken Rach says:

    Thanks… good explanation!

  28. Ajinkya says:

    You are life saver ๐Ÿ™‚

  29. umesh says:

    Its great man!

  30. Din says:

    Thanks much. Helped a lot.

  31. Yanko says:

    Thanks buddy! This helped me a lot!

  32. rose says:

    thanks a lot!your advice is probably the most useful i’ve found

  33. Dinakar says:

    thanks a lot friend!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  34. Amgad Gorgui, says:

    Thank you, i kept searching for days, why my insert is getting such an error.

  35. Jaime says:

    Worked for me. The message was really misleading. Thank you.

  36. Saurabh says:

    Awesome Man ๐Ÿ™‚ Saved a lot of time which I would have further wasted.

  37. dede says:

    i was try this command, but can’t resolving this problem
    after execute this command, i get this message

    SQL> alter system set processes=150 scope=spfile;
    alter system set processes=150 scope=spfile
    ERROR at line 1:
    ORA-32001: write to SPFILE requested but no SPFILE is in use

  38. Ken Ng says:

    Try the following set of commands to fix that.

    create spfile from pfile;
    shutdown immediate;
    show parameter spfile;

  39. felix says:


  40. vikas says:

    Thanks a lot….I was facing this stupid issue while running my kettle transformation.

  41. abuzuhair says:

    Great solution, thanks

  42. great tip dude!!! thanks a lot!!!

  43. JJ says:

    Many thanks it’s working. I keep my hairs.
    For non DBA people after command on spfile do:
    shut immediate

  44. tumbgur says:

    thank you very much! It worked for me too!

  45. Jean Levy says:

    Thanks my friend!!

  46. sikharis says:

    very usefull for my problem, thanks ๐Ÿ™‚

  47. RikArdo Villarruel says:

    Thnx man!! finally, a useful post without turkish bla bla bla and straight to the point.

  48. Shubhashish says:

    Thanks It’s work like a charm . Prior reading this article I started believing that there must be some glitch in my code. Thanks again.

  49. Chandrasekhar says:

    It didn’t work for me. Can you give me reset command for above and let me know any other solution for it

  50. Ken Ng says:

    Chandrasekhar: The command above only increases the number of processes the Oracle DB XE can run concurrently. So its actually good to have that increased even if this didn’t solve your problem.

  1. October 6, 2011

    […] […]

  2. June 29, 2012

    […] on Google revealed that it was most likely due to Oracle reaching its maximum number of processes. Most posts tended to just suggest increasing the number of processes without covering why you might suddenly running out or processes. As this had only just started […]

  3. June 16, 2013

    […] on Google revealed that it was most likely due to Oracle reaching its maximum number of processes. Most posts tended to just suggest increasing the number of processes without covering why you might suddenly running out or processes. As this had only just started […]

Let me know what you think...