note 71588 added to ref.oci8
| From: | jay dot couture at gmail dot com | Date: | Wed, 06 Dec 2006 23:26:14 +0000 |
| Subject: | note 71588 added to ref.oci8 | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-120354@lists.php.net to get a copy of this message | ||
# 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
----
Server IP: 64.71.164.2
Probable Submitter: 199.82.243.74 (proxied: 199.81.228.99)
----
Manual Page -- http://www.php.net/manual/en/ref.oci8.php
Edit -- https://master.php.net/note/edit/71588
Del: integrated -- https://master.php.net/note/delete/71588/integrated
Del: useless -- https://master.php.net/note/delete/71588/useless
Del: bad code -- https://master.php.net/note/delete/71588/bad+code
Del: spam -- https://master.php.net/note/delete/71588/spam
Del: non-english -- https://master.php.net/note/delete/71588/non-english
Del: in docs -- https://master.php.net/note/delete/71588/in+docs
Del: other reasons-- https://master.php.net/note/delete/71588
Reject -- https://master.php.net/note/reject/71588
Search -- https://master.php.net/manage/user-notes.php