Oracle/PHP Issue

  • From: Byron Pearce <pearceb@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 15 Apr 2004 10:32:15 -0500

All:

We're having a situation with Oracle and PHP that I am hoping someone may have 
encountered and can provide some guidance on.  

We have an Oracle 8.1.6 database instance running on a RedHat 7.2 server.  The 
goal is to make a connection to this instance from the web server, which is 
running Red Hat Enterprise Server 3.0 and using the Oracle 9.2.0.4 client.  It 
is using Apache 2.0.46 and PHP 4.3.2 (oracle, oci8, curl, and dom modules).

The problem is that an ORA-12154 is returned intermittently by the scripts.  
Sometimes it works; sometimes it doesn't.  A simple PHP test script using the 
ora_logon and ora_logoff works fine, consistently and without fail.

However, if we add in some ora_parse, ora_open, ora_exec, and ora_close calls 
then we start getting the aforementioned errors.  Again, not all the time, just 
some of the time.  There is no pattern that we have been able to discern.

By their very nature, intermittent errors are very maddening.  If there are any 
PHP wizards who might have encountered this "feature" and know the problem, 
fix, workaround, hack, etc. and would be willing to share them would earn much 
gratitude.

Seriously, I appreciate any and all help anyone can provide.


-- 
====================================================================
Byron Pearce                         mailto:pearceb@xxxxxxxxxx
Tenure Systems, Inc.                 Dallas/Fort Worth, TX

"It's hard to be a ninja when you wear a beeper."



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: