Apache/PHP/Oracle XE TNS:listener could not find available handler

Question posted by: www.douglassdavis.com (Guest) on March 17th, 2008 12:15 AM

I have an Apache server, PHP 5.2.5 and Oracle 10g Express Edition for
development purposes on my laptop running Windows XP.

I am using OCI to connect to Oracle from PHP

I am using MDB2 database abstraction library.


Occasionally when I load a page I will get this error:
ORA-12520: TNS:listener could not find available handler for requested
type of server
MDB2 Error: connect failed

When I try to connect from Oracle SQL developer:
ORA-12519: TNS: no appropriate service handler found

When I run lsnrctl services:

Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:85 refused:0 state:blocked
LOCAL SERVER

It appears that the "established" number is not going down, only going
up.

Does this mean that it is not dropping the connection once the page is
finished loading? How can this be fixed?

Thanks.

Not the answer you were looking for? Post your question . . .
189,939 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).