Description

This course is essential for anyone who wants to improve their skills in Oracle 12c database administration. It will allow them to implement advanced functionalities, including shared architecture management, task scheduling and database resource management.

Who is this training for ?

For whom ?

Oracle 12c database administrators, application administrators, system administrators and consultants.

Prerequisites

Basic knowledge of Oracle 12c administration or equivalent.

Training objectives

Deep your knowledge of Oracle SDBG administration

Evaluate the advanced features of Oracle SDBG administration

Configure and start a database remotely

Manage a database with EM Cloud Control

Create a CDB container

Put implement a monitoring strategy

Training program

• Introduction and reminders
  • - Automated installation by response file, application of patches.
  • - Create and manage basic services.
  • - Using DBMS_JOB and DBMS_SCHEDULER.
  • - Practical work Create a service and a service start trigger.
  • - Schedule a task.
• EM and other tools
  • - Remote listener and connection filtering.
  • - EM Cloud Control, EM Database Express and SQL Developer.
  • - Configuring network compression.
  • - Practical work Configure and start a DB remotely.
  • - Manage the DB with EM Cloud Control.
• Shared architecture
  • - Creating a CDB container database.
  • - Create, clone and delete a PDB database.
  • - Move a PDB database from one CDB container to another.
  • - Manage tablespaces, users and privileges.
  • - Practical work Move a PDB database to a CDB container.
• Advanced monitoring
  • - Automatic Diagnostic repository and ADRCI.
  • - Trace DDL orders.
  • - Set alert thresholds and use alerts.
  • - Implementation unified audit strategies.
  • - Monitor database operations.
  • - Protection by obfuscation.
  • - Practical work Setting up an audit strategy.
• Maintenance
  • - Monitoring used space and storage structures.
  • - Analyze database activity.
  • - Automatic moving and compression.
  • - Archiving in the database.
  • - Practical work Automatically move and compress tables and partitions.
• Resource Manager
  • - Configuring Database Resource Manager.
  • - Create a new resource allocation plan.
  • - Active session pool and maximum execution time.
  • - Create groups of resource consumers.
  • - Manage resources between PDB databases.
  • - Practical work Creation of a resource plan.
• Grid Infrastructure (ASM)
  • - ASM architecture, features, and installation.
  • - Instance and disk group management.
  • - Oracle Restart.
  • - Exercise: Migrating a database to ASM.
• Table partitioning
  • - Partitioning by interval, system, virtual column, reference and composite.
  • - Managing partitioned tables.
  • - Exercise: Creating partitioned tables/indexes .