Description

What you need to know to operate Oracle 9i/10g/11g in the best conditions of efficiency and security. This course will allow you to master the main mechanisms of Oracle, the basics of SQL and SQL Plus languages, startup processes and backup and import/export techniques.

Who is this training for ?

For whom ?

IT professionals wishing to guarantee reliable and efficient operation of Oracle.

Prerequisites

Training objectives

Training program

• Introduction
  • - Oracle environment.
  • - File types used.
  • - Valid processes.
  • - Tablespaces.
  • - Dictionary .
  • - File types used.
  • - Valid processes.
  • - Tablespaces.
  • - Dictionary.
  • - Tasks 'operation: monitoring instances, recovering error messages.
  • - Required tools.
  • - Presentation of SQL.
  • - Validation of scripts.
  • - Using SQL*Plus in operation.
  • - Recovering the structures of a DB.
• User concept
  • - User characteristics.
  • - Recovery of login names, privileges and roles.
  • - Unlock a user account.
  • - Stopping a blocked connection.
  • - Monitoring locks.
  • - Privileged users.
  • - SYS and SYSTEM.
  • - Using groups sysoper and sysdba.
• Management of storage structures
  • - OFA architecture.
  • - Tablespaces.
  • - Find the storage structures of a base and the occupancy rate.
  • - Segments of rollback/undo.
  • - Identifying and monitoring rollback segments/undo.
• Starting and stopping the database
  • - Base states.
  • - Use of the various states.
  • - Startup.
  • - Files implemented at startup.
  • - Troubleshooting.
  • - Automatic procedures.
  • - Shutting down.
  • - Monitoring established connections.
• Network access
  • - For the server and clients.
  • - Activation of the SQL*Net/Net layer on the server.
  • - Configuration files.
  • - Startup scripts.
  • - Testing the connection.
• Network access
  • - For the server and clients.
  • - Activation of the SQL*Net/Net layer on the server.
  • - Configuration files.
  • - Startup scripts.
  • - Testing the connection.
• Backups and restores
  • - Backup types.
  • - Cold backup of a database.
  • - Archive mode.
  • - Test for presence of archive mode.
  • - Files to save for a hot backup.
  • - Hot backup.
  • - Recovery of error messages when activating the database.
  • - Identifying/restoring corrupted files.
  • - RECOVER function.
• Fonctions import/export et SQL*Loader
  • - EXPORT to save a schema, a database.
  • - Loading tables.
  • - Message files.
  • - Load processing .
  • - Constraints.
• Oracle 11g specifics
  • - Performance.
  • - Simplified maintenance.
  • - Security.
  • - Oracle Restart.
  • - Data Recovery Advisor and RMAN enhancements.
  • - Database migration.