PHP and Oracle 8i ON SEPARATE MACHINES?

Anon

Has anyone done this that can help?

I want to use my dedicated webserver to connect to a separate oracle DB on another machine -- when I do the PHP install --with-oci8=/path/ should I have the path point to my other box? How would I do that?

Thanks,

Matt

Anon

You have to install the oracle client libraries on the PHP machine.

Anon

Jack,
Where can I download those libraries? I've searched all over Oracle.com and Technet.oracle.com and cannot locate them. Please help!

--
Matt

Anon

You have to download the server itself. When you run the OUI, it will give you an option to just install the Client libraries. If you have compilation problems after installing just the client, then your client download is missing a few files (mine was) from a directory $ORACLE_HOME/rdbms/demo. You can either install the whole server to get these files, copy them from the computer with Oracle server installed or find them on the Oracle cd.

There are some other requirements when doing the install...

make sure all your environment vars are set properly (ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH, etc).
make sure these vars are set up at startup BEFORE you start the webserver or else it will just crash.

Good Luck,

Jack

Anon

I am doing something very similar and I was wondering if you could help.

I have a tested PHP/ Apache/ OCI installation on AIX but I want to port it to another server (behind a firewall). PHP & Apache are OK but when I copy the OCI libraries, AIX reports a different size for the lib directory - even though all the files are the same size as for the existing installation!!! - Oh, and the PHP script won't work on the new server.

Any suggestions?

Anon

Did you copy the entire Oracle Home directory and set all your environment variables?