Visão Geral

Este Curso Oracle Database 12c R2 Install and Upgrade Workshop Ed 2, fornece informações detalhadas para ajudá-lo a instalar o software Oracle Database 12c Release 2. Instrutores especialistas da Oracle ensinarão como criar um banco de dados contêiner e provisionar bancos de dados conectáveis.

Objetivo

Após realizar este Curso Oracle Database 12c R2 Install and Upgrade Workshop Ed 2 você será capaz de:

• Atualizar banco de dados para Oracle Database 12c Release 2
• Crie um banco de dados contêiner
• Instale o Oracle Grid Infrastructure para um Servidor Independente (12.1.0.2.0)
• Configure ASMLIB e crie grupos de discos ASM
• Aplique as atualizações mais recentes do conjunto de patches ao software Grid Infrastructure (12.1.0.2.160719)
• Instale o software Oracle Database 12c Release 2 (12.2.0.0.3)
• Use o Oracle Restart para gerenciar componentes
• Preparar o sistema operacional Linux para instalação do software Oracle
• Instale o Oracle Grid Infrastructure para um Servidor Independente (12.2.0.0.3)
• Instale o software Oracle Database 12c (12.1.0.2.0)
• Crie um banco de dados Oracle usando DBCA
• Instale as atualizações mais recentes do conjunto de patches para o software de banco de dados Oracle (12.1.0.2.160719)

Publico Alvo

• Administrador Técnico
• Administrador de data warehouse
• Administradores de banco de dados
• Engenheiro de suporte

Pre-Requisitos

• Conhecimento básico do sistema operacional Linux
• Conhecimento básico de administração de sistemas Linux
• Conhecimento prático de SQL e uso de pacotes PL/SQL

Materiais

Conteúdo Programatico

Oracle Database 12c R2: Overview

1. Oracle Database Innovation
2. Oracle Database Server Architecture: Overview
3. Process Architecture
4. Database Storage Architecture
5. Oracle Database Memory Structures
6. Objectives
7. Oracle Database Instance Configurations
8. Connecting to the Database Instance

Creating an Oracle Database by Using DBCA

1. Creating a Container Database by Using DBCA
2. Planning the Database
3. Using the DBCA to Create a Database
4. Creating a Database Design Template
5. Choosing the Appropriate Character Set
6. Understanding How Character Sets Are Used
7. Setting the NLS_LANG Initialization Parameter
8. Types of Databases

Migrating Data by Using Oracle Data Pump

1. Creating a New PDB from PDB$SEED
2. Exporting from a Non-CDB and Importing into a PDB
3. Oracle Data Pump: Overview
4. Importing by Using a Network Link
5. Migrating by Using Oracle Data Pump
6. Creating a Container Database by Using DBCA
7. Data Pump Utility: Interfaces and Modes
8. Data Pump Export and Import Clients: Overview

Oracle Software Installation Basics

1. Operating System Groups and Users
2. Environment Variables
3. Configuring the Oracle Software Owner Environment
4. Planning Your Installation
5. Using Oracle Universal Installer (OUI)
6. Installation Option: Silent Mode
7. Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM

Oracle Restart

1. Controlling Oracle Restart
2. Obtaining Help for the SRVCTL Utility
3. Using the SRVCTL Utility
4. Oracle Restart
5. Oracle Restart Configuration
6. Oracle Restart Process Startup
7. Choosing the Correct SRVCTL Utility
8. Starting Components by Using the SRVCTL Utility

Preparing to Upgrade to Oracle Database 12c

1. Requirements for Databases Using Oracle Label Security or Oracle Database Vault
2. Performance Testing
3. Developing a Test Plan
4. Planning the Upgrade
5. Requirement for Databases Using Oracle Warehouse Builder
6. Using the Pre-Upgrade Information Tool
7. Backing Up the Database
8. Preparing to Upgrade

Installing Oracle Grid Infrastructure for a Standalone Server

1. Post Patch steps using Datapatch
2. Determining the latest patch sets available using Oracle Support
3. Patching Using OPatch
4. Upgrading OPatch
5. Patching Using OPlan
6. Patching Using opatchauto
7. Overview of Patching
8. Types of patches

Installing Oracle Database Software

1. Creating Operating System Groups and Users
2. Types of Installations
3. Oracle Database Installation: System Requirements

Introduction to Upgrading to Oracle Database 12c

1. Upgrade Paths
2. Upgrade Method Limitations
3. Database Upgrade Assistant: Advantages and Disadvantages
4. Upgrading to a New Release of Oracle Database
5. Defining Upgrade and Data Migration
6. Upgrade Methods
7. Manual Upgrade: Advantages and Disadvantages
8. Migration Methods

Upgrading to Oracle Database 12c

1. Manually Upgrading to Oracle Database 12c
2. Upgrading by Using the Database Upgrade Assistant (DBUA)
3. Plugging a Non-CDB Database into a CDB
4. Key DBUA Features
5. Migrating a Pre-12.1 or 12.1 Non-CDB to CDB

Performing Post-Upgrade Tasks

1. Understanding Auditing Implementation
2. Recommended Tasks After Database Upgrade
3. Enabling Unified Auditing
4. Required Tasks After Database Upgrade
5. Administering the Roles Required for Auditing