Oracle Administration Training: Oracle 11g Administration I

Course Number: ORC-204
Duration: 5 days
view class outline

Oracle 11g Administration Training Overview

This Oracle 11g administration training course teaches attendees the skills necessary for day-to-day administration of Oracle^® 11g.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=oracle.

Oracle 11g Administration Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 11g Administration Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

A complete installation of Oracle 11g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 11g Administration Training Objectives

All attendees will learn how to:

Configure the Linux and MS Windows operating systems in anticipation of a database installation
Install Oracle 11g R2 Enterprise Edition database
Verify a valid database installation
Use database administrator interface options
Uninstall the database
Patch online software
Startup and shutdown database services and related software components
Use super administrator authentication options
Explore the database architecture, including memory, process and data structures, and the management of those structures
Manage database files.
Use specialized facilities intended to maximize performance of enterprise-scale transactional applications
Manage security policies and procedures, including administration of user accounts, roles, privileges and profiles
Use advanced self-tuning and self-management capabilities
Monitor preformance, troubleshoot problems, and resolve lock and conflict issues
Use the Oracle Enterprise Manager and SQL interfaces for administration tasks
Gain gontrol over database support services, including the Database Control, Oracle Net and others
Backup and recover
Operate system-specific considerations for various platforms, especially Linux and MS Windows

Oracle 11g Administration Training Outline

Introduction

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 and 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 and Patching

Database Upgrade
Netca
Dbua
Online Patching
Oracle Deinstaller

Manually Starting and Stopping Database Services

Starting and Stopping Database Control
Starting and Stopping The Listener
Starting and 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 and 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 and 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 and Manage Database Accounts
Grant and 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 and System Privileges
With Grant Option and 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 and Import

Manage Directory Objects
About The Data Pump Architecture
Data Pump Import
Data Pump Data Dictionary Views
Using The Em Interface

Database Maintenance and Performance Monitoring

Management and Advisory Framework
Manage Awr
Addm
Use Metrics and Alert Thresholds
Automatic Maintenance Tasks

Managing Concurrency and Locks

About Latches and Locks
Manage and Monitor Latches
V$Lock
V$Locked_Object
V$Session
V$Session_Wait
Dba_Blockers and Dba_Waiters
Dba_Dml_Locks and Dba_Ddl_Locks
Dml_Locks

Backup and Recovery Concepts and Configuration

About Backup and Recovery Structures
Managing Redo Data
Managing Archival Data
Automatic Crash Recovery

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.