Skip Ribbon Commands
Skip to main content

ORA11g201 - Oracle Database 11g R2: Administration I

Price:

Duration: 5 Days

Audience:

Level:

Technology:

Delivery Method:

Software Assurance Value:

Microsoft CPE:

Course Information

Course Description

​The overall objective of this course is to allow the student to gain the skills necessary for day-today 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

Course Objectives

​Specific subject areas to be explored and objectives to be reached are:


Software installation and the creation of new databases.

An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.

Management of database files.

Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.

Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.

Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.

Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.

Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.

Control over database support services, including the Database Control, Oracle Net and others.

A primer on backup and recovery structures and strategies.

Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.

Course 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.

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

Course Prerequisites

​The following courses are mandatory prerequisites for this course:


ora11g001, Oracle Database 11G: SQL Fundamentals � Complete Library

ora11g101, Oracle Database 11G: Program with PL/SQL � Complete Library


Course Schedule
This course is not scheduled yet.