Online Oracle Apps DBA Training Course Part 1

Oracle’s E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications Oracle applications is the widely used EBS application in the world.Oracle’s E-Business Suite requires extensive work from Oracle Application Database Administrator(Oracle apps DBA). So Oracle Application Database Administrator is a rewarding carrer with great potential to scale new demands great responisiblity and thorough knowledge of the system. Applications DBA should have a clear understanding of the concepts, architecture and internals to be able to do the job effectively

I  am presenting here the Online Oracle Apps DBA Training  Course to equip the Oracle apps DBA with various training material,  how to tips and various trouble shooting tips.  I will be presenting this in Parts.

Here  is  Online Oracle Apps DBA Training  Course Part 1 . Here I will  giving the notes on Architecture on Oracle E-Business Suite 11i, R12.1.3/12.2.X

Introduction to Oracle E-Business Suite 11i, R12.1.3/12.2.5

Oracle apps is a bundle of Ebuisness applications that provide complete solution to the business need of the Oracle customers.

Oracle applications utilizes a  three tier architecture

The three tier are Database Tier, Application tier and Desktop Tier. The distributed architecture shifts software administration from the desktop onto the middle, or application tier, thus reducing client-side maintenance and lowering administration costs.

What is Desktop Tier:

The client interface is provided through HTML for HTML based application and via a Java applet in a Web browser for the traditional Forms-based applications. The desktop client with Oracle JInitiator/JRE downloads the applet on demand and the applet is cached locally for future use.

Self Service Application

The HTML based application called self service does not use Oracle Forms for the interface.They are designed in pure HTML and JavaScript.It is dynamically generate HTML pages by executing Java code.It uses a metadata dictionary for flexible layout

The Self-Service Web Applications architecture consists of the following components  Web browser,The Oracle HTTP server,Java Server Pages, JavaBeans and Servlets

An HTML-based Applications module uses the following access path:
The user clicks the hyperlink of a function from a browser.
The browser makes a URL request to the Web listener.
The Web listener contacts the Servlet engine (OC4J), where it runs a JSP.
The JSP obtains the content from the Oracle E-Business Suite tables and uses information from the metadata dictionary to construct the HTML page.
The resulting HTML page is passed back to the browser, via the Web server.

Forms Based Application

It consists of two part Forms client Applet and Oracle Jinitiater/JRE

Forms Client Applet

The Forms client applet is a general-purpose presentation applet that supports all Oracle Applications products, including those with customizations and extensions. The Forms client applet is packaged as Java archive (JAR) files. The JAR files contain all Java classes typically required to run Oracle Applications forms.

The Forms client applet displays Oracle Applications screens and supports field-level validation, multiple coordinated windows, and data entry aids like lists of values. The Forms client applet sends user requests to the Forms server and handles responses from the Forms server such as screen updates and pop-up lists.

The required and commonly used JAR files are downloaded from the Web server at the beginning of the client’s first session. Afterwards the JAR files remain in the browser’s local disk cache, ready for future sessions until updated versions are released. All updates are installed on the application tier and downloaded to the client automatically through the use of the JInitiator/JRE-enabled Web browser. Other less commonly used JAR files are downloaded on demand, or as needed.

Oracle JInitiator/JRE

The Forms client applet must run within a Java Virtual Machine (JVM) on the desktop. For Oracle Applications the JVM is supplied by Oracle JInitiator/JRE . Oracle JInitiator/JRE works in conjunction with the Web browser.

Oracle JInitiator/JRE  is implemented on the desktop client as ActiveX component (Microsoft Internet Explorer).

When an end user enters the desired Oracle Applications signon URL within the Web browser, Oracle JInitiator/JRE is executed. If Oracle JInitiator has not been installed, the Web browser prompts you to download the necessary installation executable to the desktop client.

Once installed, Oracle JInitiator/JRE runs the Forms client applet and starts an Oracle Applications session.

Apps Desktop tier

Application Tier

The Application Tier is the location of servers that provide the business logic and code processing. This tier is sometimes referred to as the middle tier. Each Application release has different technology components in Middle Tier

Here are the main parts in Middle Toer

The Web Server

The Forms Server

The Concurrent Processing Server

The Reports Server(  This is present in R11i only)

The Admin Server  ( This is present in R11i only)

This tier provides the communication between the desktop tier and the database tier. The application tier also supports load balancing among multiple forms servers to provide optimal scalability and processing.

R11i Middle Tier Architecture

R11i  Middle Tier consists of Apache, Jserv, Forms 6i and concurrent Processing server


Application Server: iAS1.
Servlet Container: JServ
Apache: 1.3.19
Forms & Reports: 6i
Java/JDK: 1.4.2 -> 1.5

R12.0/R12.1  Middle Tier Architecture


Application Server:10.1.3
Servlet Container: OC4J
Apache: 1.3.34
Forms & Reports: 10g(10.1.2)
Java/JDK: 1.5

We have two 10g Oracle Home.


R12.2 Middle Tier Architecture


Application Server: 11gR1 Fusion Middle ware
Servlet Container: Oracle Web logic Server
Forms & Reports: 10.1.2
Java/JDK: 1.6

Online Oracle Apps DBA

All the Middle Tier technologies working can be understood from the below articles

Jserv in 11i

Oracle Forms in 11i/R12

Forms Server Architecture

Jserv Architecture in 11i

All about Apache in 11i/R12

Socket mode for forms in R12

Oracle Containers for J2EE

PLSQL Gateway in R11i

Oracle Concurrent Manager

Database Tier

The database tier contains the Oracle database server that stores and manages all the data maintained by Oracle E-Business Suite. This includes the various types of file in which the tables, indexes, and other database objects for your system physically reside, as well as the database executables.

The database server communicates with the services and servers on the application tier, which mediate the communications between the database and the clients. There is no direct communication between the database and clients.

Related Posts for EBS Architecture

Oracle E-Business Suite Architecture in R12.1

All the Ebuisness Suite Information

key Technology Changes in E-Business Suite R12.1