Re: oci_connect

Fred Silsbee wrote:

I have the following in /etc/httpd/conf/httpd.conf SetEnv ORACLE_HOSTNAME localhost.localdomain SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin SetEnv ORACLE_BASE /u01/app/oracle SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1 SetEnv ORACLE_SID lmkiiiGDNSID SetEnv ORACLE_TERM xterm SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/11.1.0/db_1/lib:/lib:/usr/lib

I personally don't set them in httpd.conf because I don't believe putting them there works consistently across platforms. And we can't cross check your site because you haven't yet mailed the information I requested in more than one email/post. And I really doubt LD_LIBRARY_PATH being set before Apache executable starts is a good idea. I strongly suggest you set the environment in the shell that starts Apache:

    export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
    export ORACLE_SID=lmkiiiGDNSID
    export LD_LIBRARY_PATH /u01/app/oracle/product/11.1.0/db_1/lib:/lib:/usr/lib
    /usr/sbin/apachectl start

(The other variables aren't needed) You may need to make sure these are set at boot time, if you Apache starts at machine boot.

but showing in phpinfo is: oci8 OCI8 Support enabled Version 1.3.4 Revision $Revision: 1.269.2.16.2.38.2.20 $ Active Persistent Connections 0 Active Connections 0

Compile-time ORACLE_HOME 	no value                 ??????????????

Libraries Used no value Temporary Lob support enabled Collections support enabled Directive Local Value Master Value oci8.connection_class no value no value oci8.default_prefetch 100 100 oci8.events Off Off oci8.max_persistent -1 -1 oci8.old_oci_close_semantics Off Off oci8.persistent_timeout -1 -1 oci8.ping_interval 60 60 oci8.privileged_connect Off Off oci8.statement_cache_size 20 20

These values are not relevant to your problem. What is in the section with the heading "Environment"? Check for the ORACLE_HOME and ORACLE_SID variables there. On RHEL 5.2, if I use SetEnv in httpd.conf, I only see the variables in the "Apache Environment" section and not the "Environment" section of phpinfo().

NOTHING about Oracle in php.ini but there is a section about MySQL

That's fine. Nothing needs to be set. Everything has a default. You can see the defaults in phpinfo output, and they are mostly tuning settings. You can add any configuration setting you want to change. Nothing there will affect a basic connection test script like the one you previously posted. Chris -- Email: christopher.jones@oracle.com Tel: +1 650 506 8630 Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/f8jad