Description

During this intensive and very practical course, you will learn how to implement and administer the Oracle12c DBMS under optimal conditions. Among the main points covered are the architecture of the DBMS, installation, as well as the management of the instance, databases, disk spaces, objects, undo data, users and access rights .

Who is this training for ?

For whom ?

Oracle database administrators, application administrators and consultants.

Prerequisites

Training objectives

Break down the architecture of the Oracle 12c database

Install the Oracle 12c DBMS

Determine the main functionalities of administering an Oracle database

Create and manage a database

Manage user access

Manage security from the database

Training program

• Architecture d'Oracle 12c et installation
  • - Files constituting the database.
  • - Data storage.
  • - Memory areas.
  • - Background processes.
  • - Transaction management.
  • - Tasks of an administrator.
  • - Prerequisites depending on the system.
  • - Installation tasks under Unix.
  • - OFA architecture.
  • - Using Oracle Universal Installer (YES).
  • - Installation in interactive or silent mode.
  • - The architecture RAC.
  • - The shared architecture (CDB) and the inserted databases (PDB).
  • - EM Database Express and SQL Developer.
  • - The architecture Automatic Storage Management (ASM).
  • - Practical work Installation of Oracle 12c.
• Creating and deleting databases
  • - Understanding and using Oracle Managed Files (OMF).
  • - Storage in ASM disk groups.
  • - The Database Configuration Wizard.
  • - The creation and management of a CDB container and a PDB inserted database.
  • - Practical work Creation of a new database from scripts generated by DBCA.
• Instance management and network configuration
  • - Identification control methods, SYSDBA, SYSBACKUP, SYSDG, SYSKM.
  • - Setting the instance with PFILE or SPFILE.
  • - Shutdown options and starting an instance.
  • - Starting and stopping a CDB container and an inserted PDB database.
  • - Views: dynamic, data dictionary.
  • - Trace files, alert file and ADR repository.
  • - Network configuration, Oracle Net Services configuration, service management.
  • - The management of an ASM and Oracle Restart instance with crsctl and srvctl.
  • - Practical work Modifying the database settings.
  • - Create the SPFILE file from a PFILE file.
  • - Configuring SQL*Net to connect a PDB inserted database.
• Managing the control file and log files
  • - The functions of the control file.
  • - Its contents.
  • - Multiplex the control file.
  • - Creating and managing log files .
  • - ARCHIVELOG mode.
  • - Managing archive files.
  • - Practical work Multiplex the control file, view its contents.
  • - Create and modify log file group sizes.
  • - Put the database in ARCHIVELOG mode.
• Managing logical disk spaces
  • - Creating a permanent, temporary and undo tablespace.
  • - Set a default permanent, temporary and undo tablespace.
  • - Permanent and temporary tablespace in the architecture shared.
  • - Enlargement/move a tablespace online.
  • - Group of temporary tablespaces and compaction of a temporary tablespace.
  • - Practical work Creating different tablespaces, setting default permanent, temporary and undo tablespaces.
  • - Create a group of temporary tablespaces.
• Database Structures
  • - The storage structure.
  • - The tablespace storage parameters.
  • - The use of extents.
  • - The structure of a database block.
  • - Storage of BLOB or CLOB type data.
  • - Statistics and table storage information.
  • - The High Water Mark and the block chaining.
  • - Reorganization of storage and unused space.
  • - Analysis of activity, compression and automatic movement of data.
  • - Work practices Reorganizing a table.
  • - Automatically moving and compressing tables.
• Object administration
  • - External and temporary tables.
  • - Index: B
  • - tree, bitmap and function-based.
  • - Tables organized as indexes (IOT).
  • - Partitioning tables, indexes and IOTs.
  • - Materialized views.
  • - Practical work Creation of indexes B
  • - tree, bitmap index and a materialized view.
• Cancellation data management

  - n'as pas encore du programme

• User management and security
  • - Creating a local or common user.
  • - Expiration and logging of passwords.
  • - System and object privileges granted locally or commonly.
  • - Local and common roles.
  • - Profiles.
  • - Manage resources in a database.
  • - Practical work Configuration of user rights.
  • - Setting up a schema and users to connect and work with this application.
• Supplements
  • - Manage the AWR repository and ADDM monitor.
  • - Set alert thresholds and use automated tasks.
  • - Datapump architecture overview.
  • - Implementing audit trails.