back to Course Categories | back | print
Managing Oracle10g for the Small/Medium Sized Business          

Duration: 3 days

Description 
This class will teach attendees the fundamental skills for managing an Oracle database environment. Students will learn now to install Oracle software, setup a new database, manage users, manage storage, manage security, add software patches and the management of data. The emphasis is on teaching someone new to an Oracle environment how to successfully manage an Oracle database. The Oracle Installer and Oracle Enterprise Manager (OEM) wizards and graphical user interfaces will be used to simply the introduction to an Oracle environment. By the end of class attendees will have gone through the main tasks required to manage an Oracle database environment. This is the ideal class for new database administrators who need to be able to perform basic administration on an Oracle10g database.

Topics

  • Understanding the Oracle environment
  • The main components of an Oracle Server
  • Oracle concepts and terminology
  • Oracle memory and programs
  • Components of an Oracle database
  • Oracle networking software
  • Overview of Oracle products and tools
  • Installing an Oracle database
  • The Oracle Universal Installer
  • Installation options
  • Steps for creating an Oracle database
  • Defining installation options
  • Creating the Oracle database
  • Validating the installation
  • Using OEM for database management
  • Features of the Oracle Enterprise Manager (OEM)
  • Using OEM to manage your Oracle environment
  • Main components of OEM
  • The OEM Central Console
  • The OEM Web Site
  • Starting up an Oracle instance and database
  • Shutting down an Oracle instance and database
  • Managing memory and the Oracle instance
  • Using OEM to manage Oracle memory
  • Changing Oracle memory and configurations
  • Using an Oracle dedicated server
  • Using an Oracle shared server
  • Performing normal maintenance on an Oracle instance
  • Configuring the Oracle database: spfile, datafiles, control files and redo log files
  • Understanding an Oracle database with OEM
  • Database configuration options
  • Setting up data files
  • Setting up control files
  • Setting up redo log groups
  • Mirroring redo log files
  • Managing storage
  • Data files versus tablespaces
  • Adding data files
  • Modifying data files
  • Adding/removing control files
  • Adding/removing redo log groups
  • Adding/removing redo log files
  • Configuring the self managing database
  • Automatic Memory Management
  • Simple versus complex parameters
  • Setting up automatic tuning
  • Automatic maintenance tasks
  • Data and Schema Management
  • Managing tables
  • Managing indexes
  • Understanding schemas
  • Normal maintenance on tables
  • Normal maintenance on indexes
  • Loading and extracting data
  • Oracle utilities
  • Understanding Data Pump
  • Loading/extracting data
  • SQL Loader
  • Performance tuning
  • Using Oracle advisories
  • Advisory central
  • What to look out for
  • How to fix it
  • Troubleshooting
  • Normal maintenance
  • What can go wrong
  • Troubleshooting techniques
  • Backing up an Oracle database
  • Backup options
  • Cold backups
  • Hot backups
  • Using OEM for backup and recovery
  • Backup/recovery fundamentals

Prerequisites

  • Attendees must have a fundamental understanding of computers, operating systems, computer environments and the SQL programming language.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design