Oracle Database 11g Administration I

Course:  OR11A1
Duration:  5 Days
Level:  I
Course Summary

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 and Oracle technical support staff such as Unix/Linux/Windows administrators. Oracle Database 11g: Administration I class enables the DBA and other technical support to acquire and develop skills to effectively and holistically administer an Oracle11g RDBMS from top to bottom. A great option of this class is that it can be customized to be delivered on either a Windows or Unix/Linux OS platform to suit the client???s needs. The overall objective of this course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. This course sets the foundation for advanced administrator training and certification.

« Hide The Details
Topics Covered In This Course

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

Installation of Oracle11g

  • More About the Installation
  • Start the Installation
  • Desktop Class Installation of 11GR2
  • Server Class Installation of 11GR2
  • Post-Installation configuration

Verifying the Installation

  • Accessing the EM Database Control
  • Using the EM Interface
  • Using SQL*Plus
  • Using EM SQL Worksheet
  • Using SSH

Upgrade, De-installation &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

  • 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 Database Files

Enabling Transparent Data Encryption

  • Transparent Data Encryption
  • Managing TDE
  • Implementing Column Encryption

Manage Database Storage Structures

  • About Tablespaces
  • Tablespace Management
  • AUTOEXTEND Options
  • DROP Tablespace
  • ALTER Tablespace

Manage Database Storage Structures: Advanced

  • 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
  • Enabling 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 Space Advisor

Oracle Network Environnent: Oracle NET Services

  • Oracle NET Services Architecture
  • Oracle NET Configuration Assistant
  • Oracle NET Manager
  • Configuration Using EM
  • Troubleshooting Network Problems
  • Countering Database Attacks

Oracle Network Environnent: Oracle Shared Servers

  • Shared Server 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

  • Oracle NET Services Architecture
  • 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
  • The WITH ADMIN Option
  • 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 Data Pump Architecture
  • Data Pump IMPORT
  • Data Pump Dictionary Views
  • Using the EM Interface

Database Maintenance &Performance Monitoring

  • Management &Advisory Framework
  • Manage Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Using Metrics and Alert Thresholds
  • Automatic Maintenance Tasks

Managing Concurrency and Locks

  • About LOCKS and LATCHES
  • Manage and 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 and Configuration

  • About Backups &Recovery Structures
  • Managing REDO Data
  • Managing Archival Data
  • Automatic Crash Recovery
  • Creating a Basic Backup Strategy
What You Can Expect

Oracle Database 11g: Administration I class enables the student participants to acquire and develop key skills to effectively administer an Oracle11g RDBMS. The participants will learn to configure and start up the Oracle instance and memory components and create the Oracle database Enterprise Manager repository. The student participants will create physical and logical database objects, utilize many of the advanced features of the Oracle Enterprise Manager and the integrated Oracle Data Dictionary to monitor and maintain the Oracle11g database. In addition, they will be introduced to Oracle Backup and Recovery using the RMAN utility and also learn how to secure access to the Oracle database objects with privileges, roles and profiles. Many exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

Who Should Take This Course

Database Administrators

Web Server Administrators

System Administrators

Data Center Support Engineers

Senior application designers and developers

Recommended Prerequisites

Oracle Database: SQL Fundamentals

Oracle Database: SQL-PL/SQL Fundamentals

Relational Database Design and Concepts

Training Style

Instructor Led with typically 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
OBIAD
Oracle BI 11g - System Administration
4 Days
I
Details
OR1212NF
Oracle12c Release 1 & 2 New Features For Administrators
5 Days
I
Details
OR12NEW
Oracle12c New Features For Administrators
5 Days
II
Details
OR11A2
Oracle Database 11g Administration II
5 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com