Re: MOD/PLSQL: What's next?

Hi!

You could configure a reverse proxy on your 3rd server and direct all http requests to your production server (which is in separate DMZ). This can be done using Apache, the plus is you don't have to purchase another Oracle App server license.

Another approach is to put Oracle 9iAS to your 3rd server and point it's mod_plsql to your production apps db (again through firewall). You might even make copies of those packages to separate very restricted schema, but accessing the same tables. You should make sure that the mod_plsql version with yout new 9iAS works with OWA packages in DB. If not, some hacking needs to be done, since you shouldn't replace the original OWA packages which came with apps.

3rd approach would be to install both application server and a DB instance on your new server and set up some replication from-to prod DB, thus allowing no external user to connect to your internal DB. Again, if all of the systems are in different DMZs, this approach should be the most secure. (note that the replication doesn't even have to be Oracle replication over sqlnet, it could be some kind of very restrictive replication with text file transfers or smth like that).

Tanel.
P.S. Karsten, I think BEA isn't able to run PL/SQL generated HTML as mod_plsql does?

"dar" <dar_at_dar.com> wrote in message news:RUq9a.326353$2H6.6030_at_sccrnsc04...
> 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
>
>
Received on Wed Mar 05 2003 - 17:55:39 CST