In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties
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 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
Moitor 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
