Oracle Database 11g R2: Administration I

IT/Networking/Server/Operating Systems
  IT Online Library (1 Year Subscription - $1595.00)
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

This Oracle Database 11g R2: Administration I training class covers the 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.

The primary audiences for this course are database administrators, web server administrators, system administrators, implementation specialists, data center support engineers, and senior application designers and developers.


  1. Configure the Linux and MS Windows operating systems in anticipation of a database installation.
  2. Verifiy a valid database installation
  3. Explore database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH
  4. Explore database deinstallation and inline software patching
  5. Start up and shut down database services and related software components
  6. Learn about super administrator authentication options
  7. Gain an in-depth understanding of the database architecture, including memory, process and data structures, and the management of those structures.
  8. Manage database files.
  9. Explore 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
  10. cache, and other similar components.
  11. Manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  12. Utilize advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
  13. Perform monitoring, problem troubleshooting, and resolving lock and conflict issues.

  1. Configuring the Server for Installation
    1. Identify System Requirements
    2. Optimal Flexible Architecture (OFA)
    5. Configure Linux Installation
    6. Configure MS Windows Installation
    7. Prerequisite Checks and Fixup Utility
  2. Enterprise Edition Installation
    1. More about the Installation
    2. Start the Installation
    3. Desktop Class Installation 11G R2
    4. Server Class Installation 11G R2
    5. Post-installation Configuration
  3. Verify the Installation
    1. Accessing the EM Database Control
    2. Using the EM Interface
    3. Using SQL*Plus
    4. Using EM SQL Worksheet
    5. Using SSH
  4. Upgrade, Deinstallation, and Patching
    1. Database Upgrade
    2. NETCA
    3. DBUA
    4. Online Patching
    5. Oracle Deinstaller
  5. Manually Starting and Stopping Database Services
    1. Starting and Stopping Database Control
    2. Starting and Stopping The Listener
    3. Starting and Stopping the Database
    4. SYSDBA
  6. Exploring the oracle database architecture: General
    1. The Oracle Enterprise Architecture
    2. General Database Architecture
    3. V$VERSION
  7. Exploring the Oracle Database Architecture: Instance Memory
    1. More about Database Instances
    3. About the PGA
    4. Managing Memory
  8. Exploring the Oracle Database Architecture: Instance Processes
    1. Instance Background Processes
    2. SQL Execution Processes
    3. Using V$SESSION
  9. Creating an Oracle Database
    1. Create a New Database
    2. Configure an Existing Database
    3. Drop a Database
    4. Manage DBCA Templates
    5. Manually Create a Database
    6. More about the Database Files
  10. Enabling Transparent Data Encryption
    1. Transparent Data Encryption
    2. Managing TDE
    3. Implementing Column Encryption
  11. Manage Database Storage Structures: Tablespaces
    1. About Tablespaces
    2. Tablespace Management
    3. AUTOEXTEND Options
    4. Drop Tablespace
    5. Alter Tablespace
  12. Manage database storage structures: Advanced Tablespaces
    1. More about Temporary Tablespaces
    2. Using V$SORT_SEGMENT
    3. About Temporary Tablespace Groups
    4. More about Permanent Tablespaces
    6. More about Bigfile Tablespaces
    7. More about the SYSAUX TABLESPACE
  13. Manage Database Storage Structures: Data Files and Temp Files
    1. Managing Data Files
    2. Managing Temp Files
    3. Enable Oracle-Managed Files (OMF)
  14. Managing Undo Data
    1. About Undo Space Management
    2. Configure Undo Management
    6. Guarantee Undo Retention
    7. Monitor Undo Space
    8. Use The Undo Advisor
  15. Network Environment: Oracle Net Services
    1. Oracle Net Services Architecture
    2. Oracle Net Configuration Assistant
    3. Oracle Net Manager
    4. Configuration Using EM
    5. Troubleshooting Network Problems
    6. Countering Database Attacks
  16. Network Environment: Oracle Shared Servers
    1. Shared Servers Architecture
    2. Configure Shared Servers
    3. Monitor Shared Servers
    6. V$SESSION
    7. V$CIRCUIT
    9. V$QUEUE
  17. Security: Implementing Database Security
    1. Database System Privileges
    2. Database Object Privileges
    3. Auditing of Database Activity
    4. AUDIT_TRAIL Parameter
    5. Enhanced Default Security Settings
    6. Security: Administering User Security
    7. Create and Manage Database Accounts
    8. Grant and Revoke Database Privileges
    9. Resource Limits via Profiles
    10. Alter Profile
    11. Drop Profile
    12. Password Management via Profiles
    13. About Role-based Security
    14. With Admin Option
    15. With Admin Option and System Privileges
    16. With Grant Option and Object Privileges
    17. Alter USER...DEFAULT Role
    18. Set Role
    19. Enhanced Default Security Settings
  18. Moving Data: SQL Loader
    1. Loader Concepts
    2. Control File Options
    3. Load Methods
    4. Using The EM Interface
  19. Moving Data: Export and Import
    1. Manage Directory Objects
    2. About the Data Pump Architecture
    3. Data Pump Import
    4. Data Pump Data Dictionary Views
    5. Using the EM Interface
  20. Database Maintenance and Performance Monitoring
    1. Management and Advisory Framework
    2. Manage AWR
    3. ADDM
    4. Use Metrics and Alert Thresholds
    5. Automatic Maintenance Tasks
  21. Managing Concurrency and Locks
    1. About Latches and Locks
    2. Manage and Monitor Latches
    3. V$LOCK
    5. V$SESSION
    9. DML_LOCKS
  22. Backup and Recovery Concepts and Configuration
    1. About Backup and Recovery Structures
    2. Managing Redo Data
    3. Managing Archival Data
    4. Automatic Crash Recovery
    5. Creating a Basic Backup Strategy

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.


Class Prerequisites

Experience in the following is required for this Oracle class:

  • Introductory experience with SQL.
  • Experience with Oracle PL/SQL queries

Experience in the following would be useful for this Oracle class:

  • Familiarity with system administration and administration of other non-Oracle databases.

Prerequisite Courses

Courses that can help you meet these prerequisites:

  • Introduction to SQL Training

Course Setup
  • Live Online: Course Setup | WebEx Setup