Oracle for Intel

[John Korchok]

Good news for Oracle Mac users! The Instant Client for Intel machines has
finally been released
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/inte
l_macsoft.html

Ryan, when time permits, would it be possible to get an upgrade to Macports
php5 +oracle to include the new Intel version? Thanks many times over! The
PPC version has not been upgraded from the earlier 10.1.0.3. I have included
my earlier notes below about wrinkles in previous installation. Can Macports
add the path to opt/local/apache2/bin/envvars?

John Korchok

> -----Original Message-----
> From: Ryan Schmidt [mailto:ryandesign at macports.org] 
> Sent: Friday, February 15, 2008 11:50 PM
> To: John Korchok
> Cc: 'MacPorts Users'
> Subject: Re: Oracle Notes
> 
> On Feb 3, 2008, at 16:14, John Korchok wrote:
> 
> > For anyone else who may be struggling with getting Oracle 
> to play with 
> > MacPorts PHP, here are my notes after installation on three systems 
> > and about 100 hours of tinkering. Start with a PowerPC, as 
> the Oracle 
> > Instant Client for Mac does not yet work with Intel machines.
> >
> > 1. Install php5 with oracle support:
> > sudo port install php5 +apache2 +oracle
> >
> > 2. So that the Apache user can find the relevant files, add 
> > environment variables to opt/local/apache2/bin/envvars:
> > export LD_LIBRARY_PATH="/opt/local/lib/oracle"
> > export TNS_ADMIN="/Applications/Oracle" (or whatever folder is a 
> > convenient spot to store sqlnet.ora and tnsnames.ora) Many 
> web sites 
> > refer to setting DYLD_LIBRARY_PATH, you can do that instead of 
> > LD_LIBRARY_PATH and it has the same effect. Heck, use 'em both for 
> > good measure!
> 
> I'm surprised LD_LIBRARY_PATH has any effect. I thought that 
> was for Linux and DYLD_LIBRARY_PATH was the Mac OS X equivalent.
> 
> I'm also surprised you needed to set this variable at all. I 
> thought that fixing the library name with install_name_tool 
> like I do in the portfile would make this unnecessary. What 
> error occurs if you do not set this variable?
> 
> > Do _not_ use putenv in a PHP script or SetEnv in httpd.conf 
> to set the 
> > variables, it won't work. Apache will also not pick up environment 
> > variables from /private/etc/profile. Note to Ryan: can 
> MacPorts update 
> > envvars?
> 
> MacPorts can set environment variables for its own use during 
> any of the phases (configure, build, destroot, etc.). However 
> these do not persist after the port has been installed.
> 
> > 3. Restart Apache