Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Oracle Database 10g: Administration I Training

Oracle Database 10g: Administration I Training

Course#: WA1380

The overall objective of this course is to allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

Objectives

Major tasks to be considered are:

  • Software installation and the creation of new databases.
  • An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
  • Management of database files.
  • Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  • Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
  • Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
  • Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
  • Control over database support services, including iSQL*Plus, the Database Control, Oracle Net and others.
  • A primer on backup and recovery structures and strategies.
  • Operating system-specific considerations for Unix, Linux and MS Windows.

Audience

The target audience for this course is Oracle database administrators. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface.

Prerequisites

  Mandatory prerequisites for this course are the following courses:

  • ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY
  • ORACLE DATABASE 10G: PROGRAM WITH PL/SQL – PART II

Duration

Five days.

Outline of WA1380 Oracle Database 10g: Administration I Training

  1. INSTALLING ORACLE 10G DATABASE SOFTWARE

  • IDENTIFY DATABASE SYSTEM REQUIREMENTS
  • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
  • CONFIGURE THE INSTALLATION ENVIRONMENT
  • INSTALLATION USING THE UNIVERSAL INSTALLER
  • MORE ABOUT ENTERPRISE MANAGER

  2. EXPLORING THE ORACLE DATABASE ARCHITECTURE

  • GENERAL DATABASE ARCHITECTURE
  • DATABASE INSTANCE MEMORY ARCHITECTURE

  3. DATABASE INSTANCE PROCESS ARCHITECTURE

  • ABOUT THE INSTANCE PROCESS ARCHITECTURE
  • INSTANCE BACKGROUND PROCESSES
  • SQL EXECUTION PROCESSES

  4. CREATING AN ORACLE DATABASE

  • CREATE A DATABASE
  • CONFIGURE & DROP A DATABASE
  • MANAGE DBCA TEMPLATES
  • MANUALLY CREATING A DATABASE

  5. CONTROLLING THE DATABASE ENVIRONMENT

  • STARTING & STOPPING DATABASE CONTROL
  • STARTING & STOPPING ISQL*PLUS
  • STARTING & STOPPING THE DATABASE LISTENER
  • STARTING & STOPPING THE DATABASE
  • MORE ABOUT THE DATABASE FILES
  • HANDLING PARAMETER FILES & PARAMETER SETTINGS

  6. STORAGE STRUCTURES: TABLESPACES

  • ABOUT TABLESPACES
  • TABLESPACE MANAGEMENT

  7. STORAGE STRUCTURES: ADVANCED TABLESPACES

  • MORE ABOUT TEMPORARY TABLESPACES
  • ABOUT TEMPORARY TABLESPACE GROUPS
  • MORE ABOUT PERMANENT TABLESPACES
  • MORE ABOUT BIGFILE TABLESPACES
  • MORE ABOUT THE SYSAUX TABLESPACE

  8. STORAGE STRUCTURES: DATA FILES & TEMP FILES

  • MANAGING DATA FILES
  • MANAGING TEMP FILES
  • ABOUT ORACLE-MANAGED FILES (OMF)

  9. UNDO MANAGEMENT

  • ABOUT UNDO SPACE MANAGEMENT
  • CONFIGURE UNDO MANAGEMENT
  • GUARANTEE UNDO RETENTION
  • MONITOR UNDO SPACE
  • USE THE UNDO ADVISOR

  10. DATABASE SECURITY

  • DATABASE SYSTEM PRIVILEGES
  • DATABASE OBJECT PRIVILEGES
  • AUDIT DATABASE ACTIVITY
  • REGISTER FOR SECURITY UPDATES

  11. ADMINISTERING USERS

  • CREATE & MANAGE DATABASE ACCOUNTS
  • GRANT & REVOKE DATABASE PRIVILEGES
  • RESOURCE LIMITS VIA PROFILES
  • PASSWORD MANAGEMENT VIA PROFILES
  • ABOUT ROLE-BASED SECURITY

  12. MANAGING DATA: LOADING DATA WITH SQL LOADER

  • ABOUT THE DATABASE UTILITIES
  • USING THE LOADER
  • UNDERSTANDING THE LOADER PROCESS
  • CONTROL FILE OPTIONS
  • DIRECT PATH LOADS

  13. MANAGING DATA: EXPORTING & IMPORTING DATA

  • CREATE DIRECTORY OBJECTS
  • EXPDP
  • IMPDP

  14. ORACLE NET SERVICES

  • WHAT IS ORACLE NET SERVICES?
  • ORACLE NET MANAGER
  • LISTENER CONFIGURATION
  • LISTENER ADMINISTRATION
  • LSNRCTL COMMANDS
  • CONFIGURING CLIENT PARAMETERS
  • ISOLATING THE PROBLEM
  • ORACLE TRACE ASSISTANT
  • NETWORK TROUBLESHOOTING UTILITIES

  15. ORACLE SHARED SERVERS

  • SHARED SERVERS ARCHITECTURE
  • CONFIGURATION OF SHARED SERVER MODE

  16. MONITORING & RESOLVING LOCK CONFLICTS

  • ABOUT LATCHES & LOCKS
  • MORE ABOUT LATCHES
  • MORE ABOUT LOCKS

  17. BACKUP & RECOVERY CONCEPTS

  • ABOUT DATABASE BACKUP & RECOVERY
  • ABOUT REDO DATA
  • REDO LOG FILE MAINTENANCE
  • MANAGING THE ARCHIVE OPTIONS
  • MORE ABOUT THE CONTROL FILE
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.