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
USPHARMA Database Site 

"Philippe Saladin" <[EMAIL PROTECTED]> 
15-Sep-2003 02:49

[PHP-DB] Re: Connect to Oracle DB

"Frederico Madeia" <[EMAIL PROTECTED]> a écrit dans le message

> 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. 
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 
you can connect an oracle 7, 8 or 9 database (see
May be http://www.enderunix.org/documents/eng/php_oracle_en.html could 
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 
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.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to