Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » PLSQL toolkit and OAS
PLSQL toolkit and OAS [message #367424] Wed, 22 November 2000 04:37 Go to next message
Messages: 132
Registered: September 1999
Senior Member

We have been developing some web applications using the PLSQL toolkit (though we had installed webdb, we did not find it very flexible and are comfortable writing the procedures from scratch). We have just the database server running oracle 8i on windows NT and the web agent service running on the same machine. We don't have OAS or any middle tier webservers.

If we need to move these applications to three tier architecture using Oracle Application Server, what are the changes we will have to make. Also, will the web agent be running on the middle tier instead of the database server as its doing now? How is the data communicated between the OAS and the database server? (i.e. tnsnames entries??) What exactly is the difference in bringing a middle tier in our case?

How will this be different if we have to later on build applications using ASP?

thanx for your time

Re: PLSQL toolkit and OAS [message #367425 is a reply to message #367424] Wed, 22 November 2000 05:40 Go to previous messageGo to next message
Dean Logan Wood
Messages: 19
Registered: September 2000
Junior Member
First off, you may wish to consider using iAS rather than OAS. OAS is no longer sold by Oracle, although it is still supported.

You should not need to making any changes to your application if you implement a separate middle-tier. iAS (and OAS) use SQL*Net to connect to the database, as does the web agent on your existing server.

So, you install iAS (or OAS) on a separate middle-tier server, configure a DAD that references an account of TNS service/connect string for your remote database, and you're off.

ASP is proprietary MicroSoft technology, and you cannot use it with OAS and iAS as they are supplied by Oracle. There are 3rd Party add-ins for Apache (the Web Server supplied with iAS) and other non-MicroSoft Web Servers that will allow you to use ASP - for example Chili!Soft ASP. With OAS, you would need to configure it to use MicroSoft IIS rather than the supplied Spyglass Listener in order to use ASP. You should be note that if you chose the IIS/OAS option, you're are effectively running two application servers with separate management, configuration and monitoring interfaces, we you may not regard as acceptable.
Re: PLSQL toolkit and OAS [message #367426 is a reply to message #367425] Wed, 22 November 2000 11:58 Go to previous message
Messages: 132
Registered: September 1999
Senior Member

That was a lot of info. Thanx a lot.


Previous Topic: Upload images on the webserver
Next Topic: Oracle error -20004 in PL/SQL cartridges
Goto Forum:

Current Time: Tue Sep 29 10:27:11 CDT 2020