Home /Oracle Database 11g: Administration I

Oracle Database 11g: Administration I

Overview

This Oracle 11g courseware training guide book will allow the student to gain the skills necessary for day-to-day administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

Audience

The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository database using Oracle database technology will also find this information useful. This course is also recommended for technical consultants, support engineers, project managers and other technical management and support personnel.

Prerequisites

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are these titles:

Suggested Next Courses

This course should be considered the first part of the integrated database administrator curriculum. Therefore, in the not-too-distant future one should proceed to the follow-up course

Certification

This course along with its prerequisites cover information necessary to complete the certification test EXAM #1Z1-052 ORACLE DATABASE 11G: ADMINISTRATION I.

Objectives

Major tasks to be considered within this course are:

Course Outline

ENTERPRISE EDITION INSTALLATION
• IDENTIFY SYSTEM REQUIREMENTS
• THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
• ORACLE_BASE
• ORACLE_HOME
• CONFIGURE THE INSTALLATION ENVIRONMENT
• ENTERPRISE EDITION INSTALLATION • DBCA
THE ADMINISTRATOR INTERFACE
• ENTERPRISE MANAGER TOUR
• USING EM SQL WORKSHEET
• DUTIES OF A DATABASE ADMINISTRATOR
• EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL
THE ORACLE ENTERPRISE ARCHITECTURE
EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
• WHAT IS AN ORACLE DATABASE INSTANCE?
• MORE ABOUT THE SYSTEM GLOBAL AREA (SGA)
• ABOUT THE PGA • MANAGING MEMORY
EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
• INSTANCE BACKGROUND PROCESSES
• SQL EXECUTION PROCESSES
CREATING AN ORACLE DATABASE
• CREATE A NEW DATABASE
• CONFIGURE AN EXISTING DATABASE
• DROP A DATABASE
• MANAGE DBCA TEMPLATES
• MANUALLY CREATE A DATABASE
MANAGING THE DATABASE INSTANCE
• CONFIGURING A LINUX ENVIRONMENT
• STARTING & STOPPING DATABASE CONTROL
• STARTING & STOPPING THE DATABASE LISTENER
• STARTING & STOPPING THE DATABASE INSTANCE
• MORE ABOUT THE DATABASE FILES
MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
• ABOUT TABLESPACES
• TABLESPACE MANAGEMENT
• DROP TABLESPACE
• ALTER TABLESPACE
MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
• MORE ABOUT TEMPORARY TABLESPACES
• ABOUT TEMPORARY TABLESPACE GROUPS
• MORE ABOUT PERMANENT TABLESPACES
• MORE ABOUT BIGFILE TABLESPACES
• MORE ABOUT THE SYSAUX TABLESPACE
MANAGE DATABASE STORAGE STRUCTURES
• DATA FILES & TEMP FILES
• MANAGING DATA FILES
• MANAGING TEMP FILES
• ENABLE ORACLE-MANAGED FILES (OMF)
MANAGING UNDO DATA
• ABOUT UNDO SPACE MANAGEMENT
• CONFIGURE AUTOMATIC UNDO MANAGEMENT
• UNDO_MANAGEMENT
• UNDO_TABLESPACE
• UNDO_RETENTION
• GUARANTEE UNDO RETENTION
• MONITOR UNDO SPACE
• USE THE UNDO ADVISOR
NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
• SHARED SERVERS ARCHITECTURE
• CONFIGURE SHARED SERVERS
• MONITOR SHARED SERVERS
• V$SHARED_SERVER
• V$SHARED_SERVER_MONITOR
• V$SESSION
• V$CIRCUIT
• V$DISPATCHER & V$DISPATCHER_CONFIG
• V$QUEUE
SECURITY: IMPLEMENTING DATABASE SECURITY
• DATABASE SYSTEM PRIVILEGES
• DATABASE OBJECT PRIVILEGES
• ADMINISTRATOR AUDITING OF DATABASE ACTIVITY
• ENHANCED DEFAULT SECURITY SETTINGS
SECURITY: ADMINISTERING USER SECURITY
• CREATE & MANAGE DATABASE ACCOUNTS
• GRANT & REVOKE DATABASE PRIVILEGES
• RESOURCE LIMITS VIA PROFILES
• ALTER PROFILE
• DROP PROFILE
• PASSWORD MANAGEMENT VIA PROFILES
• ABOUT ROLE-BASED SECURITY
• WITH ADMIN OPTION
• ALTER USER…DEFAULT ROLE
• SET ROLE
• ENHANCED DEFAULT SECURITY SETTINGS
MOVING DATA: SQL LOADER
• LOADER CONCEPTS
• CONTROL FILE OPTIONS
• LOAD METHODS
• USING THE EM INTERFACE
MOVING DATA: EXPORT & IMPORT
• MANAGE DIRECTORY OBJECTS
• ABOUT THE DATA PUMP ARCHITECTURE
• DATA PUMP EXPORT
• DATA PUMP IMPORT
• DATA PUMP DATA DICTIONARY VIEWS
• USING THE EM INTERFACE
DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT
• THE MANAGEMENT & ADVISORY FRAMEWORK
• MANAGE THE AUTOMATIC WORKLOAD REPOSITORY
• AUTOMATIC DATABASE DIAGNOSTIC MONITOR
• USE METRICS & ALERT THRESHOLDS
• AUTOMATIC MAINTENANCE TASKS
MANAGING CONCURRENCY & LOCKS
• ABOUT LATCHES & LOCKS
• MANAGE & MONITOR LATCHES
• MANAGE & MONITOR LOCKS
• V$LOCK
• V$LOCKED_OBJECT
• V$SESSION
• V$SESSION_WAIT
• DBA_BLOCKERS & DBA_WAITERS
• DBA_DML_LOCKS & DBA_DDL_LOCKS
• DML_LOCKS
BACKUP & RECOVERY CONCEPTS & CONFIGURATION
• ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
• MANAGING REDO DATA
• MANAGING ARCHIVAL DATA
• AUTOMATIC CRASH RECOVERY
• CREATING A BASIC BACKUP STRATEGY