Architecture of Oracle Apps 11i

Basic Things to know in Oracle apps 11i:

Tier is a logical grouping of services, The services can be in a single machine or spread across more than one machine.

Node is referred as Physical Machine. Each Tier may consist of one or more node and each node can have more then one Tier.

By Default oracle application is built on Three Tier Architecture. Let us see that in Detail.

1. Desktop Tier :
This is the First Tier from where the client machine connects to the server via HTML based (known as self serviced) or via java based (using jinitiator) for Form based access.

2. Application Tier (Middle Tier):

This is called as a Middle Tier or the second Tier. This Tier consists of of WebServer, Forms server, Report server, Concurrent processing, Discoverer and Admin Server.

Note: This is Not a must that all the above server should be in the same node, It can be spread in different nodes.

3.Database Tier:

This is the Third node and most important node called as the Database node where all the changes and other things what we are doing in the front end from the client node is processed via middle Tier and comes to the database and stored here.

As per the usage, we are giving the naming conventions as Different Tiers. To be in more clear, The Front end (end users) is called as a Desktop Tier or First Tier, and the information passed from the end users are get processed where it is called as a middle Tier (has various process and components to be covered) and the final data or the processed data is Database is called as the Third Tier.

Oracle Applications Overview:
======================

An Oracle Applications system physically consists of :

A) A File system containing the following:

- Forms
- Reports
- Concurrent Programs
- Programs and Scripts
- HTML and Java

B) An Database Consists of:

- Data Objects(Data Files)
- Code Objects.


In Brief About Oracle Applications:
=========================

A) A File System:
=============
- Forms That allow interactive entry and updating of data.
- Reports that allow formatted documentation and display of data.
- Concurrent programs that provide high volume, Non-interactive,Update of Data.
-HTML and Java that perform certain user interface and business functions.

B) An Database (Oracle 9i or 10g).
==========================
- Data Objects, Such as tables,Indexes used to store Customer data.
- Code Objects, Such as PL/SQL stored procedures and triggers for performing database processing, Views,Grants and Synonyms.

Versions To see and To Know Here is Mainly for the Three things:
===========================================

Product Version

1. Oracle Database (9i or 10g) 9.2.0.8 or 10.2.0.1.0

2. Developer 6i Patch set 16 or 18

3. Oracle HTTP Server powered by Apache 1.3.19

Note : There are sample Versions to look in But there are many versions are there and the Developer 6i includes Forms,Reports etc..ie) what are all used by Developers (As per my Assumption).