Oracle

[Anon]

Have anyone know how to setup PHP+Linux to talking with NT+Oracle8i. I saw that someone talking about OCI, what is this and where I can get the Oracle8i client for Linux?

Thanks for your help.
==Kris==

[Anon]

You have to create a database link on the nt server for oracle if you have an oracle server on linux. Else if only client is installed on linux set up your tnsnames.ora on linux machine to connect to oracle on nt.
use this link like any other dsn connection.
you are done with the links.

[Anon]

Thanks nagaraja,

May be my question was not clear.

I have Oracle8i running on NT as pure DB server. I want to use PHP from my Linux box query Oracle DB. Do you know howto?

==Kris==

[Anon]

Hi:
I'm working in the same way and it's running OK.

Here is a little HOW-TO:

NT box: Nothing to make. If you can connect from any client that'all.

Linux box:

Must have an oracle client installed. Oracle haven't client software CD or package. You must get the Enterprise Server for Linux and install it but only the software ( don't create database ). The Enterprise Edition for developers can be downloaded from technet.oracle.com. Once installed you must make the oracle user public, putting the oracle environment variables ( ORACLE_HOME, ORACLE_BASE, ORA_NLS33, etc... ) in the /etc/profile of the Linux box. The directory tree of the oracle software must have rigths set to 664 ( All users can read and execute any file of the oracle user ). Define the TNSNAMES.ORA entry for the NT instance. To test all of this any user should be able to make an 'sqlplus username/password@ora_service_name without problems. If all of this is correct then you must compile the php to be able to use the oracle software ( for example with the --with-oracle=(copy this the 'echo $ORACLE_HOME' ).

This works very well for me.
E-mail me for more specific information.

[Anon]

Thank you very very much, David.
I'll download and do as your instruction.
==Kris==