Visão Geral

Neste Curso Oracle Database 19C Administration I, você aprenderá sobre a experiência prática do administrador de banco de dados Oracle na administração, monitoramento, ajuste e solução de problemas de um banco de dados Oracle.

Por meio de uma estrutura de laboratórios práticos e teóricas interativas, você aprenderá como criar o armazenamento de banco de dados de forma apropriada para os aplicativos de negócios suportados pelo seu banco de dados. Além disso, você aprenderá a criar usuários e gerenciar um banco de dados de segurança para atender aos seus requisitos de negócios. Informações básicas sobre backup e recuperação aninhada de cursor.

Objetivo

Após realizar este Curso Oracle Database 19C Administration I, você será capaz de:

Ter o conhecimento necessário para manter as operações bem sucessivas e eficientes de um banco de dados Oracle. Os alunos ganharão experiência prática na administração e monitoramento de um banco de dados Oracle19c

Publico Alvo

• Administração do Banco de Dados Oracle 19 para qualquer pessoa que precisa gerenciarc, e dar suporte a um banco de dados Oracle.

Pre-Requisitos

• Os participantes devem ter uma compreensão dos conceitos de banco de dados relacionais e bom conhecimento do sistema operacional.
• Ou ter realizado o curso Oracle SQL ou ter bons conhecimentos de Oracle SQL.

Informações Gerais

• Carga horária 32h
• Se noturno este curso e ministrado de segunda-feira a sexta-feira das 19h às 23h, total de 8 noites,
• Se aos sábados este curso e ministrado das 09h às 18h, total de 4 sábados,
• Se integral para empresa consultar disponibilidade

Formato de entrega:

• 100% on-line via Microsoft Teams, na presença de um instrutor/consultor Oracle DBA desde as versões 8i, 9i, 10g, 11g, 12g, atual 19c, além de toda experiência de mercado Oracle DBA, os profissionais são didáticos, experimentam em sala de aula.

Nota:

• Não e curso gravado! o mesmo acontece em tempo real de um instrutor nos dias e definidos na presença de dados da contratação 

LAB Oracle 19c

• Todos os participantes terão acesso a um laboratório individual para realizar todos os exercícios propostos no programático, acompanhados e orientados pelo instrutor em sala de aula.
• Apostila em inglês, aulas ministradas em inglês
• Os acessos ao LAB ORACLE 19c e liberado no dia do curso, mais todos os testes são realizados bem antes do início do curso para evitar o desconforto em sala de aula.

Materiais

Conteúdo Programatico

Introdução ao banco de dados Oracle

1. Objetivos
2. Arquitetura do Oracle Database Server: Visão Geral
3. Oracle Multitenant Container Database: Introdução
4. Oracle Multitenant Container Database: Arquitetura
5. Configurações da instância do banco de dados Oracle
6. Compartilhamento de banco de dados: introdução
7. Servidor de banco de dados Oracle: diagrama de arquitetura interativa

Acessando um banco de dados Oracle

1. Objetivos
2. Conectando-se a uma instância de banco de dados Oracle
3. Ferramentas de banco de dados Oracle
4. Opções de ferramentas de banco de dados
5. SQL*Plus
6. Desenvolvedor Oracle SQL
7. Desenvolvedor Oracle SQL: Conexões
8. Desenvolvedor Oracle SQL: Ações do DBA
9. Assistente de configuração de banco de dados (DBCA)
10. Banco de dados Oracle Enterprise Manager Express
11. Recursos do Enterprise Manager Cloud Control 13c
12. Visão geral do componente Oracle Enterprise Manager
13. Painel único de vidro para gerenciamento empresarial
14. Gerenciamento de banco de dados Oracle Enterprise Manager

Criando um banco de dados Oracle usando DBCA

1. Objetivos
2. Planejando o banco de dados
3. Escolhendo um modelo de banco de dados
4. Choosing the Appropriate Character Set
5. How Are Character Sets Used?
6. Setting NLS_LANG Correctly on the Client
7. Using the Database Configuration Assistant
8. Using DBCA in Silent Mode
9. Practice Overview

Creating an Oracle Database by Using a SQL Command

1. Objectives
2. Creating a Container Database (CDB)
3. Creating a CDB by Using a SQL Command: Example
4. Using the SEED FILE_NAME_CONVERT Clause
5. Using the ENABLE PLUGGABLE DATABASE Clause
6. Practice Overview

Starting Up and Shutting Down a Database Instance

1. Objectives
2. Starting the Oracle Database Instance
3. Shutting Down an Oracle Database Instance
4. Comparing SHUTDOWN Modes
5. Opening and Closing PDBs
6. Configuring PDBs to Automatically Open
7. Summary
8. Practice Overview
9.  Module 6: Managing Database Instances
10. Objectives
11. Working with Initialization Parameters
12. Initialization Parameters
13. Modifying Initialization Parameters
14. Viewing Initialization Parameters
15. Working with the Automatic Diagnostic Repository
16. Automatic Diagnostic Repository
17. Viewing the Alert Log
18. Using Trace Files
19. Administering the DDL Log File
20. Querying Dynamic Performance Views
21. Considerations for Dynamic Performance Views
22. Data Dictionary: Overview
23. Querying the Oracle Data Dictionary
24. Practice Overview

Oracle Net Services: Overview

1. Objectives
2. Connecting to the Database Instance
3. Oracle Net Services: Overview
4. Defining Oracle Net Services Components
5. Tools for Configuring and Managing Oracle Net Services
6. Oracle Net Listener: Overview
7. The Default Listener
8. Comparing Dedicated and Shared Server Architecture

Configuring Naming Methods

1. Objectives
2. Establishing Oracle Network Connections
3. Connecting to an Oracle Database Instance
4. Name Resolution
5. Establishing a Connection
6. User Sessions
7. Naming Methods
8. Easy Connect
9. Local Naming
10. Directory Naming
11. Using Database Services to Manage Workloads
12. Creating Database Services
13. Practice Overview

Configuring and Administering the Listener

1. Objectives
2. Review: Oracle Net Services Overview
3. Oracle Net Listener: Overview
4. The Default Listener
5. Configuring Dynamic Service Registration
6. Configuring Static Service Registration
7. Practice Overview

Configuring a Shared Server Architecture

1. Objectives
2. Shared Server Architecture: Overview
3. Comparing Dedicated and Shared Server Architecture: Review
4. Enabling Shared Server
5. Controlling Shared Server Operations
6. SGA and PGA Usage
7. Shared Server Configuration Considerations
8. Summary
9. Practice Overview

Configuring Oracle Connection Manager for Multiplexing and Access Control

1. Objectives
2. Oracle Connection Manager: Overview
3. Oracle Connection Manager Processes
4. Oracle Connection Manager: Architecture
5. Using Filtering Rules
6. Implementing Intranet Access Control
7. Implementing Internet Access Control
8. Using Session Multiplexing
9. Configuring Oracle Connection Manager
10. Configuring the cman.ora File
11. Example of a cman.ora File
12. Configuring Clients
13. Configuring the Database Server
14. Configuring the Database Server for Multiplexing (Optional)
15. Using the Oracle Connection Manager Control Utility
16. Review of Oracle Connection Manager Features
17. Practice Overview

Creating PDBs from Seed

1. Objectives
2. Provisioning New Pluggable Databases
3. Tools
4. Creating a New PDB from PDB$SEED
5. Using the FILE_NAME_CONVERT Clause
6. Using OMF or the PDB_FILE_NAME_CONVERT Parameter
7. Practice Overview

Using Other Techniques to Create PDBs

1. Objectives
2. Cloning Regular PDBs 3Migrating Data from a Non-CDB into a CDB
3. Plugging a Non-CDB into CDB Using DBMS_PDB
4. Replicating a Non-CDB into a CDB by Using GoldenGate
5. Cloning a Non-CDB or Remote PDB
6. Using DBCA to Clone a Remote PDB
7. Plugging an Unplugged Regular PDB into CDB
8. Plugging in a PDB Using an Archive File
9. Cloning Remote PDBs in Hot Mode
10. Near-Zero Downtime PDB Relocation
11. Using DBCA to Relocate a Remote PDB
12. Proxy PDB: Query Across CDBs Proxying Root Replica
13. Creating a Proxy PDB
14. Practice Overview

Managing PDBs

1. Objectives
2. Changing the PDB Mode
3. Modifying PDB Settings
4. Impact of Changing Initialization Parameters
5. Changing Initialization Parameters: Example
6. Using the ALTER SYSTEM Command in a PDB
7. Configuring Host Name and Port Number per PDB
8. Dropping PDBs
9. Practice Overview

Database Storage Overview

1. Objectives
2. Database Storage Architecture
3. Logical and Physical Database Structures
4. Segments, Extents, and Blocks
5. Tablespaces and Data Files
6. Default Tablespaces in a Multitenant Container Database
7. SYSTEM and SYSAUX Tablespaces
8. Types of Segments
9. How Table Data Is Stored
10. Database Block Content
11. Understanding Deferred Segment Creation
12. Controlling Deferred Segment Creation
13. Monitoring Tablespace Space Usage

Creating and Managing Tablespaces

1. Objectives
2. Creating Tablespaces
3. Creating a Tablespace: Clauses
4. Creating Permanent Tablespaces in a CDB
5. Defining Default Permanent Tablespaces
6. Temporary Tablespaces
7. Altering and Dropping Tablespaces
8. Viewing Tablespace Information
9. Implementing Oracle Managed File (OMF)
10. Enlarging the Database
11. Moving or Renaming Online Data Files
12. Examples: Moving and Renaming Online Data Files
13. Practice Overview

Improving Space Usage

1. Objectives
2. Space Management Features
3. Block Space Management
4. Row Chaining and Migration
5. Free Space Management Within Segments
6. Allocating Extents
7. Using Unusable Indexes
8. Using Temporary Tables
9. Creating Global Temporary Tables
10. Creating Private Temporary Tables
11. Table Compression: Overview
12. Table Compression: Concepts
13. Compression for Direct-Path Insert Operations
14. Advanced Row Compression for DML Operations
15. Specifying Table Compression
16. Using the Compression Advisor
17. Resolving Space Usage Issues
18. Reclaiming Space by Shrinking Segments
19. Shrinking Segments
20. Results of a Shrink Operation
21. Managing Resumable Space Allocation
22. Using Resumable Space Allocation
23. Resuming Suspended Statements
24. What Operations Are Resumable?
25. Practice Overview

Managing Undo Data

1. Objectives
2. Undo Data: Overview
3. Transactions and Undo Data
4. Storing Undo Information
5. Comparing Undo Data and Redo Data
6. Managing Undo
7. Comparing SHARED Undo Mode and LOCAL Undo Mode
8. Configuring Undo Retention
9. Categories of Undo
10. Guaranteeing Undo Retention
11. Changing an Undo Tablespace to a Fixed Size
12. Temporary Undo: Overview
13. Temporary Undo Benefits
14. Enabling Temporary Undo
15. Monitoring Temporary Undo
16. Practice Overview

Creating and Managing User Accounts

1. Objectives
2. Database User Accounts
3. Oracle-Supplied Administrator Accounts
4. Creating Oracle Database Users in a Multitenant Environment
5. Creating Common Users in the CDB and PDBs
6. Creating Schema Only Accounts
7. Authenticating Users
8. Using Password Authentication
9. Using Password File Authentication
10. Using OS Authentication
11. OS Authentication for Privileged Users
12. Assigning Quotas
13. Practice Overview

Configuring Privilege and Role Authorization

1. Objectives
2. Privileges
3. System Privileges
4. System Privileges for Administrators
5. Object Privileges
6. Granting Privileges in a Multitenant Environment
7. Granting Privileges: Example
8. Using Roles to Manage Privileges
9. Assigning Privileges to Roles and Assigning Roles to Users
10. Oracle-Supplied Roles
11. Granting Roles in a Multitenant Environment
12. Granting Roles: Example
13. Making Roles More Secure
14. Revoking Roles and Privileges
15. Granting and Revoking System Privileges
16. Granting and Revoking Object Privileges
17. Practice Overview

Configuring User Resource Limits

1. Objectives
2. Profiles and Users
3. Creating Profiles in a Multitenant Architecture
4. Creating Profiles: Example
5. Profile Parameters: Resources
6. Profile Parameters: Locking and Passwords
7. Oracle-Supplied Password Verification Functions
8. Assigning Profiles in a Multitenant Architecture
9. Practice Overvie

Implementing Oracle Database Auditing

1. Objectives
2. Database Security
3. Monitoring for Compliance
4. Types of Activities to be Audited
5. Mandatorily Audited Activities
6. Understanding Auditing Implementation
7. Viewing Audit Policy Information
8. Value-Based Auditing
9. Fine-Grained Auditing
10. FGA Policy
11. Audited DML Statement: Considerations
12. FGA Guidelines
13. Archiving and Purging the Audit Trail
14. Purging Audit Trail Records
15. Practice Overview

Introduction to Loading and Transporting Data

1. Objectives
2. Moving Data: General Architecture
3. Oracle Data Pump: Overview
4. Oracle Data Pump: Benefits
5. SQL Loader: Overview

Loading Data

1. Objectives
2. SQL Loader: Review
3. Creating the SQL*Loader Control File
4. SQL*Loader Loading Methods
5. Protecting Against Data Loss
6. SQL*Loader Express Mode
7. Using SQL*Loader to Load a Table in a PDB
8. Practice Overview

Transporting Data

1. Objectives
2. Data Pump Export and Import Clients
3. Data Pump Interfaces and Modes
4. Data Pump Import Transformations
5. Using Oracle Data Pump with PDBs
6. Exporting from a Non-CDB and Importing into a PDB
7. Exporting and Importing Between PDBs
8. Full Transportable Export/Import
9. Full Transportable Export/Import: Example
10. Transporting a Database Over the Network: Example
11. Using RMAN to Transport Data Across Platforms
12. RMAN CONVERT Command
13. Transporting Data with Minimum Down Time
14. Transporting a Tablespace by Using Image Copies
15. Determining the Endian Format of a Platform
16. Transporting Data with Backup Sets
17. Transporting a Tablespace
18. Transporting Inconsistent Tablespaces
19. Database Transport: Data Files
20. Transporting a Database
21. Transporting a Database: Conversion
22. Transporting a Database: Example
23. Transporting a Database: Considerations
24. Transporting a Database with Backup Sets
25. Practice Overview

Using External Tables to Load and Transport Data

1. Objectives
2. External Tables
3. External Tables: Benefits
4. ORACLE_LOADER Access Driver
5. ORACLE_DATAPUMP Access Driver
6. External Tables
7. Viewing Information About External Tables
8. Practice Overview

 Automated Maintenance Tasks: Overview

1. Objectives
2. Proactive Database Maintenance Infrastructure
3. Automated Maintenance Tasks: Components
4. Predefined Automated Maintenance Task
5. Maintenance Windows
6. Predefined Maintenance Windows
7. Viewing Maintenance Window Details
8. Automated Maintenance Tasks
9. Summary

 Automated Maintenance Tasks: Managing Tasks and Windows

1. Objectives
2. Configuring Automated Maintenance Tasks
3. Enabling and Disabling Maintenance Tasks
4. Creating and Managing Maintenance Windows
5. Resource Allocations for Automated Maintenance Tasks
6. Changing Resource Allocations for Maintenance Tasks
7. Practice Overview

Database Monitoring and Tuning Performance Overview

1. Objectives
2. Performance Management Activities
3. Performance Planning Considerations
4. Database Maintenance
5. Automatic Workload Repository (AWR)
6. Automatic Database Diagnostic Monitor (ADDM)
7. Configuring Automatic ADDM Analysis at the PDB Level
8. Advisory Framework
9. Performance Tuning Methodology

Monitoring Database Performance

1. Objectives
2. Server-Generated Alerts
3. Setting Metric Thresholds
4. Reacting to Alerts
5. Alert Types and Clearing Alerts
6. Database Server Statistics and Metrics
7. Performance Monitoring
8. Viewing Statistics Information
9. Monitoring Wait Events
10. Monitoring Sessions
11. Monitoring Services
12. Practice Overview

Database Processes

1. Objectives
2. Process Architecture
3. Process Structures
4. Database Writer Process (DBWn & BWnn)
5. Log Writer Process (LGWR & LGnn)
6. Checkpoint Process (CKPT)
7. System Monitor Process (SMON)
8. Process Monitor Process (PMON)
9. Process Manager (PMAN)
10. Recoverer Process (RECO)
11. Listener Registration Process (LREG)
12. Manageability Monitor Process (MMON)
13. Archiver Processes (ARCn)
14. Interacting with an Oracle Database: Memory, Processes, and Storage
15. Practice Overview

Managing Memory

1. Objectives
2. Managing Memory Components
3. Shared Pool
4. Database Buffer Cache
5. Redo Log Buffer
6. Large Pool
7. Java Pool
8. Streams Pool
9. Program Global Area (PGA)
10. Managing Memory Components
11. Efficient Memory Usage: Guidelines
12. Automatic Memory Management
13. Monitoring Automatic Memory Management
14. Automatic Shared Memory Management
15. Understanding Automatic Shared Memory Management
16. Oracle Database Memory Parameters
17. Managing the SGA for PDBs
18. Managing the Program Global Area (PGA)
19. Managing the PGA for PDBs
20. Practice Overview

Analyzing SQL and Optimizing Access Paths

1. Objectives
2. SQL Tuning Process
3. Oracle Optimizer
4. Optimizer Statistics
5. Optimizer Statistics Collection
6. Setting Optimizer Statistics Preferences
7. Consultor de Estatísticas do Otimizador
8. Relatório do consultor de estatísticas do otimizador
9. Executando tarefas do consultor de estatísticas do Optimizer
10. Diretivas do plano SQL
11. Planos de Execução Adaptativos
12. SQL Tuning Advisor: visão geral
13. SQL Access Advisor: visão geral
14. SQL Performance Analyzer: visão geral
15. Gerenciando tarefas de ajuste automatizado
16. Visão geral da prática