{"id":30,"date":"2008-10-09T11:41:14","date_gmt":"2008-10-09T15:41:14","guid":{"rendered":"http:\/\/dbtricks.com\/?p=30"},"modified":"2008-10-09T11:41:14","modified_gmt":"2008-10-09T15:41:14","slug":"simple-solution-to-ora-12520-on-oracle-xe","status":"publish","type":"post","link":"https:\/\/dbtricks.com\/?p=30","title":{"rendered":"Simple Solution to ORA-12520 on Oracle XE"},"content":{"rendered":"<p>If you get the following error on Oracle XE:<\/p>\n<p>ORA-12520: TNS:listener could not find available handler for requested type of server<\/p>\n<p>This is probably because the value for the processes parameter is too low.<\/p>\n<p>For some reason, Oracle set the default value of the processes parameter on Oracle XE\u00a0 to 40. If your application opens many process or\u00a0 several queries are executed at the same time, the ORA-12520 could be displayed.<\/p>\n<p>The solution for this issue is simple.\u00a0 All you need to do is give the processes parameter an higher value.<\/p>\n<p>open sql plus (All Programs -&gt; Oracle Database 10g Express Edition -&gt; Run SQL Command Line) and run the following command:<br \/>\n<strong>Alter system set processes=100 scope=spfile;<\/strong><\/p>\n<p>Restart the DB:<br \/>\n<strong>shutdown immediate<br \/>\nStartup<\/strong><\/p>\n<p>if needed, an higher number can be provided.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you get the following error on Oracle XE: ORA-12520: TNS:listener could not find available handler for requested type of server This is probably because the value for the processes parameter is too low. For some reason, Oracle set the default value of the processes parameter on Oracle XE\u00a0 to 40. If your application opens [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[16,107,15,17,11],"class_list":["post-30","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-ora-12520","tag-oracle","tag-oracle-xe","tag-processes","tag-xe"],"_links":{"self":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=30"}],"version-history":[{"count":1,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/30\/revisions"}],"predecessor-version":[{"id":31,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/30\/revisions\/31"}],"wp:attachment":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}