Oracle Database 11g - Administration II
This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise..
COURSE SCHEDULE
Oracle Database 11g - Administration II
Length Days: 5
Length Hours: 40
The primary audiences for this course are:
-
Database administrators
-
Web server administrators
-
System administrators
-
Implementation specialists
-
Data center support engineers
-
Senior application designers and developers
This course brings database administrators beyond a basic understanding of their duties and to:
- Transfer advanced skills needed to effectively administer an Oracle database installation
- within a large-scale enterprise.
- Automatic database management, monitoring and tuning facilities. Included are automatic
- management of storage space and memory resources within the database and the role of the
- Segment Advisor and Memory Advisors.
- Automatic resumption of database operations even in the face of storage space allocation
- failures and errors.
- Setting metric and alert thresholds for proactive database monitoring.
- Using deferred segment creation to improve performance and establish efficient use of
- space.
- Globalization features within the database to support applications in multiple languages,
- currencies, time zones and countries.
- Utilizing diagnostic sources in troubleshooting database problems and employing the Fault
- Diagnosability Infrastructure, the Database Instance Health monitor and the Support
- Workbench to capture and process fault data.
- Configuring the database to recover from a wide variety of failures. This includes
- configuring redo log files and the Flash or Fast Recovery Area.
- Using Oracle flashback technology to recover from user errors and from database failures,
- including Flashback Data Archive and Flashback Transaction Backout as part of the Oracle
- Total Recall technology.
1 - INSTALLATION AND UPGRADE VOLUME
Configuring the Server for Installation
Enterprise Edition Installation
Verify the Installation
Upgrade, Deinstallation and Patching
2 - VOLUME A
Manually Starting & Stopping Database Services
Exploring the Oracle Database Architecture: General
Exploring the Oracle Database Architecture: Instance Memory
Exploring the Oracle Database Architecture: Instance Processes
Creating an Oracle Database
Enabling Transparent Data Encryption
Manage Databases Storage Structures: TableSpaces
Manage Database Storage Structures: Advanced TableSpaces
Manage Database Storage Structures: Data Files & Temp Files
Managing Undo Data
3 - VOLUME B
Network Environment: Oracle Net Services
Network Environment: Oracle Shared Servers
Security: Implementing Database Security
Security: Administering User Security
Moving Data: SQL Loader
Moving Data: Export & Import
Database Maintenance & Performance Monitoring
Managing Concurrency & Locks
Backup and Recovery Concepts and Configuration
Actual course outline may vary depending on offering center. Contact your sales representative for more information.