Re: [PHP-DB] 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: [email protected]  Tel: +1 650 506 8630
Twitter:  http://twitter.com/ghrd    Free PHP Book: http://tinyurl.com/f8jad