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

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to link Apache and Oracle?

Re: how to link Apache and Oracle?

From: <nowayjose_at_telus.net>
Date: Fri, 20 Feb 2004 20:28:14 GMT
Message-ID: <t6rc3016ce4t7nfhovsvr1rrvr9vatlbaf@4ax.com>


On Fri, 20 Feb 2004 20:12:44 GMT, Hans Forbrich <hforbric_at_yahoo.net> wrote:

>nowayjose_at_telus.net wrote:
>> On Wed, 18 Feb 2004 15:22:54 GMT, Hans Forbrich <hforbric_at_yahoo.net>
>> wrote:
>>
>>
>>>nowayjose_at_telus.net wrote:
>>>
>>>>Good advice, thank you! However, my Oracle database is on a separate
>>>>machine than Apache and it is that particular Apache that I need to
>>>>link to Oracle... The Apache that I will use is straight from Red Hat
>>>>Enterprise Linux 3, v 2.0 I think...
>>>>
>>>>Besides, I don't know Java...
>>>>
>>>>K.
>>>
>>>You miss the points. Some things to consider:
>>>
>>>1) Apache is included and installed on the database machine. Assuming
>>>you have access to the machine, look at $ORACLE_HOME/Apache/Apache to
>>>get started.
>>
>>
>> Hans, I have to remind you that I can't use the Oracle Apache. It
>> lives on a separate box which is separated by a firewall from the
>> application server. The application server is a Linux box with generic
>> Apache. I can install any public domain software on the application
>> server but I can't access anything on the DB server except Oracle port
>> 1521.
>>
>>
>>>2) Java is irrelevant. Apache is included and installed on your
>>>machine.
>>
>> Not on my machine. On the DB server which I can't access. And in fact
>> Apache is not installed there either, we only have the DB server and
>> Net8 installed. Oracle Apache is an installation option that we didn't
>> choose. So the ONLY instance of Apache that we have lives on a
>> separate box and has nothing to do with the Oracle Apache.
>>
>>
>>>3) You mention JSP. Means Java Server Pages. So you mean some form of
>>>Java.
>>
>>
>> Actually, Java Server Pages has nothing to do with the real java, JSP
>> was not developed by Sun, and the only reason word "Java" is used in
>> the JSP name is marketing. You don't need to know Java to code in JSP.
>>
>>
>>>4) Learn something about web servers. Having Other web servers around
>>>is also irrelevant as you can punt from one to the next. Consider
>>>getting O'Reilly's basic Apache book.
>>
>>
>> Thank you.
>>
>>
>>>5) PLSQL is a great way to connect to DB (using mod_plsql). Saves a lot
>>>of hassle.
>>
>>
>> Is mod_plsql public domain?
>>
>>
>>>6) mod_PERL is included.
>>
>>
>> my question was "what is the easiest way". I know I can use Perl, or
>> PHP, or OCI, or Pro-C, or hundred other methods. I am asking what is
>> the easiest way to do it from Apache installed on a separate from the
>> database box. Mod_plsql sounds good, but only if it is publicly
>> available.
>>
>>
>>>7) Just 'cause Apache 2 is included don't mean you have to use it - it's
>>>not necessarily better (for this purpose), just different.
>>>
>>>/Hans
>>
>>
>
>This is a considerably different question and rules than what I
>understood in the first post and subsequent posts.
>

I am sorry if I wasn't clear.

>In this case, I suggest PERL.

You think Perl is easier to learn and use than PHP? And I guess mod_plsql is not public domain...

Thanks!

K. Received on Fri Feb 20 2004 - 14:28:14 CST

Original text of this message

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