Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :-

Sunday, March 16, 2008

Oracle DBA Scripts: Oracle DBA Scripts: Apps 11i Architecture

Oracle DBA Scripts: Oracle DBA Scripts:Apps 11i Architecture

This Topic is quite important and I recommend you to go through this thoroughly.
First I want to discuss terminology which you will encounter here & in most of Oracle Documentation.

Server - is a process or group of processes and provides a particular functionality/service For example, Database Server listen and process database requests, similarly Web Server listens for and processes HTTP requests.

Tier - is a logical grouping of services, may be on single machine or spread across more than one physical machine. For Example, Middle Tier in Oracle apps consist Form,Web,Report...Services. Forms & Report can be one machine 1 & Web Server can be on machine 2, still they will be part of same tier called as Application Tier or Middle Tier.

Node - is referred as Machine, Each tier may consist of one or more node and each node can potentially have more than one tier.

Desktop Tier - Oracle Applications/E-Business Suite is built on three tier Architecture with first Desktop Tier ic client machines accessing applications via browser(HTML based Self service applications) or Java Applet(Jinitiator) for Form based interface.

Application/Middle Tier - Second is Application Tier also called as middle tier consists of WebServer Forms, Reports, Concurrent processing, Discoverer and Admin Server. I suppose its known as Middle tier because it lies between our desktop & third tier called database tier.

Database Tier - Third is Database Tier contain Orale database server which store all your application data. I am sure if you are DBA you know it :)

About Architecture of Individual Component like , Web Server, Form Server .... I will cover in my future posts.



  1. Good introduction on APPS 11i architecture. This is the most frequently asked question. Now it is clear

  2. Thank you Rathish ! Hope you have a good start with APPS 11i.
    Ajith Pathiyil

  3. Hi, congratulation by your explanation, ever is neccesary to get undertood simply concept

    sorry my poor english


  4. Thanks for the explanation.. this was good one...

  5. Thanks for the explanation.. this was good one...Thanks Ajith..


Thanks for you valuable comments !