PHP/Oracle connection issues

[theknight571]

I have an application written in HTML/PHP with some Javascript thrown in here and there.

One part of the application connects to an Oracle database to get some data.

Several times a day (at random) we are unable to connect to the Oracle database. The only "fix" for this is to restart Apache.

This used to happen only once every other week or so, but recently we're having to restart Apache several times a day.

Nothing has changed on my end.

However, on the Oracle database end I believe they changed servers as they have a new IP address.

The code from my test page is attached. (I've tried it with the DNS name as well as just using the IP address of the server.)

Any suggestions as to what might be causing us to have to restart Apache in order to connect to the Oracle DB?

Setup:

My server:
- MS Windows Server 2003
- Apache
- MySQL
- PHP

Their server:
- Unknown setup
- Oracle Database

Thanks in advance.

 

[sourceninja]

Too many oracle connections hanging out there. Are you sure you are closing them all properly? Maybe some long running scripts keeping the connections open?

That would be my first thought.