Can not connect to Oracle (PHP 4.0.6, Oracle 9i)

gilijk

I have my server running on Linux RH 7.2, Kernel 2.4.7, Apache 1.3.20, PHP 4.0.6, MySQl 3.23.xx. So far there is no problem. But now I tried to connect to Oracle DB on remote server (Oracle 9i).
First I install the Oracle client in the webserver (Oracle 8i Client 8.1.6.0.0 - Programmer type) . Then I try the connection with tnsping and it works properly.

After that I reconfigured the PHP (I use guidance from Ismail Yenigul, Configuring PHP with Oracle 8i Support)

./configure --with-apxs=/usr/sbin/apxs --enable-track-vars \
--with-oci8=/home/oracle/OraHome1 \
--with-oracle=/home/oracle/OraHome1

/home/oracle/OraHome1 is my $ORACLE_HOME path

There is no error when I run the configure script.

I check the phpinfo and still :
--without-oci8 --without-oracle

In php.ini, I enable the line
oci.so and oracle.so manually.

But still there is no change in phpinfo.
Finally I try to find those two file (oci8.so and oracle.so) all around my server and i can not find it.

Could anybody help me with a clue ?

Thank you.

Regards,

Gilijk

piersk

Two points:

Why are you using the Oracle 8 client to access an Oracle 9 server?
As far as I am aware, PHP doesn't like Oracle 9 (just like it doesn't like MS SQL Server 2000). You will have to run both Oracle 8 server and client.

gilijk

Because it works. I've tested it with tnsping, sqlplus and Perl.
I read from many references on Internet (newsgroup. mailing list) that many people have succeed using PHP to connect to Oracle 9i.

So I assume that my problem is in reconfigure PHP. Other people install Oracle client first then PHP. But on my case, I have PHP already running then I installed Oracle client. And when I reconfigure PHP, there is no problem, but still I can find the oci8.so and oracle.so.

Perhaps, you can help me how to reconfigure PHP so those two file exist.

Thank you.

gilijk

I've already solve this problem. I uninstalled from Package manager. Then I extract from tar source, and reconfigure again.