I just wanted to add my two cents ...
I have compiled php with BOTH --with-oracle and --with-oci8. It is
usually preferred to have your architectures/systems separate to prevent
some performance issues. As a test/demo system then having them on the
same box is perfectly acceptable and removes some of the setup issues. The
standard oracle (--with-oracle) extension provides basic oracle
connectivity for versions 7, 8, and 9. The oci8 (--with-oci8) allows for
Oracle 8i (and up) specific functions (LOBs and others). Just a note ...
watch what versions of the Oracle client that you install. From my
experience the Oracle 9i client can NOT connect to a pre-Oracle 8.0
database. I am connecting to 100+ different Oracle instances from 7.3.x
to 9.2.x on many different OS (Solaris, HP, Linux, Windows). My php
server is Red Hat Linux 7.2 with Apache.
Roy A. Jones
Oracle DBA
Email: [EMAIL PROTECTED]
USPHARMA Database Site
Philippe Saladin [EMAIL PROTECTED]
15-Sep-2003 02:49
To
[EMAIL PROTECTED]
cc
Subject
[PHP-DB] Re: Connect to Oracle DB
Frederico Madeia [EMAIL PROTECTED] a écrit dans le message
news: [EMAIL PROTECTED]
...
How i connect one server running PHP(linux) to other server running
Oracle(linux) ??
when i tryed to connect with ora_logon, the server return me: Call to
undefined function: ora_logon().
1) the oracle extension is not loaded. You need to compile php with it.
BUT,
you should use --with-oci8 and not --with-oracle. The oracle extension
(ora_logon function and friends) is an old one, it can only connect to an
oracle 7 database. With the oci extension (ocilogon function and
friends),
you can connect an oracle 7, 8 or 9 database (see
http://fr.php.net/manual/en/ref.oci8.php)
May be http://www.enderunix.org/documents/eng/php_oracle_en.html could
help
you too.
2) php compiled with oci extension is not enough. You need the oracle
client. Unfortunately, for Linux, you can't download it alone. You need
to
download the entire oracle database : see
http://otn.oracle.com/software/content.html or ask your DBA : he should be
able to give you this oracle client for linux.
In php.net describe some functions to connect to oracle,. but how i make
to do work ???
I must install oracle on same server that runing php ??
no, you can have two servers.
Tanks.
Regards,
Philippe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
