PHP/Oracle Connectivity randomly "drops out"

Posted by user20555 on Server Fault See other posts from Server Fault or by user20555
Published on 2009-09-18T00:00:53Z Indexed on 2010/04/04 22:03 UTC
Read the original article Hit count: 141

Filed under:
|
|

Hi!

Here's the current situation - I have two web servers (for now named A and B) and two database servers (named C and D). The web servers are quite old, and are running an early version of Apache 2 + PHP4, while the DB servers are running Oracle 9i and 10g respectively. We're experiencing a strange problem connecting (via PHP code) to database A while on web server B only. Web server A has no issues at all... Randomly, web server B will report a "Not connected to Oracle" error (3114). I can't see a real pattern with this, but refreshing a few times seems to fix the issue. Apparently there are no drop-outs on the network interface, which leads me to believe that there's some misconfiguration between PHP/Apache and Oracle (which uses connection pooling). We're running SunOS 5.8...

Any ideas?

© Server Fault or respective owner

Related posts about apache

Related posts about php