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@xxxxxxxxxx Tel: +1 650 506 8630
Twitter: http://twitter.com/ghrd Free PHP Book: http://tinyurl.com/f8jad
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
