Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MOD/PLSQL: What's next?
dar_at_dar.com said...
> First I'm not sure what is the best way to accomplish this. So if you know
> of a better way please enlighten me. Currently I have oracle database
> (8.1.7.4) running on a solaris 2.6 box (32bit) with oracle Applications 11i
> (11.5.5). using mod/plsql I have developed some custom procedures that will
> run using apache on that box. Now I want outside world to be able to use
> these mod/plsql procedures and I don't want to expose this production sever.
> I'm not sure what the next steps for me are. I took another server with
> solaris 9 on it and apache and was hoping that there was a cunning way to
> forward requests from one apache instance to another transparently (users
> wouldn't know). Or do I have to install a database instance on the second
> box and somehow make mod/plsql to talk back to the other database. I'm
> really confused and looking for pointers in the right direction because i
> don't think I'm making progress how I would like to.
>
> dar
>
What you need is an "application server" in the middle tier (tier 1 =
client, tier 2 = app server, tier 3 = database server behind firewall).
There are many app servers (software product) out there. We use BEA
WebLogic for our tier 2 here. Oracle9iAS claims they're faster ... but
benchmarks are about as trustworthy as statistics and politicians. :)
-- /Karsten DBA > retired > DBAReceived on Wed Mar 05 2003 - 12:09:45 CST