straight forward Oracle unix web solution sought

Pardon this newbie to Oracle. We have a competent Oracle DBA in house but his knowledge falls shy of Web Admin. We have an 8.1.7 Oracle instance running on AIX 4.3. I want to connect the instance to the web.

I understand Oracle comes with Apache and have a request pending to have it installed and configured on the same server as the Oracle instance. I have worked with Progress, SQL Server and DB2 and set up multiple web sites so I am passingly familiar with web architecture, html, cgi, perl etc. I have set up my own connections between dbs and web server via ksh, perl and cgi. I am hoping for a tighter integration for Oracle.

What I need to know is which Oracle solution, toolkit, software topology I should employ to join the Oracle instance and the web server so that I can retrieve the database and server metric data I will store there. Queries will be submitted via html forms and I intend to present the data in line charts (for which I use gnuplot and ppmtogif on my other sites). I usually create web pages in an HTML tool and then add scripting to handle the data presentation.

I undertand there is WebDB (for NT and Solaris only?), Oracle Web Server, Oracle Application Server (v9?), PSP, Oracle Web Toolkit, OAS etc etc and all of this over a variety of Oracle versions.

Can you point me in the right direction for a basic Oracle DB <--> Web solution?

Many Thanks,

Mark Received on Thu Sep 12 2002 - 09:01:15 CDT