note 71588 modified in oci8.setup by sixd

# Here's what it took to get it going for me on Red Hat on # x86_32 w/ 10gr2 and php5.1.2 # I sincerely appreciate all of the other poster's notes. # It was a combination of a few # of them to get mine configured. My note should reflect this: # install the instantclient basic and sdk like this # note: the original poster had you install into a lib subdirectory, # but when I tried this it couldn't find the sdk files. So I moved # the files in lib into the parent directory as # shown below. Actually I copied them, YMMV mkdir -p /usr/lib/oracle/10.2.0.2/client unzip -jd /usr/lib/oracle/10.2.0.2/client instantclient-basic-linux-x86-32-10.2.0.2-20060331.zip mkdir -p /usr/include/oracle/10.2.0.2/client unzip -jd /usr/lib/oracle/10.2.0.2/client instantclient-sdk-linux-x86-32-10.2.0.2-20060331.zip ln -s /usr/lib/oracle/10.2.0.2/client/libclntsh.so.10.1 /usr/lib/oracle/10.2.0.2/client/libclntsh.so # make the full client use instantclient's files cd /app/oracle/product/10.2.0/db_1 mv lib oldlib ln -s /usr/lib/oracle/10.2.0.2/client/lib lib ln -s /usr/include/oracle/10.2.0.2/client include #php configure line is: ./configure --with-oci8=instantclient,/usr/lib/oracle/10.2.0.2/client # I had to do this, or the OCI8 would not compile when # I ran make on PHP5.1.2 I did not do this originally when I # had the files in the lib sudirectory (see my note above) so # that may be the true issue. export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.2/client:$LD_LIBRARY_PATH make make install #In apache2 edit the envvars and add LD_LIBRARY_PATH="/usr/local/apache2/lib: /usr/lib/oracle/10.2.0.2/client:$LD_LIBRARY_PATH" TNS_ADMIN="/usr/lib/oracle/10.2.0.2/client" LANG=en_US export LD_LIBRARY_PATH LANG TNS_ADMIN #Restart Apache Jay --was-- # Here's what it took to get it going for me on Red Hat on # x86_32 w/ 10gr2 and php5.1.2 # I sincerely appreciate all of the other poster's notes. # It was a combination of a few # of them to get mine configured. My note should reflect this: # install the instantclient basic and sdk like this # note: the original poster had you install into a lib subdirectory, # but when I tried this it couldn't find the sdk files. So I moved # the files in lib into the parent directory as # shown below. Actually I copied them, YMMV mkdir -p /usr/lib/oracle/10.2.0.2/client unzip -jd /usr/lib/oracle/10.2.0.2/client instantclient-basic-linux-x86-32-10.2.0.2-20060331.zip mkdir -p /usr/include/oracle/10.2.0.2/client unzip -jd /usr/lib/oracle/10.2.0.2/client instantclient-sdk-linux-x86-32-10.2.0.2-20060331.zip ln -s /usr/lib/oracle/10.2.0.2/client/libclntsh.so.10.1 /usr/lib/oracle/10.2.0.2/client/libclntsh.so # make the full client use instantclient's files cd /app/oracle/product/10.2.0/db_1 mv lib oldlib ln -s /usr/lib/oracle/10.2.0.2/client/lib lib ln -s /usr/include/oracle/10.2.0.2/client include #php configure line is: ./configure --with-oci8=instantclient,/usr/lib/oracle/10.2.0.2/client # I had to do this, or the OCI8 would not compile when # I ran make on PHP5.1.2 I did not do this originally when I # had the files in the lib sudirectory (see my note above) so # that may be the true issue. export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.2/client:$LD_LIBRARY_PATH make make install #In apache2 edit the envvars and add LD_LIBRARY_PATH="/usr/local/apache2/lib: /usr/lib/oracle/10.2.0.2/client:$LD_LIBRARY_PATH" TNS_ADMIN="/usr/lib/oracle/10.2.0.2/client" LANG=en_US export LD_LIBRARY_PATH LANG TNS_ADMIN #Restart Apache Jay http://php.net/manual/en/oci8.setup.php