Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

The snapshot seems to have cleared the segfaults, nevertheless the weird oracle error messages remain. Is there a way to debug the OCI(P)Logon and compare it with the data the working server is sending?

Have you set all the necessary environment variables correctly when you start apache?

environment of the defunct server (from phpinfo())

NLS_LANG  german_germany.WE8DEC  
LD_LIBRARY_PATH  /opt/oracle/product/9.2.0/lib:/lib:/usr/lib:/opt/apache2/lib::/usr/local/lib  
ORACLE_SID  tsid  
ORACLE_BASE  /opt/oracle  
PATH  /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/opt/oracle/product/9.2.0/bin  
PWD  /  
LANG  en_US.UTF-8  
ORACLE_TERM  xterm  
SHLVL  1  
ORA_NLS33  /opt/oracle/product/9.2.0/ocommon/nls/admin/data  
ORACLE_HOME  /opt/oracle/product/9.2.0  
_  /sbin/initlog  

and the environment of the working server:

PWD /home 
ORACLE_SID TSID 
LD_LIBRARY_PATH /opt/oracle/product/9.0.1/lib:/lib:/usr/lib:/usr/local/lib 
CLASSPATH /opt/oracle/product/9.0.1/JRE:/opt/oracle/product/9.0.1/jlib:/opt/oracle/product/9.0.1/rdbms/jlib:/opt/oracle/product/9.0.1/network/jlib 
LANG en_US 
ORACLE_BASE /opt/oracle 
ORACLE_HOME /opt/oracle/product/9.0.1 
ORACLE_TERM 386 
SHLVL 3 
ORA_NLS33 /opt/oracle/product/9.0.1/ocommon/nls/admin/data 
PATH /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin 
NLS_LANG german_germany.WE8DEC 
_ /sbin/initlog 

if i log into the webserver user on the non-functioning host i can access the oracle db with sql*plus just fine.

With what script and what errors do you get..?

Warning: ociplogon(): OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00911: invalid character in /home/httpd/index.php3 on line 3

or

Warning: ocilogon(): OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00922: missing or invalid option in /home/httpd/index.php3 on line 3

'Line 3' is simply the OCILogon or OCIPLogon as follows:

$ohnd = OCILogon("dvd","hidden","tns.domain");

Try a script which has ONLY that one line.
And you're sure your username/password doesn't contain any illegal chars? And your db name is tns.domain ??

the SAME script on the SAME machine works with the 9.0.1 client libs I copied over from the other machine. Only the 9.2.0 client libs (using the SAME script, the SAME php, the SAME apache and the SAME configure line) do not work.

Then use those. Wild guess: The SAME environment vars don't work with DIFFERENT oracle version..

Okay, once again, slowly.
- installed a fresh oracle 9.2.0
- installed a fresh apache with PHP and linked against oracle 
- does NOT work
- copied over the entire /opt/oracle/product/9.0.1 tree from another machine where the libs work
- installed a fresh apache with PHP linked against those other libs
- CHANGED the environment vars so the 9.0.1 libs are used instead of the 9.2.0 libs
- now it works - NO thanks to wild guesses from the bugs team.

i have installed a couple of working oci/php combos so far, the 9.2.0 is the first one where i ran into these kind of problems. And you can't earnestly expect new users to fiddle with libs for 2 weeks till their oci bindings start to work... 

If you like, you can have an account on the box in question and have a look around yourself. However i am NOT satisfied with the answer 'okay, you made a crude hack, and by chance it worked, now use it and stop bugging us'

Try adding "ociinternaldebug(1);" in the beginning of your script. That'll make the functions to print out some extra debugging information.

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.

Hi

I am having a similar issue to the person below here is what the screen prints out when I ad the ociinternaldebug(1); to the top of the file.

Warning: ocilogon() [function.ocilogon]: OCISessionBegin: ORA-00604: error occurred at recursive SQL level 1 ORA-00911: invalid character in /Scripts/WEB/test.php on line 3
OCIDebug: _oci_open_session: FAILURE -> CLEANUP called
OCIDebug: START _oci_close_session: logging-off sess=0
OCIDebug: _oci_close_session: logging-off DEAD session
OCIDebug: oci_do_connect: FAILURE -> CLEANUP called
OCIDebug: START _oci_conn_list_dtor: id=0
OCIDebug: END _oci_conn_list_dtor: id=0
Oracle Connect Error OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci


I have tried compiling with both php versions PHP 5.0 Beta 4  and PHP 4.3.4

Here is what is loaded into my profile.

ORACLE_BASE=/u01/oracle
export ORACLE_BASE
ORACLE_HOME=/u01/oracle/product/9.2
export ORACLE_HOME
ORACLE_SID=PIERCEG
export ORACLE_SID
PATH=$PATH:$HOME/bin:/u01/oracle/product/9.2/bin
export PATH
USERNAME=""
export USERNAME
CLASSPATH=:.:/u01/oracle/product/9.2/jdbc/lib/classes111.zip
export CLASSPATH
LD_LIBRARY_PATH=/u01/oracle/product/9.2/lib
export LD_LIBRARY_PATH
ORA_NLS33=/u01/oracle/product/9.2/ocommon/nls/admin/data
export ORA_NLS3
NLS_LANG="ENGLISH_UNITED KINGDOM.WE8MSWIN1252"
export NLS_LANG
NLS_DATE_FORMAT="RRRR-MM-DD HH24:MI:SS"
export NLS_DATE_FORMAT
PATH=$PATH:/usr/local/jre/bin
export PATH
LD_ASSUME_KERNEL=2.4.1
export LD_ASSUME_KERNEL


Here is the configuration info

'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-oci8' '--enable-track-vars' '--enable-ftp' '--enable-sigchild' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-freetype-dir=/usr/local/freetype' '--with-jpeg-dir=/usr/lib/' '--with-zlib' '--with-png-dir=/usr/lib/' '--with-xpm-dir=/usr/X11R6' '--with-ldap' '--enable-exif' '--with-png' '--without-tsrm-pthreads' '--enable-inline-optimization' '--with-tiff=/usr/lib/'

From phpinfo

oci8
OCI8 Support 	enabled
Revision 	$Revision: 1.248 $
Active Persistent Links 	0
Active Links 	-3
Oracle Version 	9.2
Compile-time ORACLE_HOME 	/u01/oracle/product/9.2
Libraries Used 	no value
Temporary Lob support 	enabled
Collections support 	enabled

Hi sorry ment to add the script as well 

I have also tested connecting from sqlplus which i can do.
<?php
        ociinternaldebug(1);
        if (OCILogon("<username>", "<password>", "pierceg"))
        {
           echo "Successfully connected to Oracle.\n";
        }

        else
        {
           echo "Oracle Connect Error ";
        }

?>

Hi

Don't know why but by removing the following variable from my profile I managed to get it to work.

NLS_LANG="ENGLISH_UNITED KINGDOM.WE8MSWIN1252"
export NLS_LANG

Hope this helps

I would be very thankful, if you try it without this fix, but with latest PHP5 snapshot.
BTW, Apache2 is NOT recommended for use in production, so if you want it to be stable, you need to use Apache 1.3.x.

I have this problem to:
I install Oracle 9.2.0, PHP 5.0.1 o(also I try PHP 4.3.8), apache 2.0.50 and get an error when connect to my database with NLS_LANG another, than AMERICAN.
My configure command is:
Configure Command './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--without-mysql'   '--with-pgsql' '--with-oci8=/opt/oracle/product/9.2.0'
'--with-oracle=/opt/oracle/product/9.2.0' '--with-zlib'
 '--enable-sigchild'
My PHPinfo said:
oci8

   OCI8 Support             enabled
   Revision                 $Revision: 1.257 $
   Active Persistent Links  0
   Active Links             0
   Oracle Version           9.2
   Compile-time ORACLE_HOME /opt/oracle/product/9.2.0
   Libraries Used           no value
   Temporary Lob support    enabled
   Collections support      enabled

oracle

   Oracle Support           enabled
   Oracle Version           9.0
   Compile-time ORACLE_HOME /opt/oracle/product/9.2.0
   Libraries Used           no value

I set NLS_LANG=RUSSIAN.CL8KOI8R
Error is
   OCIDebug: _oci_open_server new conn=0 dname=xxx
   Warning:         oci_new_connect()         [function.oci-new-connect]:
   OCISessionBegin:  ORA-00604:  error  occurred at recursive SQL level 1
   ORA-00911: invalid character in /home/www/test.php on line 21
   OCIDebug: _oci_open_session: FAILURE -> CLEANUP called

When I set NLS_LANG=AMERICAN , connect work and my query return data. But I need  NLS_LANG=RUSSIAN.CL8KOI8R
 for my Russian symbols. 
Also, oracle (not oci8) functions in PHP work and get me a data with my language.
Please, help to me.

Right now I had the same error on an older php installation: apache 1.3.31, php 4.3.8, oracle 9.2 (suse linux 9.3). The problem seems to come up when glibc and oracle nls environment variables are not consistent. The original bug report mentions

LANG=en_US.UTF-8
NLS_LANG=german_germany.WE8DEC

in the non working installation whereas it is

LANG=en_US
NLS_LANG=german_germany.WE8DEC

in the working installation. For me it was

unset LANG
LC_CTYPE=de_DE.UTF-8
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1

in the non working case. When unsetting LC_CTYPE everything is ok. Newer suse linux distributions (others too) in general have utf-8 environment variables set. In my case it looks like LC_CTYPE was added in suse 9.3. It seems that system and oracle nls environments simply have to be consistent, for example:

LANG=de_DE.UTF-8
NLS_LANG=GERMAN_GERMANY.UTF8

works without a problem.

Thank you for your bug report. This issue has already been fixed
in the latest released version of PHP, which you can download at 
http://www.php.net/downloads.php