Re: PHP/Oracle home problem ?

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_yahoo.com>
Date: 31 Aug 2007 21:25:25 GMT
Message-ID: <46d88745$0$1341$834e42db@reader.greatnowhere.com>

On Fri, 31 Aug 2007 04:36:38 -0400, Mladen Gogala wrote:

> You should also add LD_LIBRARY_PATH. Add the following in the
> /etc/init.d/httpd:
> export ORACLE_HOME=/ORACLE/app/oracle/product/11g export
> LD_LIBRARY_PATH=$ORACLE_HOME/lib

BTW, PHP-5.2.4, available as of today, correctly reports oracle version as ˝11.1˝

$ php -r 'phpinfo();'|egrep -i 'oci|oracle' Configure Command => './configure' '--with-apxs2=/usr/sbin/apxs' '-- with-xmlrpc' '--with-zlib' '--with-bz2' '--with-ttf' '--with-gd' '--

enable-gd-native-ttf' '--with-freetype-dir' '--with-jpeg-dir' '--with-png-
dir' '--with-config-file-path=/usr/local/lib/php' '--enable-sigchild' '--
without-sqlite' '--disable-mysql' '--disable-pdo' '--with-oci8=/oracle/

product/11.1.0'
oci8
OCI8 Support => enabled
Oracle Version => 11.1
Compile-time ORACLE_HOME => /oracle/product/11.1.0

oci8.default_prefetch => 10 => 10
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => 0 => 0
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20

LD_LIBRARY_PATH => /oracle/product/11.1.0/lib ORACLE_HOME => /oracle/product/11.1.0

-- 
http://www.mladen-gogala.com

Received on Fri Aug 31 2007 - 16:25:25 CDT