Re: [PHP-DB] Oracle 9 and PHP 4.3.x
Don't use setenv. Set the variables in apache init script. This should fix the problem. Good luck. Alberto. On Wed, 22 Oct 2003, Johan Kruger-Haglert wrote: > On Wed, Oct 22, 2003 at 10:44:36PM +1000, Christopher Jones wrote: > > What errors does PHP give you? > > ORA-03117: two-task save area overflow > ORA-12154: TNS:could not resolve service name > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle 9 and PHP 4.3.x
On Wed, Oct 22, 2003 at 10:44:36PM +1000, Christopher Jones wrote: > What errors does PHP give you? ORA-03117: two-task save area overflow ORA-12154: TNS:could not resolve service name among others, it seems to variate a little. I've tried with different configuration settings during the tests. > >I've set env values in httpd.conf together with the mod_env module > >without any success, probably because there are no oracle 9 support. > > A common issue seems to be not setting ORACLE_HOME and ORACLE_SID in the > shell that starts Apache. Try setting these (and any other NLS_*, TWO_TASK > etc. variables) before starting Apache. In the end of my httpd.conf i have: SetEnv ORACLE_BASE /opt/ora9 SetEnv LD_ASSUME_KERNEL 2.4.1 SetEnv THREADS_FLAG native SetEnv ORACLE_HOME /opt/ora9/product/9.2 SetEnv LD_LIBRARY_PATH /opt/ora9/product/9.2/lib SetEnv TNS_ADMIN /opt/ora9/product/9.2/network/admin SetEnv ORACLE_SID netadmdb SetEnv NLS_LANG Swedish I also have mod_env and all those environment variables shows up in the page phpinfo() generates. The oracle_sid is given as argument to the function which tries to open the datbase connection in the PHP script. But i've tried to add it as both oracle_sid and two_task. > http://otn.oracle.com/tech/opensource/php/apache/inst_php_apache_linux.html > help? Looks like it could help, I'll read it thru. Maybe i should try to use apache 1.3.x instead of 2.0.x aswell. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle 9 and PHP 4.3.x
Johan Kruger-Haglert wrote: I've been trying to get Linux+apache+php+oracle working here with no success, so I've to ask for some help. Versions: RedHat 9.0 PHP 4.3.4RC1 Oracle Enterprise Server 9.2.x Oracle client 8.1.7 The machine has to run RedHat, and newest version would be good. Oracle9.x doesn't seem to be certified for RedHat9 but I've found guides on how to get it running and it works. PHP is compiled with --with-oci8 against the Oracle9.x server, the compilation works but PHP does not. What errors does PHP give you? I've set env values in httpd.conf together with the mod_env module without any success, probably because there are no oracle 9 support. A common issue seems to be not setting ORACLE_HOME and ORACLE_SID in the shell that starts Apache. Try setting these (and any other NLS_*, TWO_TASK etc. variables) before starting Apache. Any help to either get PHP using Oracle9 or installing Oracle8 on RedHat9 would be appreciated. It would be good if any answers where cced/sent directly to my e-mail address. Does any info in http://otn.oracle.com/tech/opensource/php/apache/inst_php_apache_linux.html help? Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle 9 and PHP 4.3.x
I've been trying to get Linux+apache+php+oracle working here with no success, so I've to ask for some help. Versions: RedHat 9.0 PHP 4.3.4RC1 Oracle Enterprise Server 9.2.x Oracle client 8.1.7 The machine has to run RedHat, and newest version would be good. Oracle9.x doesn't seem to be certified for RedHat9 but I've found guides on how to get it running and it works. PHP is compiled with --with-oci8 against the Oracle9.x server, the compilation works but PHP does not. I've set env values in httpd.conf together with the mod_env module without any success, probably because there are no oracle 9 support. I've read that you can use the Oracle 8.x client against a 9.x database and compile PHP against that client instead, but the installation just hangs with a gray window and 100% CPU usage. I've read that it could help to change window manager to fvwm but no success. Any help to either get PHP using Oracle9 or installing Oracle8 on RedHat9 would be appreciated. It would be good if any answers where cced/sent directly to my e-mail address. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php