Re: MOD/PLSQL: What's next?

Karsten Farrell wrote:

> 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 > DBA

Benchmarks may not be worth much ... but they're not that low.

Daniel Morgan Received on Wed Mar 05 2003 - 14:45:27 CST