Re: Re: Connect to Oracle DB

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 [PHP-DB] 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