Oracle 11g Administration I

Oracle 11g Administration I

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

ORACLE ADMINISTRATION TRAINING OBJECTIVES

• 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 ADMINISTRATION TRAINING PREREQUISITES

No prior experience is presumed.

ORACLE ADMINISTRATION TRAINING MATERIALS

All students receive comprehensive courseware and a related textbook.

SOFTWARE NEEDED FOR EACH PC:

• A complete installation of Oracle Enterprise Edition 11g or 11g R2
• Oracle SQL Developer
• For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

ORACLE 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