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_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

    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: $
> 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
>        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.


Email: [EMAIL PROTECTED]  Tel: +1 650 506 8630
Twitter:    Free PHP Book:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to