Re: [PHP-DB] Oracle Client Libraries for Linux

2004-06-15 Thread Christopher Jones
Peter Beckman wrote:
 How do I get connected from a remote PHP+Apache box to Oracle9i on linux?
The current Oracle Instant Client bundle is fine for using PHP on
Windows, but does not have headers for compiling PHP with Oracle
support on other platforms.  An Instant Client SDK with headers is
coming soon I'm told, so scenarios like yours will be made a lot
simpler.
In the meantime, to link with Oracle 9i drivers, download the
Oracle9i Database Release 2, run the installer and choose the
Client option.  Without knowing your hardware, I'd guess along with
you that you want the 9.2.0.4 bundle marked Enterprise/Standard
Edition for Linux New.
For Oracle 10g drivers download the Oracle Database 10g Client
Release, run the installer and choose the Administrator option.
I'd go with the 10g option.
There are some documents (including one on PHP/Oracle/Linux) that may
help at http://otn.oracle.com/tech/opensource/index.html
Chris
Peter Beckman wrote:
Folks --
I've been trying to figure out where the Oracle client libraries live, but
I'm confused as hell.
I've read the PHP-DB archives, and everyone keeps talking about installing
the client libraries (libclntsh et al), and how that's all you need for
Oracle 9i PHP support.  Great -- but which options presented horribly by
Oracle do I download?
On this page:
http://otn.oracle.com/software/products/oracle9i/index.html
It lists:
   Oracle9i Release 2 (9.2.0.4)
Oracle9i Database Release 2 Enterprise/Standard Edition for Linux x86-64 New 
(03-May-04)
Oracle9i Database Release 2 Enterprise/Standard Edition for Linux New 
(26-Mar-04)
Oracle9i Release 2 (9.2.0.2)
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for 
Windows XP 2003/Windows Server 2003 (64-bit)
Oracle9i Database Release 2 Enterprise/Standard Edition for HP-UX/IA64 
(v9.2.0.2)
Oracle9i Database Release 2 Enterprise/Standard Edition for HP Alpha OpenVMS
Oracle9i Database Release 2 Enterprise/Standard Edition for Linux/IA64, 
Release 2 (v9.2.0.2)
Oracle9i Release 2 (9.2.0.1)
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for 
Windows Server 2003 (32-bit)
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows 
NT/2000/XP
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris 
(32-bit)
Oracle9i Database Release 2 Enterprise Edition for Sun SPARC Solaris (64-bit)
Oracle9i Database Release 2 Enterprise/Standard Edition for HP-UX
Oracle9i Database Release 2 Enterprise/Standard Edition for Compaq Tru64
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX-Based 5L 
Systems
Oracle9i Database Release 2 Enterprise Edition for Linux/390
Oracle9i Database Release 2 Client for Windows 98/NT/2000/XP
Oracle9i Release 2 - Developer's Releases
Oracle9i Database Release 2 for IBM Power based Linux New! [01-Dec-03]
Oracle9i Developer Release 1 (9.2.0.3.0) for Linux / AMD64
Oracle9i Database Release 2 Enterprise Edition for Apple Mac OS X Version 10.2 
Jaguar
Oracle9i Release 1 (9.0.1)
Oracle9i Release 1 (9.0.1) Enterprise Edition (all platforms)
Oracle9i Personal Edition for Microsoft Windows 98
Oracle9i Release 1 - Developer's Releases
Oracle9i Enterprise Edition for z/Linux, Release 1 - Developer's Release
I'm running Linux RH Enterprise 3 on this server, and the Oracle box is
remote.  My original assumption is to download the second link, 9iR2 for
Linux.  However, this is 1.5GB worth of a download for three friggin
drivers.  What the hell?
All of the clients are for Windows, Even the 9.0.1 release is 1.1GB.
What do I need to download from Oracle to get the drivers for PHP?  Please
don't just say go to otn.oracle.com and download the client because I've
been there and cannot for the life of me find it.
I don't have the ability to display X Windows remotely, so whatever
solution has got to be command line.  I'm at my wits end!
I've installed Instant Client, so I have the 10g libraries:
/usr/lib/oracle/10.1.0.2/client/lib -- ll
total 109664
drwxr-xr-x2 root root 4096 Jun 14 12:36 ./
drwxr-xr-x4 root root 4096 Jun 14 12:36 ../
-rw-r--r--2 root root  1417242 Feb 23 19:32 classes12.jar
-rw-r--r--1 root root 1353 Feb 23 19:32 glogin.sql
-rwxr-xr-x2 root root 13347415 Feb 23 19:32 libclntsh.so.10.1*
-rw-r--r--2 root root  2838283 Feb 23 19:32 libnnz10.so
-rw-r--r--2 root root   969980 Feb 23 19:32 libocci.so.10.1
-rwxr-xr-x2 root root 91345295 Feb 23 19:32 libociei.so*
-rw-r--r--2 root root96117 Feb 23 19:32 libocijdbc10.so
-rw-r--r--1 root root   759920 Feb 23 19:32 libsqlplus.so

RE: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Andrew Hill

Tom,

From Oracle :)

Alternativley you can use the OpenLink Multi-Tier ODBC driver at
www.openlinksw.com.  It downloads with a free 2-connection license, and has
free support available at www.openlinksw.com/support/suppindx.htm

HTH!

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access  Data Integration Technology Providers

 -Original Message-
 From: Tom Tsongas [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 11, 2001 12:56 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Oracle Client Libraries?


 Hi all.

 Where can I get the Oracle client libraries for PHP4? I am running
 Apache and PHP4 on my NT Server and I will be connecting to an Oracle
 database on a Solaris server via remote connect? I saw some threads
 earlier indicating that they could be found at download.swwwing.com but
 that server is apparantly no longer running.

 Anyone?

 Thanks.

 Tom Tsongas



 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Tom Tsongas

Hi again.

I just found an above message that states the DLLs I need are in the PHP package
I installed and I just need to uncomment them from php.ini. Am I off the beaten
track or is that true?

I found the listings for php_oracle.dll and php_oci8.dll in php.ini under the
'Dynamic Extensions' section. I'm 'guessing' I only need to restart Apache now
to activate the extensions.

In my scenario, php and Apache are on my local NT server while the Oracle
database is on a Solaris box. Anything else I need to know?

Thanks in advance.

Tom


Anthony Carlos wrote:

 Tom:

 Go to technet.oracle.com and download Oracle 8i Database for WinNT. When you
 run the installer, you can do a custom set-up to only install the networking
 libraries (Net8). Run Net8 Easy Config. That will get you started.

 I'm not sure how much it costs officially. You'll have to call up Oracle for
 current pricing.

 Anthony Carlos

 -Original Message-
 From: Tom Tsongas [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 11, 2001 12:56 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Oracle Client Libraries?

 Hi all.

 Where can I get the Oracle client libraries for PHP4? I am running
 Apache and PHP4 on my NT Server and I will be connecting to an Oracle
 database on a Solaris server via remote connect? I saw some threads
 earlier indicating that they could be found at download.swwwing.com but
 that server is apparantly no longer running.

 Anyone?

 Thanks.

 Tom Tsongas

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]