This is a core curriculum training which begin with a discussion of the broad systems infrastructure where one finds Oracle database installations, and we outline how the database fits with other systems in a multi-tiered architecture, including web servers, application servers and engineered systems such as the Oracle Exadata database computing platform. We then explore the intricacies of a single database installation, including memory, process and storage structures. Periodically we delve into the internals of the database, probing into such areas internal locking mechanisms, kernel module calls and database failures.

This training initially presents the Oracle database architecture from the perspective of a traditional, single-tenant database configuration as it exists within an on-premise systems infrastructure. We then draw comparisons between such a traditional environment and the new Oracle 12c multi-tenant architecture, used in both traditional and cloud-based computing models.

We present this information in a form that goes beyond a discussion of theoretical concepts. In many cases the Enterprise Manager interface is used to explore the components under consideration. Therefore one of the secondary objectives of this training is to acquaint you with the built-in Enterprise Manager Database Express interface and sometimes with its EM Cloud Control (CC) companion. In particular our focus is to discover the capabilities of the Enterprise Manager Database Express interface newly introduced with the Oracle 12 database release.

The architecture of different Oracle database installations are not all uniform, as there is considerable flexibility regarding the way a particular installation is configured. Such configuration options exist largely in the form of database parameter settings. So this textbook will devote considerable time to identifying these parameters and how these settings can be used to configure a database installation to suit local requirements.

The information contained within this training is critical to the success of most Oracle technology professionals, whether they are database administrators, security specialists, tuning experts or cloud computing administrators.

This training considers subjects helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration" as well as an Oracle Database 12c Administrator Certified Professional (OCP), Oracle Database 12c Administrator Certified Master (OCM), and an Oracle Database 12c Performance Tuning Certified Expert.

Oracle Database: SQL Fundamentals

Oracle Database 12c: Install & Upgrade Workshop

 

The successful completion of this course requires that one have access to an Oracle Database 12c Enterprise Edition (EE) installation. The textbook entitled ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP will assist you in performing such an installation and it is for this reason that it is listed above as a mandatory prerequisite. The training that you are now reading is therefore intended to help you to explore the architecture and the internals of the new database installation that you may have just created using that prerequisite as a guide.

ORACLE  ARCHITECTURE:  THE  SYSTEMS  INFRASTRUCTURE

ORACLE  ARCHITECTURE:  THE  DATABASE HOST

ORACLE ARCHITECTURE: PRINCIPLES & TECHNOLOGY CONCEPTS

ORACLE ARCHITECTURE: THE RDBMS INSTALLATION & THE DATABASE INSTANCE

ORACLE DATABASE INSTANCE: MEMORY ARCHITECTURE

ORACLE DATABASE INSTANCE: BACKGROUND PROCESS ARCHITECTURE

ORACLE DATABASE INSTANCE: FOREGROUND PROCESS ARCHITECTURE

ORACLE DATABASE STORAGE ARCHITECTURE: LOGICAL DATABASE OBJECTS

ORACLE DATABASE STORAGE ARCHITECTURE: PHYSICAL DATABASE FILES

ORACLE DATABASE STORAGE ARCHITECTURE: TABLESPACES

ORACLE DATABASE INTERNAL MECHANISMS: DATA CONCURRENCY