Oracle Database 12c: Administration Workshop
Course Description
The overall objective of this course is threefold. First, this course instructs in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the course modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces participants to many of the administration sub-specialties that they might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like.
5 days
Contact us for pricing
Prerequisites
These are recommended prerequisites for this course:- Oracle Database 12c: SQL Fundamentals (Levels I & II)
- Oracle Database 12c: Install & Upgrade Workshop
- Oracle Database 12c: Architecture & Internals
Whenever appropriate this course demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.
Audience
The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:- Database administrators
- Application designers and developers
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Chief Information Officers (CIO) and other information technology (IT) management professionals
INTRODUCTION: MANAGING THE DATABASE INSTANCE
THE DATABASE MANAGEMENT TOOLSEM DATABASE EXPRESS
EM CLOUD CONTROL
SQL DEVELOPER
DATABASE ADMINISTRATION DUTIES
INTRODUCTION: DATABASE ARCHITECTURE REVIEW
DATABASE INSTANCE CONFIGURATIONSMEMORY STRUCTURES
PROCESS STRUCTURES
STORAGE ARCHITECTURE
INTRODUCTION: STARTING & STOPPING DATABSE SERVICES
START & STOP THE DATABASE LISTENERABOUT 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
INTRODUCTION: ORACLE NETWORK ENVIRONMENT
ORACLE NET SERVICES ARCHITECTUREORACLE NET CONFIGURATION ASSISTANT
ORACLE NET MANAGER
USING EM CLOUD CONTROL
ADVANCED NETWORK COMPRESSION
TROUBLESHOOTING NETWORK PROBLEMS
INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT
ABOUT DATABASE DIAGNOSTICSFAULT DIAGNOSABILITY INFRASTRUCTURE
DATABASE INSTANCE HEALTH SNAPSHOT
THE SUPPORT WORKBENCH
PROACTIVE DATABASE HEALTH CHECKS
PACKAGE DIAGNOSTIC DATA
WORKING WITH THE KNOWLEDGE BASE
STORAGE: TABLESPACE MANAGEMENT
STARTER TABLESPACESCREATE 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
STORAGE: ADVANCED TABLESPACE MANAGEMENT
MANAGING TEMPORARY TABLESPACESTEMP TABLESPACE GROUPS WITH EM
TEMP TABLESPACE GROUPS WITH SQL
DEFAULT PERMANENT TABLESPACES
BIGFILE TABLESPACES
MANAGING THE SYSAUX TABLESPACE
STORAGE: DATA FILES & TEMP FILES MANAGEMENT
MANAGE DATA FILES WITH EMACCESS METADATA WITH SQL
MANAGE DATA FILES WITH SQL
MANAGE TEMP FILES
ORACLE-MANAGED FILES (OMF)
STORAGE: UNDO DATA & UNDO TABLESPACES
ABOUT UNDO SPACE MANAGEMENTCONFIGURE UNDO MANAGEMENT
GUARANTEE UNDO RETENTION
MONITOR UNDO SPACE WITH SQL
USE THE EM UNDO ADVISOR
SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES
DATABASE SECURITY PRINCIPLESDATABASE SYSTEM PRIVILEGES
DATABASE OBJECT PRIVILEGES
SUPER ADMINISTRATOR ROLES
PRIVILEGE ANALYSIS
SECURITY & SCHEMAS: USER SECURITY
CREATE & MANAGE USER ACCOUNTSMANAGE 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
SECURITY & SCHEMAS: DATABASE AUDITING
AUDITING DATABASE ACTIVITYTRADITIONAL AUDITING
UNIFIED AUDITING
CREATE AUDIT POLICY
LOADER CONCEPTS
CONTROL FILE OPTIONS
LOAD METHODS
LOADER EXPRESS MODE
LOADER FROM EM
SECURITY & SCHEMAS: EXPORT & IMPORT
MANAGE DIRECTORY OBJECTSTHE DATA PUMP ARCHITECTURE
DATA PUMP EXPORT
DATA PUMP IMPORT
DATA PUMP DICTIONARY VIEWS
USING THE EM CC INTERFACE
PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING
MANAGEMENT ADVISORY FRAMEWORKPERFORMANCE MONITORING & AWR
THE SQL TUNING ADVISOR
MONITORING EXCEPTIONS WITH METRICS
PERFORMANCE & AVAILABILITY: DATA CONCURRENCY
ABOUT SYSTEM & USER LOCKSMONITOR & MANAGE USER LOCKS
MONITOR LOCKS WITH DATA DICTIONARY
MANAGE LOCKS WITH EM
PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS
BACKUP & RECOVERY STRUCTURESMANAGING REDO DATA
CONFIGURING FOR RECOVERABILITY
INSTANCE RECOVERY
RECOVERABILITY CHECKLIST
OracleOracle 12cOracle Database 12cOracle Database AdministrationOracle DBA