Depending on tools you will likely use (CGI, perl, etc) you can choose
whatever connectivity suits you best. For perl, it'll be DBI/DBD::Oracle,
for C CGI it will probably be plain OCI, etc. If you want to create stored
procedures in PL/SQL running inside Oracle db and generating whole
pages, take a look at Oracle PSP (PL/SQL Server Pages) or our Dynamic PSP.
Oracle HTTP Server bundled with Oracle8i/9i provides support for a lot
of different ways to do dynamic web stuff using Oracle db as backend -
Java Servlets and JSP, PSP and stored procedures using OWA packages
directly, perl, CGI & FastCGI, shtml and more. Be sure to install the latest
patches available for OHS to plug all security holes and bugs found in it
and its components found to date. You don't need 9iAS for basic tasks,
it's a full-blown application server after all and is probably an overkill for
you (and it costs extra while OHS is already there bundled with the db
server - though you will have to consult with Oracle sales rep to find out
which licensing scheme is appropriate for you if you are going to use it
since OHS is considered 'multiplexing' software and will probably require
per CPU license.)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Mark Bonneville" <mlb3820_at_yahoo.com> wrote in message
news:43738f99.0209120601.29356040_at_posting.google.com...
> 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 Fri Sep 13 2002 - 03:58:23 CDT
