In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems.
TARGET AUDIENCE
This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to understand configuration for installation, configuration of a host system, using Oracle Restart framework, troubleshooting tips, how the database fits with other systems, internals of the database, database failures and other topics
COURSE OUTLINE
ORACLE DATABASE ARCHITERCTURE OVERVIEW
The Database Instance
Database Memory Structures
Database Process Structures
Database Storage Architecture
Oracle Clusterware
CONFIGURING THE HOST FOR STANDALONE INSTALLLATION
Host Configuration Overview
Choosing a Database Host
Choosing an Operating System
Proprietary Unix vs Open-Source Linux
Making the OS Selection
Prepare an Oracle LINUX Installation
Perform Oracle LINUX Installation
Configure the LINUX Host
Step 1 – Confirm General System Requirements
Step 2 – Confirm The Operating System Platform
Step 3 – Confirm LINUX Package Requirements
Step 4 – Confirm Network Configuration
Configure Host for Virtualization
VM Technologies
Configure Oracle Linux for Virtualization
Step 1 – Download Linux Updates
Step 2 – Check Linux Kernel
Step 3 – Download Latest yum Configuration File
Step 4 – Enable Oracle Linux Add-ons
Step 5 – Install VirtualBox
Oracle Optimal Flexible Architecture
OFA Goals
ORACLE_BASE
ORACLE_HOME
Database Files
Multiple ORACLE_HOMEs
Databse Software Upgrades
Mutliple Oracle Software Installations
GRID INFRASTRUCTURE CONFIGURATION
Configure the Linux Installation
About ASM Devices
Configure Linux Devices for ASM
Partioning a Device
Oracle ASMLib
Configue MS Windows Devices
GRID INFRASTRUCTURE INSTALLATION
Perform the Installation
Download
Unpack the Installation Package
Launch the Installation Session
The Installation Dialog
Verify the Installation
Operating System Confirmation
Oracle Utilities Setup
SQL*Plus Confirmation
Using EM Cloud Control
Troubleshooting Problems
DATABASE INSTALLATION CONFIGURAION
Configure a Linux Installation
System Groups & Users
Configure Kernel Parameters
Create the Physical Directories
Configure MS Windows Installation
Prerequisite Checks & Fixup Utility
DATABASE INSTALLATION
ABOUT THE INSTALLATION
The Installation Tools
About The Installation Dialog
The Installation Session Log
PERFORM INSTALLATION ON LINUX
Download
Unpack The Installation Files
Set Environment Variables
Launch The Installation
SERVER CLASS INSTALLATION DIALOG
More About The Global Database Name
About Enterprise Manager Cloud Control
Secure The New Database
PERFORM INSTALLATION ON WINDOWS
Launch The Installation
POST—INSTALLATION CONFIGURATION
Required Environment Variables
Defining The Environment Variables
About SSH
VERIFY THE INSTALLATION
SQL*PlusConfirmation
Operating System Confirmation
Firewall Configuration
Accessing EM Database Express
CREATING DATABSES USING DBCA
About DBCA
DBCA Templates
Are You Sure?
DEFAULT CONFIGURATION DATABASE
ADVANCED MODE DATABASE
File Location Variables
Database Vault and Label Security
CONFIGURE AN EXISTING DATABASE
DELETE A DATABASE
MANAGE TEMPLATES
MANUALLY CREATE A DATABASE
The CREATE DATABASE Command
USING ORACLE RESTART
WHAT IS ORACLE RESTART?
What Oracle Restart Does
Is Oracle Restart Deprecated?
Registering With Oracle Restart
More About srvctl
Terminal Session Configuration
COMPONENT STATUS USING SRVCTL
Database Status
Grid Infrastructure Status
Oracle Home Status
CONFIGURATION USING SRVCTL
Examining A Database Configuration
Examining The Listener Configuration
Examining The ASM Configuration
Manual Registration
ListenerConfiguration Modification
Database ConfigurationModification
STARTUP/SHUTDOWN USING SRVCTL
Why Use srvctl?
MANAGING ORACLE RESTART
Obtaining Oracle Restart Status
Start/Stop Oracle Restart
PREPARING FOR A DATABASE UPGRADE
What is a Database Upgrade?
Database Upgrade Methods
Real World Database Upgrade
Develop A Database Upgrade Plan
ABOUT THE DATABASE VERSION
Direct Upgrade
The COMPATIBLE Database Parameter
PRE-UPGRADE PREPARATIONS
Oracle Warehouse Builder
Oracle Label Security (OLS)
Oracle Database Vault
Locating The Older Database Installations
THE PRE-UPGRADE INFORMATION TOOL
Pre-Upgrade Information Tool Files
Run The Pre—Upgrade Information Tool
Examining The Pre—Upgrade Information Tool Results
UPGRADE TO ORACLE DATABSE 12C
Launch DBUA
Database Upgrade Dialog
POST-UPGRADE TASKS
Post-Upgrade Checklist
Enable Unified Auditing
Migrate to Unified Auditing
Database Parameter Changes
Enable New Features
Source Destination Specific Post-Upgrade Tasks
ORACLE ARCHITECTURE: THE SYSTEMS INFRASTRUCTURE
About Enterprise Architectures
The Relational Database
Legacy Computing Models
The Multi-Tiered Computing Model
Scaling Up
Cloud-Based Deployment
ORACLE INFRASTRUCTURE ECOSYSTEM
USING ORACLE ENTERPRISE MANAGER
More About EM
Using EM Database Express
Using EM Cloud Control
ORACLE ARCHITECTURE: THE DATABASE HOST
The Database Server Stack
PROCESSOR LAYER
CPU Resources
Memory Resources
I/O & STORAGE PROCESSING
OS LAYER PROCESSING MODES
DATABASE SERVER VIRTUALIZATION
STORAGE VIRTUALIZATION
ORACLE DATABASE SERVER STACK
ORACLE ENGINEERED SYSTEMS
Oracle Exadata Database Platform
Exalogic Cloud Machine
Exalytics BI Machine
ORACLE ARCHITECTURE: PRINCILPLES & TECHNOLOGY CONCEPTS
Grid Computing Principles
Why Grid Computing?
What Is Grid Computing?
PARALLELIZATION PRINCIPLES
Hardware Parallelization
Grid Computing Devices
Clustered Database Servers
CLOUD COMPUTING PRINCIPLES
Multi-Tenancy
ORACLE ARCHITECTURE: THE RDBMS INSTALLATION & THE DATABASE INSTANCE
The Database Server Software
Database Versions & Releases
Database Editions
Using PRODUCT_COMPONENT_VERSION View
The Core Database Components
Using V$VERSION View
Understanding The Database Version Number
The COMPATIBLE Database Parameter
DATABASE INSTANCE ELEMENTS
Individual Elements Of A Database Instance
Physical Database Elements
An Operational Database installation
DATABASE INSTANCE CONFIGURATIONS
Single Instance
Parameter Files & Instance Configuration
MAX_STRING_SIZE Parameter Example
Independent Instances
Clustered Instances
The Database Instance In A Multi-tenant Configuration
RECONFIGURING A DATABASE INSTANCE
Static Vs. Dynamic Parameters
Dynamic Parameter Setting
Parameter Setting Scope
Parameter Setting Level
Setting Upgrade Related Parameters
DATABASE COMPONENTS
Advanced Data Functionality Components
Security Components
High-Performance Components
Administration Components
Database Feature Usage
ORACLE DATABASE INSTANCE: MEMORY ARCHITECTURE
Shared & Private Memory
SGA INTERNALS
The Buffer Cache
The Database Smart Flash Cache
The Redo Log Buffer
The Shared Pool
The Large Pool
The Java Pool
Unified Auditing Queues
PGA INTERNALS
What Is Inside The PGA?
Tunable & Non-tunable PGA Space
Client-Side Cursors
Where Is The PGA Stored?
PGA/UGA In Shared Server Mode
PGA/UGA With Optional Large Pool
LOB OBJECTS & MEMORY HANDLING
LOB Buffer Caching
Shared I/O Pool
LOB Workspace & The PGA
INSTANCE MEMORY MANAGEMENT
About Automatic Memory Management
Default Settings
Configure MEMORY_TARGET Parameter
Configure SGA_TARGET Parameter
Configure PGA_AGGREGATE_TARGET Parameter
PGA_AGGREGATE_LIMIT Parameter
Configure Memory Using EM DE
ORACLE DATABASE INSTANCE: BACKGROUND PROCESS ARCHITECTURE
Foreground vs. Background
ABOUT THE BACKGROUND PROCESSES
The Background Processes
Linux System Processes
The DBWR Process
The LGWR Process
Checkpoints And The CKPT Process
The SMON Process
The PMON Process
The LREG Process
The ARCH Process
The RECO Process
The CJQx Process
The DBRM Process
The Management Framework Processes
Flashback Data Archive (FBDA) Process
Fault Diagnostics
Other Housekeeping Processes
Background Process Performance Monitors
THREADED MODE
About Process Mode
About Threaded Mode
KERNEL ERRORS & EXCEPTIONS
The Error Message
The Error Message Stack
Kernel Errors & Core Dumps
ORA-006xx & ORA-07445 Errors
Understanding The Kernel Errors
The Kernel Module
Kernel Module Arguments
Diagnostic Modules
The Call Stack Trace
ORA-600/ORA-7445/ORA-700 Error Lookup Tool
ORACLE DATABASE INSTANCE: FOREGROUND PROCESS ARCHITECTURE
Dedicated Server Mode
Session Details From V$SESSION View
Session Details From EM Database Express
What Is The Impact Of Dedicated Server Mode?
SHARED SERVERS MODE
Processing SQL In Shared Servers Mode
Comparing Dedicated Server & Shared Servers Mode
Dedicated Server Mode Client Connection
Dedicated Server Mode SQL Statement Execution
Shared Servers Mode Client Connection
Shared Servers Mode SQL Statement Execution
Consider Dedicated Server Mode
Consider Shared Servers Mode
Shared Servers Mode Advantages
CHOOSING THE SQL EXECUTION MODE
Instance-Level SQL Execution Mode Configuration
Session-Level SQL Execution Mode Configuration
PARALLEL SQL EXECUTION
What Is Parallel Execution?
The Impact On SQL Statement Execution
SQL STATEMENT EXECUTION
Parse Phase
Execute Phase
Fetch Phase
SQL OPTIMIZATION & EXECUTION PLANS
Optimization Methods
Rule-Based Optimizer
Cost-Based Optimizer
Automatic Tuning Optimizer
Adaptive Execution Plans
Adaptive Statistics
ORACLE DATABSE STOREAGE ARCHITECTURE: LOGICAL DATABASE OBJECTS
About Database Objects
Relational Database Objects List
Database-Resident Program Units
Additional Database Objects
Database Objects Illustrated
DATABASE OBJECTS CONTEXT
The Data Dictionary Schema(s)
Making An Object Reference
Explicit Schema Context
Explicit Database Context
Partition Context
EDITIONS CONTEXT & REDEFINITION
About Application Upgrades
About Application Downtime
The Edition Hierarchy
The Editions In Action
ORACLE DATABASE STORAGE ARCHITECTURE: PHYSICAL DATABASE FILES
About the Database Files
SERVER PARAMETER FILES
CONTROL FILES
REDO LOG FILES
DIAGNOSTIC FILES
What Are The Diagnostic Files?
EM Cloud Control Access
The MAX_DUMP_FILE_SIZE Parameter
The DIAGNOSTIC_DEST Parameter
The Log Files
Text Alert Log Contents
Viewing Text Alert Log Contents
Viewing Alert Log Errors
Maintaining The Alert Log
The Trace Files
Background Process Trace Files
SQL Execution Process (User) Trace Files
Incident Dump Files
Core Dump Files
Trace Files At The OS Level
Sample DIAG Trace File
Monitoring Trace File Space Usage
Maintaining The Trace Directories
FILES IN A MULTI-TENANT DATABASE
ORACLE DATABASE STORAGE ARCHITECTURE: TABLESPACES
Tablespaces & Data Files
Peering Into The Tablespace Storage Hierarchy
More About Clustered Table Storage
More About The RowID
Hybrid Columnar Compression
TEMPORARY SEGMENTS
About Temporary Segments
About Temporary Tablespace Groups
Advantages
INDEX SEGMENTS
B-tree Index Segments
Bitmap Index Segments
ORACLE DATABASE INTERNAL MECHANISMS: DATA CONCURRENCY
System vs User Locks
Internal Locks
Using V$LOCK_TYPE View
Latches
Using V$LATCH View
Mutexes & V$MUTEXT_SLEEP
User Locks
MANAGE & MONITOR SYSTEM LOCKS
About Database Wait Events
Concurrency Wait Events (Mutex)
Concurrency Wait Events (Latch)
Spinning Vs. Sleeping
Using EM Cloud Control
Using AWR
