Oracle 12c Administration I

Price
$2,695.00
Duration
 5 Days
Delivery Methods
 VILT    Private Group
Skip to Class Dates  
Request More Information
Printable PDF / Omit Schedule

In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems.

 

Upcoming Class Dates and Times

Jul 19  - Jul 23, 2021
8:00AM - 4:00PM Central
5 Days
Virtual Instructor Led
 GTR
Enroll

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.

Agenda

1 - ORACLE DATABASE ARCHITERCTURE OVERVIEW
  • The Database Instance
  • Database Memory Structures
  • Database Process Structures
  • Database Storage Architecture
  • Oracle Clusterware
2 - CONFIGURING THE HOST FOR STANDALONE INSTALLATION
  • 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
  • Database Software Upgrades
  • Multiple Oracle Software Installations
3 - GRID INFRASTRUCTURE CONFIGURATION
  • Configure the Linux Installation
  • About ASM Devices
  • Configure Linux Devices for ASM
  • Partitioning a Device
  • Oracle ASMLib
  • Configure MS Windows Devices
4 - GRID INFRASTRUCTURE CONFIGURATION
  • 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
5 - DATABASE INSTALLATION CONFIGURATION
  • Configure a Linux Installation
  • System Groups & Users
  • Configure Kernel Parameters
  • Create the Physical Directories
  • Configure MS Windows Installation
  • Prerequisite Checks & Fixup Utility
6 - 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
7 - 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
8 - 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
  • Listener Configuration Modification
  • Database Configuration Modification
  • STARTUP/SHUTDOWN USING SRVCTL
  • Why Use srvctl?
  • MANAGING ORACLE RESTART
  • Obtaining Oracle Restart Status
  • Start/Stop Oracle Restart
9 - 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
10 - UPGRADE TO ORACLE DATABSE 12C
  • Launch DBUA
  • Database Upgrade Dialog
11 - 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
12 - 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
13 - 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
14 - ORACLE ARCHITECTURE: PRINCIPLES & 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
15 - 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
  • RE-CONFIGURING 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
16 - 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
17 - 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
18 - 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
19 - ORACLE DATABASE STORAGE 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
20 - 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
21 - 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
22 - 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
 

Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with United Training