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

[www.douglassdavis.com]

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 "establishe d" 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.

[Mladen Gogala]

Re: Apache/PHP/Oracle XE TNS:listener could not find availablehandle r

On Mon, 17 Mar 2008 08:47:21 -0700, bdbafh wrote:

If an spfile is in fact in use, type:
>
SQLalter system set processes=150 scope=spfile;

Wow! He's using Winduhs XP as a server! This is a DBA solution to the
sloppy Apache configuration.

--
Mladen Gogala

http://mgogala.freehostia.com