Oracle and PHP4 and Linux

Anon

I have been installing Oracle 8i (8.1.5) on a Linux box and it works fine.

I was trying to install php 4 will support for Oracle and php is looking for a file called "libclntsh.a". However this file doesn't exist on my system.
I do have a "libclntsh.so".

Has anyone tried to install this version of oracle together with PHP?

/Jesper

Anon

You have to set the environment variables below before you start apache (or even compile it or PHP). I set these in the root /root/.bashrc file (change directories to your directories):

export ORACLE_BASE=/usr/local/oracle
export ORACLE_HOME=/usr/local/oracle
export ORACLE_SID=YOUR_SID
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

When you compile PHP, include both directives for Oracle and oci8:

--with-oracle=/usr/local/oracle --with-oci8=/usr/local/oracle

This worked for me (after many hours of the same problem!). Note: If you don't have the correct environment var set BEFORE starting apache it will give you lotsa errors (like if you have configured apache to start automatically at boot, you will need to set these vars there also).

Anon

It didn't work for me.
Whenever I am building the php4 (DSO) or apache (with static php4), I get the error
"ld -lclntsh: file not found"

When I look for libclntsh.a I can't find it either.

Are there supposed to be a libclntsh.a or only a libclntsh.so.8.0?

If so, is libclntsh.a a part of Oracle or PHP??

Anon

Did you try

./configure --with-oci8=$ORACLE_HOME --enable-sigchild

Anon

The message "ld -lclntsh: file not found" is telling you it cannot find libclntsh.so.8.0. libclntsh.a does not exist until successful compilation (apache builds it).

This message is telling you that either your LD_LIBRARY_PATH variable is not set or is pointing to the wrong directory. It is usually in $ORACLE_HOME/lib, however you will need to verify this, and if it isn't change the LD_LIBRARY_PATH to point to where it really is.

Jack

Anon

i'm not giving any answer here cause i've got the same problem but i try to do ..
this ..
./configure --with-oci8=$ORACLE_HOME --enable-sigchild

but ... did'nt work ..
🙂)

Anon

I got the complier to find -lclntsh by making a link from libclntsh.so.8.0 to libclntsh.so

But now I got a new problem:
/opt/oracle/app/oracle/product/8.1.5/lib/libclntsh.so: undefined reference to 'nauzaoss'

/jesper

Anon

If it can't find libclntsh.so.8.0 chances are it won't be able find any of the libraries THAT library is looking for (if you just created a link).

Instead do this:

find / -name libclntsh.so.8.0

The DIRECTORY it finds the library in is what you need. (If it doesn't find it then your install is incomplete!)

export LD_LIBRARY_PATH=/path/to/the/dir/from/above:$LD_LIBRARY_PATH

That should get you past that step (but you may need to set the rest of the environment vars also):

configure directives: --with-oracle=/usr/local/oracle --with-oci8=/usr/local/oracle

Env vars:
export ORACLE_BASE=/usr/local/oracle
export ORACLE_HOME=/usr/local/oracle
export ORACLE_SID=YOUR_SID
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Adjust the directories/SID for your install directories and SID.

Note: When you boot the webserver these vars still have to be set. I set them in /root/.bashrc but you can do it however you like.

Jack

Anon

The problem with "can't find -lclntsh" was that my installation didn't create the symbolic link libclntsh.so for the file libclntsh.so.8.0.

When I created that it worked.

However then I got an error of missing symbols in libclntsh.so.
This is because my installation didn't create ldflags either.

I found a solution on Oracle Technet that worked.

cat $ORACLE_HOME/network/install/ldflags*

$ORACLE_HOME/lib/ldflags
2. Remove all newline from ldflags
3. run genclntsh to create a new libclntsh.so file

That should do it.

Anon

I find it in other list, it works for me:

http://marc.theaimsgroup.com/?l=phpdoc&m=95933533624119&w=2

hi - 

maybe we should have a new section in the docs for problems
like this? (apache doesn't start). 

my answer below is not oracle-specific but applies to all
glibc-2.1 systems when linking agains -lpthread

tc



please relink your apache adding -lpthread to the LDFLAGS.

the problem here is that a executable thats *not* linked
agains -lpthread cannot load a shared library that is liked
against -lpthread. (libphp4.so - linked against -lclntsh
linked against -lpthread).

this is a glibc-2.1 bug that supposed to be finxed in 2.2 (i
heard).

Anon

Eventhough I compiled correctly and set all environment variables correctly, when I try to bring up apache it says [OK] but it apparently goes right back down. No messages, no errors or anything. The resulting libphp4.so file is 2,449,835 in size. Could this be a problem for apache loading a module this size. I would have thought an error message would have been tracked somewhere!

Any suggestion?

Thanks,
Mike Walker

Anon

Are you environment variables set for the user starting apache also? (Not just the Oracle user)

Jack

Anon

Yes all ORACLE variables are set for root. I compile and link from root and execute apache from root. I am using the default apache binary from red hat 6.2 release. Iwas wondering about Eduardo message on the lpthreads problem. Could that be it?

Anon

i can't start apache server

wrong message
"libphp4.so can't into server :
libclntsh.so.8.0 can't found "

who can help me/????

Anon

./configure --with-oracle \
--with-sigchild

can you tell me what is
"-with-sigchild" ???

Anon

I have oracle8 on WindowsNT Server.
I have configured Apache and PHP on Linux so that it it working fine with php but i am not able to get connected with oracle server. It is giving error message :
"Fatal error: Call to undefined function: ocilogon() in ../database/oradbaccess.php on line 49"

Kindly help me in solving this problem.

With regars,
Rudolf A. M.

Anon

You need to compile php with Oci8 (--with-oci8=/opt/oracle....)
To be able to compile php with oci8, you need to install and configure Oracle client software (net8).

Hope this solves your problem.

Jesper