Description The goal of this course 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 students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses.
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
Objectifs
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
SOMMAIRE
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
