Základní info
The goal of this Oracle Database 10g: 2 Day DBA Release 2 training is to teach Database Adminstrators how to install the Oracle Database software and perform the tasks required to manage an Oracle database. Enterprise Manager is used exclusively throughout to teach you how to quickly accomplish the required task.Learn To:Install the database.Monitor and tune the database.Navigate in the EM.Manage the Oracle Instance.Perform backup and recovery.Administer users and security.Benefits to YouEnsure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.Ideal for Database AdministratorsExpert Oracle University instructors will emphasize the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses.
Audience:
- Database Administrators
- SAP Administrator
- Sales Consultants
Objectives:
- Installing the Oracle Database software and creating a database
- Using Enterprise Manager Database Control to manage the database
- Configuring and managing the Oracle Network environment
- Managing database storage structures
- Administering users and security
- Managing schema objects
- Backing up and recovering the Oracle database
- Monitoring the database and using the Advisors
- Updating Oracle software with patch releases
- Tuning the database
Topics:
Overview of Oracle Database Administration
- Overview of the Oracle Instance and Database
- Tasks of an Oracle Database Administrator
- Tools Used to Administer an Oracle Database
Installing Oracle Software and Creating the Database
- Using the Oracle Universal Installer (OUI)
- Installation Pre-requisites
- Installing the Oracle Software
- Using the Database Configuration Assistant (DBCA) to Create a Database
- Using DBCA to Manage Templates
- Using DBCA to Add Options to Your Database
Using Oracle Enterprise Manager Database Control and SQL*Plus
- Overview of Administering the Database Using Enterprise Manager (EM)
- Starting the EM Database Console
- Enterprise Manager Navigation
- Granting EM Administrative Privileges
- Using SQL*Plus and iSQL*Plus to Access Your Database
Configuring the Oracle Network Environment
- Network Configuration Overview
- Oracle Net Listener Configuration and Management
- Oracle Net Naming Methods
- Tools for Configuring and Managing the Oracle Network
Managing the Oracle Instance
- Oracle Instance and Instance Management
- Accessing the Oracle Database
- Initialization Parameters and Password File
- Starting Up and Shutting Down the Instance
- Viewing the Alert Log and Trace Files
Managing Database Storage Structures
- Oracle Database Structures
- Creating a New Tablespace
- Managing Undo and Using the Undo Advisor
- Multiplexing the Redo Log File
Administering Users and Security
- Overview of Users and Security
- Creating and Administering Users
- Locking and Unlocking Accounts
- Setting Passwords
- Administering Privileges and Roles
Managing Schema Objects
- Creating Schema Objects
- Creating and Modifying Tables
- Understanding Data Integrity and Defining Constraints
- Viewing the Attributes and Contents of a Table
- Creating Indexes and Views
- Loading Data
Performing Backup and Recovery
- Backup, Restore and Recovery Concepts
- Configuring the Database for Backup and Recovery
- Configuring Backup Settings
- Backing Up the Database Using EM
- Whole Database Backups
- Oracle-Suggested Backup Strategy
- Restoring and Recovering the Whole Database
Monitoring and Tuning the Database
- Monitoring the Oracle Database
- Self-Monitoring Architecture
- Monitoring and Tuning Usage Model
- Using the Advisors
Managing Oracle Software
- Working with Oracle Support
- Search MetaLink
- Logging TARs
- Applying a Patch Release
