{"id":2077,"date":"2012-03-28T12:04:15","date_gmt":"2012-03-28T17:04:15","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=2077"},"modified":"2012-04-20T10:26:45","modified_gmt":"2012-04-20T15:26:45","slug":"ora-12516-possible-causes","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2012\/03\/28\/ora-12516-possible-causes\/","title":{"rendered":"ORA-12516 &#8211; Possible causes"},"content":{"rendered":"<p>At least one is when your processes parameter in the database instance(s) has\/have been exceeded.<\/p>\n<pre lang=\"text\">\r\njava.sql.SQLException: Listener refused the connection with the following error:\r\nORA-12516, TNS:listener could not find available handler with matching protocol stack\r\n\r\n        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:451)\r\n        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:535)\r\n        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:218)\r\n        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)\r\n        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)\r\n        at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:401)\r\n        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:288)\r\n        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:205)\r\n        at stressRetail.run(stressRetail.java:82)\r\n        at java.lang.Thread.run(Unknown Source)\r\nCaused by: oracle.net.ns.NetException: Listener refused the connection with the following error:\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>At least one is when your processes parameter in the database instance(s) has\/have been exceeded. 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:451) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:535) at&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2012\/03\/28\/ora-12516-possible-causes\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2077"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=2077"}],"version-history":[{"count":7,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2077\/revisions"}],"predecessor-version":[{"id":2177,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2077\/revisions\/2177"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2077"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}