Oracle Database 12c: Install and Upgrade Workshop

Chat

O curso aborda a instalação de software Oracle 12c, bem como a criação de container e pluggable databases, para além de ensinar a fazer upgrade de versões anteriores.

No final da ação de formação, os participantes deverão estar aptos a:

  • Instalar Oracle Grid Infrastructure para um Standalone Server
  • Uso do Oracle Restart
  • Upgrade de uma base de dados para Oracle Database 12c
  • Criar uma container database
  • Criar uma Oracle Database
  • Instalar Oracle Database 12c software

Destinatários

Para quem quer iniciar e saber fazer uma instalação de Base de Dados Oracle.

Pré-Requisitos

Conhecimentos de Linux.

Programa

  • Oracle Database 12c Overview
  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Installing Oracle Database Software
  • Creating an Oracle Database by Using DBCA
  • Using Oracle Restart
  • Introduction to Upgrading to Oracle Database 12c
  • Preparing to Upgrade to Oracle Database 12c
  • Upgrading to Oracle Database 12c
  • Performing Post-Upgrade Tasks
  • Migrating Data by Using Oracle Data Pump

Oracle Database 12c Overview

  • Oracle Database 12c Introduction
  • Oracle Database Architecture Overview
  • Oracle Database Instance Configurations
  • Oracle Database Memory Structures
  • Process Structures
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Container and Pluggable Database Overview

Installing Oracle Grid Infrastructure for a Standalone Server

  • Overview of Oracle Grid Infrastructure for a Standalone Server
  • System Requirements for Oracle Grid Infrastructure
  • Configuring Storage for Oracle Automatic Storage Management (ASM)
  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Upgrading Oracle Grid Infrastructure for a Standalone Server

Installing Oracle Database Software

  • Planning Your Installation
  • System Requirements for Oracle Database
  • Preparing the Operating System
  • Using 4 KB Sector Disks
  • Setting Environment Variables
  • Checking the System Requirements
  • Using the Oracle Universal Installer (OUI)
  • Performing a Silent Mode Installation

Creating an Oracle Database by Using DBCA

  • Planning the Database Storage Structure
  • Choosing non-CDB or CDB
  • Types of Databases (based on workload)
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets are Used
  • Setting the NLS_LANG Initialization Parameter
  • Using the Database Configuration Assistant (DBCA)

Using Oracle Restart

  • Oracle Restart Overview
  • Oracle Restart Process startup
  • Controlling Oracle Restart
  • Choosing the Correct SRVCTL Utility
  • Oracle Restart Configuration
  • Using the SRVCTL Utility
  • Obtaining Help for the SRVCTL Utility
  • Starting Components by Using the SRVCTL Utility

Introduction to Upgrading to Oracle Database 12c

  • Upgrade Methods
  • Data Migration Methods
  • Supported Releases for Direct Upgrade
  • Overview of Upgrade Process
  • Performing a Rolling Upgrade
  • Upgrading a CBD

Preparing to Upgrade to Oracle Database 12c

  • Developing a Test Plan
  • Performance Testing
  • Requirements for Databases Using Oracle Label Security or Oracle Database Vault
  • Requirement for Databases Using Oracle Warehouse Builder
  • Using the Pre-Upgrade Information Tool
  • Backing Up the Database
  • Installing the Oracle Database 12c Software
  • Preparing the New Oracle Home

Upgrading to Oracle Database 12c

  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Manually Upgrading to Oracle Database 12c
  • Migrating a non-CDB to a CDB

Performing Post-Upgrade Tasks

  • Migrating to Unified Auditing
  • Performing Post-Upgrade Tasks Following a Manual Upgrade

Migrating Data by Using Oracle Data Pump

  • Data Pump Overview
  • Migrating by Using Data Pump
  • Importing by Using a Network Link
Chat

Quero saber mais informações sobre este curso

Oracle Database 12c: Install and Upgrade Workshop

Administração de Bases de Dados | 12h - Laboral: 09h30 - 17h30


Notas

Pretende mais informação sobre este curso?

Preencha o formulário com os seus dados e as suas questões e entraremos em contacto consigo para lhe darmos todas as informações pretendidas.

Obrigado!