Re: Re: Connect to Oracle DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: roy.a.jones@gsk.com 
USPHARMA Database Site 



"Philippe Saladin" <pheuh@yahoo.fr> 
15-Sep-2003 02:49
 
To
php-db@lists.php.net
cc

Subject
 Re: Connect to Oracle DB







"Frederico Madeia" <fred@farmaciadospobres.com.br> a écrit dans le message
news: 1063392725.26934.153.camel@info...

...
> 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




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux