ORSYS formation
CONTACT - +352 26 49 79 1204
CONTACT - 📞 +352 26 49 79 1204    drapeau francais   drapeau anglais

Consult our trainings :

Oracle 12c, administration Training

Stage pratique
Best
Duration : 5 days
Ref : OMD
Price  2020 : 2870 € excl. taxes
Free breaks and lunches
  • Program
  • Cycles certifiants
  • Participants / Prerequisite
  • Intra/Tailored
Program

Instructional goals

Learning objectives

  • Installing the Oracle 12c DBMS
  • Determining the main features of Oracle database administration
  • Creating and managing a database
  • Managing access to users
  • Managing database security.
  • Participants
PROGRAM

» The Oracle 12c architecture and installation

  • Files that constitute the database. Data storage.
  • Memory zones. Background processes.
  • Transaction management.
  • An administrator's tasks.
  • System prerequisites. Installation tasks in Unix.
  • OFA architecture. Using Oracle Universal Installer (OUI).
  • Installation in interactive or silent mode.
  • The RAC architecture.
  • Shared architecture (CDB) and inserted bases (PDB).
  • EM Database Express and SQL Developer.
  • Automatic Storage Management (ASM) architecture.
  • Hands-on work ¤Installing Oracle 12c.

» Creating and deleting databases

  • Understanding and using Oracle Managed Files (OMF).
  • Storage in ASM drive groups.
  • The database configuration assistant.
  • Creating and managing a CDB container and a PDB inserted base.
  • Hands-on work ¤Creating a new database from scripts generated by DBCA.

» Managing the instance and network configuration

  • Identification control methods, SYSDBA, SYSBACKUP, SYSDG, SYSKM.
  • Configuring the instance with PFILE or SPFILE.
  • Options for starting or stopping an instance.
  • Starting and stopping a CDB container and a PDB inserted base.
  • Views: Dynamic, dictionary, and data.
  • Trace files, the alert file, and the ADR repository.
  • Network configuration, Oracle Net Services configuration, service management.
  • Managing an ASM instance and Oracle Restart with crsctl and srvctl.
  • Hands-on work ¤Editing the database's settings. Creating the SPFILE file from a PFILE file. Configuration of SQL*Net to connect a PDB inserted base.

» Managing the control file and the log files

  • Functions of the control file. Its contents.
  • Multiplexing the control file.
  • Creating and managing log files.
  • ARCHIVELOG mode. Archived file management.
  • Hands-on work ¤Multiplexing the control file, viewing its content. Creating and editing the size of log file groups. Updating the database in ARCHIVELOG mode.

» Logical disk space management

  • Creating a permanent, temporary, and undo tablespace.
  • Defining a default permanent, temporary, and undo tablespace.
  • Permanent and temporary tablespace in the shared architecture.
  • Expanding/moving a tablespace in-line.
  • Group of temporary tablespaces and compacting a temporary tablespace.
  • Hands-on work ¤Creating different tablespaces, defining permanent (default), temporary, and undo tablespaces. Creating a temporary tablespace group.

» Database structures

  • The storage structure.
  • Storage parameters of tablespaces.
  • Use of extents.
  • The structure of a database block.
  • BLOB or CLOB data storage.
  • Table storage statistics and information.
  • The High Water Mark and block chaining.
  • Reorganizing unused storage and space.
  • Activity analysis, automatic compression and movement of data.
  • Hands-on work ¤Reorganizing a table. Automatic movement and compression of tables.

» Administering objects

  • External and temporary tables.
  • Index: B*-tree, bitmap and function-based.
  • Index-organized tables (IOT).
  • Partitioning tables, indexes, and IOTs.
  • Materialized views.
  • Hands-on work ¤Creating B*-tree indexes, the bitmap index, and a materialized view.

» Managing undo data

  • Undo segments and the undo data storage period.
  • Ensuring the storage of undo data.
  • Using the Undo assistant.
  • Flashback Database.
  • Flashback Query, Version Query, and Transaction Query.
  • Flashback Archive and use of Flashback Table.
  • Hands-on work ¤Changing the undo data storage mode. Setting the UNDO records of temporary tables in the temporary tablespace.

» Managing users 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.
  • Managing resources in a database.
  • Hands-on work ¤Configuring user rights. Setting up a schema and users to connect and work with this application.

» Add-ons

  • Managing the AWR repository and the ADDM monitor.
  • Defining alert thresholds and using automated tasks.
  • Overview of the Datapump architecture.
  • Implementing audit trails.
Participants / Prerequisite

» Participants

Prerequisites

» Prerequisite

TRAINING PROGRAM
Intra/Tailored

Contact Informations

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).
You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr
By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

Book your place

Click on a session for reserving.

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.
However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.
The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day
linkedin orsys
twitter orsys
it! orsys
instagram orsys
pinterest orsys
facebook orsys
youtube orsys
LA LETTRE DE
LA TRANSFORMATION DIGITALE
Recevez la newsletter