LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 12-28-2002, 12:50 PM   #1
ronald_fancher
LQ Newbie
 
Registered: Apr 2001
Posts: 14

Rep: Reputation: 0
oracle 9i and php


I installed RedHat 8 and Oracle 9i, and now I am trying to configure PHP 4.2 as an Apache module with Oracle OCI support. Oracle 9i installs it's own Apache server. I now have 2 problems: 1) I installed the basic PHP RPMs but can't get them to work with Oracle's Apache; I can't even get a "Hello World" to be shown from a basic .php file (same file works OK on Oracle / Windows 2K, yuch). 2) How to I recompile / reconfigure PHP as an Apache module with Oracle OCI8 support?

Has anyone done this or know where some instructions might be? Oracle Metalink proudly states repeatedly that they don't support PHP and won't help. Google articles all talk about standard Apache but not Oracle's.

Any help or pointing toward documentation would be appreciated.
 
Old 12-28-2002, 02:28 PM   #2
Ciccio
Member
 
Registered: Nov 2002
Location: Paraguay
Distribution: Mandrake 10
Posts: 573

Rep: Reputation: 30
Ok, I'm not sure if this would help but I've heard that 9i is a faulty version. I heard something about 8.7 being more performant (up to a 60%)

Try downloading and compiling from source the php packages and the apache server. perhaps this could help.
 
Old 12-28-2002, 03:49 PM   #3
ronald_fancher
LQ Newbie
 
Registered: Apr 2001
Posts: 14

Original Poster
Rep: Reputation: 0
Actually, Oracle 9iV2 is a very good release, fixes a lot of bugs in 8.1.7. All the documentation for building PHP for Redhat, even at php.net, doesn't give enough detail for somebody who hasn't done it before. It seems like everybody assumes you know the details so they don't have to provide them...
 
Old 12-28-2002, 11:43 PM   #4
Ciccio
Member
 
Registered: Nov 2002
Location: Paraguay
Distribution: Mandrake 10
Posts: 573

Rep: Reputation: 30
Ok. My source is a Telecom Corporation... perhaps you know it like TIM (telecom italia movile)... Actually a sub company... Personal, cel company of Paraguay. They use 9i and it is 40% less performant than the older version. I know it is not the same... they use it on a GS-160 for other things than hosting webpages... but it is a weak release.
 
Old 01-13-2003, 02:41 PM   #5
sock
LQ Newbie
 
Registered: Jan 2003
Distribution: SuSE, Mandrake, Debian, Solaris ;)
Posts: 6

Rep: Reputation: 0
Some ideas

I just compiled PHP with Oracle9i support, on SunOS. Anyway, you need to have Oracle installed on the machine (or know what OCI libraries, headers it looks for). Then

in php-4.3.0 (the latest PHP, which I used):

./configure --with-oracle=/home/oracle/OraHome1

(where /home/oracle/OraHome1 is the root directory of the oracle install, it should have directories like dbs, admin, rdbms, network, etc)

make
make install

This doesn't do anything with Apache support, but if you get PHP to compile there are a million tutorials on using PHP with apache, just remember to specificy --with-oracle=

If you need more help let me know, I've been doing a lot with PHP, Apache and Oracle recently.
Rob
 
Old 01-13-2003, 02:42 PM   #6
sock
LQ Newbie
 
Registered: Jan 2003
Distribution: SuSE, Mandrake, Debian, Solaris ;)
Posts: 6

Rep: Reputation: 0
http://www.enderunix.org/documents/e...oracle_en.html

I just found that link, while searching for other things. It covers Oracle8i, but the two seem to be the same as far as PHP cares.
Rob
 
Old 01-13-2003, 06:11 PM   #7
ronald_fancher
LQ Newbie
 
Registered: Apr 2001
Posts: 14

Original Poster
Rep: Reputation: 0
Thanks. On Redhat 8 I finally uninstalled Oracle's Apache and then installed the generic one. I was then able to compile PHP with OCI OK. I think the problem was in PATH and LD_LIBRARY_PATH, but after a few attempts to sort it out, it wasn't worth the effort.

My solution doesn't let me use the Oracle Webserver stuff, but I didn't care about that.

Thanks again.
 
Old 03-03-2003, 09:27 AM   #8
FGTH
LQ Newbie
 
Registered: Mar 2003
Posts: 3

Rep: Reputation: 0
PHP 4.3.1 and Oracle 9 on Sun Solaris 8

I tryed to configure PHP with the support of Oracle 9i with different syntax, like
configure --with-oci8=/usr/local/oracle/product/9.0.1.3 \
--with-oracle=/usr/local/oracle/product/9.0.1.3

(or just the oracle or just the oci8)


but I always get a

ld: fatal: file /usr/local/oracle/product/9.0.1.3/lib/libclntsh.so: wrong ELF class: ELFCLASS64

Any tips ? Somebody was talking about changing stuff to point from lib to lib32, but I didn't much further.

 
Old 03-03-2003, 09:06 PM   #9
ronald_fancher
LQ Newbie
 
Registered: Apr 2001
Posts: 14

Original Poster
Rep: Reputation: 0
Usually an error with LD indicates a problem with or a complete lack of the environment variable LD_LIBRARY_PATH. If you have access to Oracle's metalink you will find a lot of hits when searching on LD_LIBRARY_PATH. Even if you don't, you can probably search Google and find enough info to solve your problem.
 
Old 03-04-2003, 08:11 AM   #10
arnold
Member
 
Registered: Dec 2002
Posts: 226

Rep: Reputation: 30
my oracle is 9.2.0. It appears robust. I have used Perl DBI with it but not tried PHP.

try file /usr/local/oracle/product/9.0.1.3/lib/libclntsh.so
should say ELF 32-bit LSB shared object If not, try
find /usr/local/oracle/product/9.0.1.3 -type f -name libclntsh\* -exec file {} \;
this will show if there is any other version
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Compiling php with oracle support fintan Linux - Software 1 12-31-2006 12:34 PM
PHP Oracle 9i Configure netpicker9 Mandriva 0 05-05-2005 01:47 AM
PHP Oracle 9i Connection Problem (RH9) dhammika Linux - Software 8 03-28-2005 02:18 PM
php & oracle 9i dominant Linux - Newbie 9 07-20-2004 10:18 AM
Please help with PHP/Oracle RPM install on RH9 pnovess Linux - Newbie 0 08-08-2003 04:54 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 03:58 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration