Re: Oracle/VMS performance problems with Multithreaded Server

There are a lot of different ways to run Oracle on OpenVMS or other platforms:

1. Terminal (character based). I doubt you want to go back there.
2. 2 tier client/server. Oracle Forms, Reports, etc runs on the client machine. This works fine, but you must install the software on the client. Oracle does not have a reliable way of automating this client installation. Bit of a pain if you have a lot of them. Not terribly scalable. Also, you need some kind of fileserver (any will do) for a central repository for your .fmx and .rdf files.
3. 3 tier client/server. This is where Oracle Application Server (Forms server is a sub-set) comes in. The form runs on the middle layer (usually NT or unix). The client uses only a browser. Advantages: no client software install, very scalable, looks just like Forms to your users. Disadvantages: More effort to set up initially, some forms will need adaptation.
4. PL/SQL 3-tier. Again using Oracle Application Server, but all your application logic lives in your database as stored procedures. The client uses only a browser. This setup is very scalable and very easy to maintain. All you need is a PL/SQL guru. This is my favorite so far (and my users too).
5. Java. Your Java applets communicate directly with the database server. You still need a webserver, of course. I have not played with this one yet, so I can't comment on how hard or easy the implementation is.
6. Embedded SQL. Almost forgot this 2-tier method. You can use embedded SQL inside C++ and other code so your applications can communicate with the DB server. Sounds like a lot of work to me.
7. There are other ways too, like ODBC, OLE, DDE, COM, etc. All fairly complex and needing a lot of client set-up.

Hope that helps,

Gord

Alan Greig <A.Greig_at_virgin.net> wrote in message news:3a002647.1984980020_at_news.newsguy.com...
> On Wed, 01 Nov 2000 13:24:46 GMT, "Tom Wade"
> <t.wade_at_vms.eurokom.ie.nospam> wrote:
>
>
> >
> >We wanted to set up an Oracle database which could be queried and updated
> >using Oracle Forms on PCs. We wanted this to run on an OpenVMS Alpha
> >platform
> >without having to insert an NT or (even worse) Unix based web server in
 the
> >middle. We have been told it is not possible because the Forms server
 does
> >not run on VMS. If this is correct, then it doesn't add up to "fully
>
> Well Oracle Forms is part of Develloper 2000 which is available for
> VMS. Can run either as a character cell terminal app (traditional
> forms) or in X GUI mode.
>
> However in your case Oracle Forms would be running on the PC and use
> SQL/Net to talk to the Oracle server running on VMS. This works fine.
> To the best of my knowledge there is no such thing as a "Forms Server"
>
> >supported" to me. Perhaps somebody out there knows better, or is doing
 this
> >a slightly different way ?
>
> Did this comment come from Oracle or some other consultant? In any
> case sounds as if they don't know what they are talking about.
>
> You could also avoid having to run any part of Oracle on the PC by
> using an X client (err server....) on the PC such as Exceed or
> eXcursions. Which is the way we do it.
>
> But if you really want to be bang up to date then Oracle 8i can be run
> on VMS with the form running as a Java Applet in the PCs browser.
> --
> Alan Greig
Received on Wed Nov 01 2000 - 13:57:02 CST