ORACLE DATABASE 11G R2: ADMINISTRATION I– GTD8

Course Description

Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.

^^

Duration

5 days

^^

Target Audience

The primary audiences for this course are:

  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data centre support engineers
  • Senior application designers and developers

^^

Course Prerequisites

Those who wish to attend this course require attendance of the courses below, similar courses, or have the equivalent experience.

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

^^

Course Content

CONFIGURING THE SERVER FOR INSTALLATION

• IDENTIFY SYSTEM REQUIREMENTS

• OPTIMAL FLEXIBLE ARCHITECTURE (OFA)

• ORACLE_BASE

• ORACLE_HOME

• CONFIGURE LINUX INSTALLATION

• CONFIGURE MS WINDOWS INSTALLATION

• PREREQUISITE CHECKS & FIXUP UTILITY

 

ENTERPRISE EDITION INSTALLATION

• MORE ABOUT THE INSTALLATION

• START THE INSTALLATION

• DESKTOP CLASS INSTALLATION 11G R2

• SERVER CLASS INSTALLATION 11G R2

• POST-INSTALLATION CONFIGURATION

 

VERIFY THE INSTALLATION

• ACCESSING THE EM DATABASE CONTROL

• USING THE EM INTERFACE

• USING SQL*PLUS

• USING EM SQL WORKSHEET

• USING SSH

UPGRADE, DEINSTALLATION & PATCHING

• DATABASE UPGRADE

• NETCA

• DBUA

• ONLINE PATCHING

• ORACLE DEINSTALLER

MANUALLY STARTING & STOPPING DATABASE SERVICES

• STARTING & STOPPING DATABASE CONTROL

• STARTING & STOPPING THE LISTENER

• STARTING & STOPPING THE DATABASE

• SYSDBA

 

EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL

• THE ORACLE ENTERPRISE ARCHITECTURE

• GENERAL DATABASE ARCHITECTURE

• V$VERSION

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY

• MORE ABOUT DATABASE INSTANCES

• Using V$SGA_DYNAMIC_COMPONENTS

• ABOUT THE PGA

• MANAGING MEMORY

EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES

• INSTANCE BACKGROUND PROCESSES

• SQL EXECUTION PROCESSES

• Using V$SESSION

 

CREATING AN ORACLE DATABASE

• CREATE A NEW DATABASE

• CONFIGURE AN EXISTING DATABASE

• DROP A DATABASE

• MANAGE DBCA TEMPLATES

• MANUALLY CREATE A DATABASE

• MORE ABOUT THE DATABASE FILES

ENABLING TRANSPARENT DATA ENCRYPTION

• TRANSPARENT DATA ENCRYPTION

• MANAGING TDE

• IMPLEMENTING COLUMN ENCRYPTION

 

MANAGE DATABASE STORAGE STRUCTURES:

TABLESPACES

• ABOUT TABLESPACES

• TABLESPACE MANAGEMENT

• AUTOEXTEND Options

• DROP TABLESPACE

• ALTER TABLESPACE

MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES

• MORE ABOUT TEMPORARY TABLESPACES

• Using V$SORT_SEGMENT

• ABOUT TEMPORARY TABLESPACE GROUPS

• MORE ABOUT PERMANENT TABLESPACES

• About DATABASE_PROPERTIES

• 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 UNDO MANAGEMENT

• UNDO_MANAGEMENT

• UNDO_TABLESPACE

• UNDO_RETENTION

• GUARANTEE UNDO RETENTION

• MONITOR UNDO SPACE

• USE THE UNDO ADVISOR

NETWORK ENVIRONMENT: ORACLE NET SERVICES

• ORACLE NET SERVICES ARCHITECTURE

• ORACLE NET CONFIGURATION ASSISTANT

• ORACLE NET MANAGER

• CONFIGURATION USING EM

• TROUBLESHOOTING NETWORK PROBLEMS

• COUNTERING DATABASE ATTACKS

 

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

• AUDITING OF DATABASE ACTIVITY

• AUDIT_TRAIL Parameter

• 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

• WITH ADMIN OPTION & System Privileges

• WITH GRANT OPTION & Object Privileges

• ALTER USER…DEFAULT ROLE

• SET ROLE

• ENHANCED DEFAULT SECURITY SETTINGS

• SEC_CASE_SENSITIVE_LOGON Setting

 

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 IMPORT

• DATA PUMP DATA DICTIONARY VIEWS

• USING THE EM INTERFACE

DATABASE MAINTENANCE & PERFORMANCE MONITORING

• MANAGEMENT & ADVISORY FRAMEWORK

• MANAGE AWR

• ADDM

• USE METRICS & ALERT THRESHOLDS

• AUTOMATIC MAINTENANCE TASKS

 

MANAGING CONCURRENCY & LOCKS

• ABOUT LATCHES & LOCKS

• MANAGE & MONITOR LATCHES

• 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 BACKUP & RECOVERY STRUCTURES

• MANAGING REDO DATA

• MANAGING ARCHIVAL DATA

• AUTOMATIC CRASH RECOVERY

• CREATING A BASIC BACKUP STRATEGY

© 2011 Sideris Courseware Corporation

^^

See more Database Technologies courses