Oracle_Apps: Oracle E-Business Suite Architecture Overview for Apps DBA’s

What is Oracle Applications/Oracle E-Business Suite ?
To facilitate big businesses, Oracle Corporation have created collection of software in
the category of ERP (Enterprise Resource Planning) known as modules, that are
integrated to talk to each other and known as Oracle Applications or E-Business
Suite.

Oracle E-Business Suite Releases:
10.7 : Oldest Release of Oracle ERP which is character, thin client based. Oracle has
stopped support for this release from year 1998.
11 :
11i :
R12 : Latest Release Of EBS by Oracle .

Architecture:
Oracle EBS R12 Applications is a three-tiered architecture.
1.Desktop Tier – Forms Client Applet,Desktop Java Client(sun JRE)
2.Application Tier – containing the application server(TechStack components – Apache,Forms,Report,CMs).
3.Database Tier – containing the database (stand-alone or RAC).

Common Tasks of Apps DBA:
Installing
Configuring -License manager,adsplice,autoconfig,context editor..etc
Maintaining – AD utilities like adadmin,adrelink,adcmctl..etc
Application Patching – – family packs/mini packs/maintenance packs etc.
Cloning
Upgrading
Sysadmin tasks
Troubleshooting on day-to-day activities.
Monitoring the Concurrent Managers queue
Changing the Oracle Apps Passwords.
Printer setups
Monitor Workflow related services.

R12 EBS Directory Structure
Techstack Components :
DB_TIER
– 10.2.0.2 RDBMS ORACLE_HOME
APPL-TIER
– 10.1.2 C ORACLE_HOME / FORMS ORACLE_HOME (8.0.6 ORACLE HOME as in
R11i)
– 10.1.3 Java ORACLE_HOME/OC4J ORACLE_HOME (iAS ORACLE_HOME as in
R11i)
– INSTANCE_TOP : Each application tier has a unique Instance Home file system associated

URL to access E-Business Suite : http://<web server host name>.<domain>:<port number>

How to find above URL in database
sqlplus apps/apps
QUERY : SELECT home_url FROM icx_parameters;