Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle & Apache

Re: Oracle & Apache

From: David McCarty <dmccarty_at_dallas.net>
Date: Thu, 28 Oct 1999 22:40:54 -0500
Message-ID: <38191746.8EC3A1A6@dallas.net>


Hey Chris,

We are running RH6 distro with Oracle v8.0.5. We use Apache with Mod_Perl and DBD for the connection. Like they were saying all of the stuff you will need is on CPAN and here is an example of some of the conf settings .......

SetEnv ORACLE_HOME /home/oracle/8.0.5.0.0 SetEnv DBSERVER dbi:Oracle:dev1
SetEnv DBLOGIN <theusrname>
SetEnv DBPASSWORD <thepasswd>
SetEnv ORACLE_SID ORCL

........
.....
........

PerlSetEnv ORACLE_HOME '/home/oracle/8.0.5.0.0' PerlSetEnv DBSERVER 'dbi:Oracle:dev1'
PerlSetEnv DBLOGIN '<theusrname>'
PerlSetEnv DBPASSWORD '<thepasswd>'
PerlPassEnv ORACLE_HOME
PerlPassEnv DBSERVER
PerlPassEnv DBLOGIN
PerlPassEnv DBPASSWORD
PerlModule Apache::DBI
PerlModule Apache::Status
PerlModule DBD::Oracle
PerlModule Devel::Symdump
PerlModule Apache::StatINC
PerlModule AuthDBI;
PerlModule AuthzDBI;
PerlInitHandler Apache::StatINC
Perlrequire /usr/local/apache/cgi-bin/mod_perl/startup.pl
........
....
..
.

Hope that helps....

"Chris_at_iprc.net" wrote:

> Hi experts,
>
> Do any of you have a workable configuration for Apache & Oracle? I have a
> project that runs both Apache & Oracle on Linux on x86. Now both set up are
> up and running. But how can I create html pages that can talk to Oracle for
> select, update, delete, blah, blah, blah? What tools should I use and what
> is the set up required?
>
> rgds,
> Chris
Received on Thu Oct 28 1999 - 22:40:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US