In this session we will cover what is the role of the Database Tier in Oracle eBusiness suite R12, The database tier comprises the Oracle database server that stores and manages all the data of Oracle E-Business Suite R12. It also contains various types of files in which the tables, indexes, and other database objects for the system physically reside, as well as the database executables. Oracle E-Business Suite online help information is also stored in this database.

IN THIS SESSION, WE WILL LEARN:

• What is the role of Database Tier
• Schemas of Database in Oracle EBS like
  • The APPS Schema
  • Base Product Schemas
  • Custom Schema
• what is Link Between APPS Schema and Base Product Schemas
• What is the Tablespace model that is used as standard with Oracle E-Business Suite Release 12
• Benefits of OATM vs old tablespace model

LINKS AND RESOURCES MENTIONED IN THIS SESSION

• EBS 12.2 Setup Guide — Oracle Applications Tablespace Model
• EBS 12.2 System Administrator’s Guide – Configuration: Oracle EBS Tablespace Model and Migration Utility

(TTT) – Tricks of The Trade:

Using a Mixed/Split Platform (Operating System) Architecture

We have observed that the Oracle database server is sometimes available on operating systems where Oracle E-Business Suite is not currently certified. In this case, we can use Mixed/split OS architecture, where the database is installed on one OS and the application tier on another.

As we know EBS is made up of three-tier architecture, whereas tier is a logical grouping of services that may be distributed across one or more physical machines.

• R-12.2=Using Oracle EBS 12.2 with a Database Tier Only Platform on Oracle 12c Release 1 (Doc ID 1926202.1)
• R-12.0/12.1=Oracle EBS R12 with Database Tier Only Platform on Oracle Database 11.2.0 (Doc ID 456347.1)
• R-11i=Using Oracle E-Business Suite with a Split Configuration Database Tier on Oracle 11g Release 1 (Doc ID 562983.1)