Re: php, oci8 and oracle

Hi I use Debian testing with ORACLE INSTANT CLIENT and OCI8 without any problem ... Any how, I think apache run as www-data so if you export the variables as root only root will see them (I think). I think there is a way to export a variable directly within apache configuration files so you do not need to write a script. Using OIC I only need to export LD_LIBRARY_PATH to the OIC path because I do not even need tnsnames.ora . sirakov escribió:

Hi, I have a problem with oci8. I installed ORACLE Enterprise with php5 and apache, with this script : <?php phpinfo(); ?> I receive information for the set modules. I see that oci8 is enabled however ORACLE_HOME is empty. Additionally, I tried to write a little script which I run as a root. Due to this script, I set variables and start apache: cmd=which apache2ctl $cmd stop ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1;export ORACLE_HOME echo ORACLE_HOME: $ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID echo ORACLE_SID: $ORACLE_SID ORATAB=/etc/oratab; export ORATAB echo ORATAB: $ORATAB ORACLE_HOME_LISTNER=$ORACLE_BASE, export ORACLE_HOME_LISTNER echo ORACLE_HOME_LISTNER: $ORACLE_HOME_LISTNER ORACLE_BASE=$ORACLE_HOME; export ORACLE_BASE echo ORACLE_BASE: $ORACLE_BASE NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15; export NLS_LANG echo NLS_LANG: $NLS_LANG LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH echo LD_LIBRARY_PATH: $LD_LIBRARY_PATH LD_PRELOAD=/u01/app/oracle/oracle/product/10.2.0/db_1/lib/libclntsh.so echo LD_PRELOAD:$LD_PRELOAD $cmd start In /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini I set the extension=oci8.sо, but ORACLE_HOME is still empty (see here http://www.picvalley.net/u/9/8466_726.PNG) If someone has an idea how to solve the problem, I will highly appreciate any advices with this regard. I read about an installation of ORACLE Instant client and oci8 but I do not know whether I need this instant client at all, because I use Oracle Enterprise. PS. i'm sorry for the bad english, i can't explain the problem better.

-- Miguel J. Jiménez Área de Internet/XSL/PHP migueljose.jimenez@isotrol.com ---------------------------------------------------- ISOTROL Edificio BLUENET, Avda. Isaac Newton nº3, 4ª planta. Parque Tecnológico Cartuja '93, 41092 Sevilla. Teléfono: 955 036 800 - Fax: 955 036 849 http://www.isotrol.com "La dicotonomía entre desarrollo económico y sostenibilidad es falsa. Si nos quedamos sin planeta no habrá economía que valga" (Al Gore, Ex-Vicepresidente de EE.UU.)