Net8 proxy ?

We've got two servers running linux, one of them runs as web server and has oracle 8 installed, but no oracle 8 instance is running. The other one is a dedicated oracle 8 database server. net8 connections to this server are only allowed from the web server.

since java applications downloaded from the web server can only connect back to this server (and not to the database server), we need to set up some kind of sqlnet/net8 proxy on the web server which passes requests comming from the rest of the world to the database server.

I guess that for this purpose only the net8 listener has to be running on the web server, but I'm not sure how the listener.ora and tnsnames.ora files on the web server have to look like.

both instances on the database server (ora1 and ora2) are already running and are accessible from the web server using either oraperl or sqlplus using the names dbone.ora1 and dbone.ora2.

Any help highly appreciated. Received on Mon Mar 22 1999 - 23:34:16 CET