fbpx

 Oracle Database 12c - Administration II


Duration: 5 days

Course Overview

In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties.

Course Objectives

Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database.

Course Outline

1 - INTRODUCTION: MANAGING THE DATABASE INSTANCE

  • The Database Management Tools
  • EM Database Express
  • EM Cloud Control
  • SQL Developer
  • Database Administrator

2 - INTRODUCTION: DATABASE ARCHITECTURE REVIEW

  • Database Instance Configurations
  • Memory Structures
  • Process Structures
  • Storage Architecture

3 - INTRODUCTION: STARTING & STOPPING DATABSE SERVICES

  • Start & Stop the Database Listener
  • ABOUT DATABASE STARTUP/SHUTDOWN
  • SYSOPER
  • SYSDBA
  • DATABASE STATE & STAGES
  • STARTUP WITH EM CLOUD CONTROL
  • STARTUP WITH SQL*PLUS
  • SHUTDOWN WITH EM CLOUD CONTROL
  • SHUTDOWN WITH SQL*PLUS
  • USING MS WINDOWS SERVICES

4 - INTRODUCTION: ORACLE NETWORK ENVIRONMENT

  • Oracle Net Services Architecture
  • ORACLE NET CONFIGURATION ASSISTANT
  • ORACLE NET MANAGER
  • USING EM CLOUD CONTROL
  • ADVANCED NETWORK COMPRESSION
  • TROUBLESHOOTING NETWORK PROBLEMS

5 - INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT

  • About Database Diagnostics
  • Fault Diagnosability Infrastructure
  • DATABASE INSTANCE HEALTH SNAPSHOT
  • THE SUPPORT WORKBENCH
  • PROACTIVE DATABASE HEALTH CHECKS
  • PACKAGE DIAGNOSTIC DATA
  • WORKING WITH THE KNOWLEDGE BASE

6 - STORAGE: TABLESPACE MANAGEMENT

  • Starter Tablespaces
  • CREATE TABLESPACE WITH EM CC
  • CREATE TABLESPACE WITH SQL
  • MANAGE TABLESPACES WITH EM CC
  • MANAGE TABLESPACES WITH EM DE
  • MANAGE TABLESPACES WITH SQL
  • DROP TABLESPACE
  • ALTER TABLESPACE

7 - STORAGE: ADVANCED TABLESPACE MANAGEMENT

  • Managing Temporary Tablespaces
  • TEMP TABLESPACE GROUPS WITH EM
  • TEMP TABLESPACE GROUPS WITH SQL
  • DEFAULT PERMANENT TABLESPACES
  • BIGFILE TABLESPACES
  • MANAGING THE SYSAUX TABLESPACE

8 - STORAGE: DATA FILES & TEMP FILES MANAGEMENT

  • Manage Data Files with EM
  • ACCESS METADATA WITH SQL
  • MANAGE DATA FILES WITH SQL
  • MANAGE TEMP FILES
  • ORACLE-MANAGED FILES (OMF)

9 - STORAGE: UNDO DATA & UNDO TABLESPACES

  • About UNDO Space Management
  • GUARANTEE UNDO RETENTION
  • MONITOR UNDO SPACE WITH SQL
  • USE THE EM UNDO ADVISOR

10 - SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES

  • Database Security Principles
  • DATABASE SYSTEM PRIVILEGES
  • DATABASE OBJECT PRIVILEGES
  • SUPER ADMINISTRATOR ROLES
  • PRIVILEGE ANALYSIS

11 - SECURITY & SCHEMAS: USER SECURITY

  • Create & Manage User Accounts
  • MANAGE USERS WITH EM
  • MANAGE USERS WITH SQL
  • CREATE USER
  • ALTER USER
  • DROP USER
  • GRANT & REVOKE PRIVILEGES
  • RESOURCE LIMITS VIA PROFILES
  • ALTER PROFILE
  • DROP PROFILE
  • PASSWORD MANAGEMENT VIA PROFILES
  • ROLE-BASED SECURITY MANAGEMENT
  • ALTER USER...DEFAULT ROLE
  • SET ROLE
  • DELEGATING PRIVILEGE AUTHORIZATION
  • WITH ADMIN OPTION & System Privileges
  • WITH GRANT OPTION & Object Privileges
  • PRINCIPLE OF LEAST PRIVILEGE CHECKLIST

12 - SECURITY & SCHEMAS: DATABASE AUDITING

  • Auditing Database Activity
  • Traditional Auditing
  • Unified Auditing
  • Create Audit Policy

13 - SECURITY & SCHEMAS: SQL LOADER

  • Loader Concepts
  • Loader From the Command Line
  • control File Options
  • Load Methods
  • Loader Express Mode
  • Loader From EM

14 - SECURITY & SCHEMAS: EXPORT & IMPORT

  • Manage Directory Objects
  • The Data Pump Architecture
  • Data Pump Export
  • Data Pump Import
  • Data Pump Dictionary Views
  • Using the EM CC Interface

15 - PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING

  • Management Advisory Framework
  • Performance Monitoring & AWR
  • The SQL Tuning Advisor
  • Monitoring Exceptions with Metrics

16 - PERFORMANCE & AVAILABILITY: DATA CONCURRENCY

  • About System & User Locks
  • Monitor & Manage User Locks
  • Monitor Locks with Data Dictionary
  • Manage Locks with EM

17 - PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS

  • Backup & Recovery Structures
  • Managing REDO Data
  • Configuring for Recoverability
  • Instance Recovery
  • Recoverability Checklist
Contact Information

Eco Bank Towers, 4th Floor Muindi Mbingu Street
P. O. Box 21857 - 00100 Nairobi

Mob: +254 780 342 333, +254 202 246145, 2246154