Duración

2 días - 12 horas

Descripción

This Oracle Database 12c R2: Install and Upgrade Workshop will provide you with key information to install Oracle Database 12c Release 2 software. You’ll also learn how to create a container database and provision pluggable databases.

Objetivos

  • Upgrade database to Oracle Database 12c Release 2
  • Create a container database
  • Install Oracle Grid Infrastructure for a Standalone Server
  • Configure ASMLIB and create ASM disk groups
  • Apply the latest patch set updates to the Grid Infrastructure software
  • Install Oracle Database 12c Release 2 software
  • Use Oracle Restart to manage components
  • Prepare the Linux operating system for Oracle software installation
  • Install Oracle Grid Infrastructure for an Independent Server
  • Install Oracle Database 12c software
  • Create an Oracle Database using DBCA
  • Install the latest patch set updates to the Oracle database software

 

Contenidos del curso

  1. Oracle Database 12c R2: Overview
    • Oracle Database Innovation
    • Oracle Database Server Architecture: Overview
    • Process Architecture
    • Database Storage Architecture
    • Oracle Database Memory Structures
    • Objectives
    • Oracle Database Instance Configurations
    • Connecting to the Database Instance
  2. Oracle Software Installation Basics
    • Operating System Groups and Users
    • Environment Variables
    • Configuring the Oracle Software Owner Environment
    • Planning Your Installation
    • Using Oracle Universal Installer (OUI)
    • Installation Option: Silent Mode
    • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
  3. Installing Oracle Grid Infrastructure for a Standalone Server
    • Post Patch steps using Datapatch
    • Determining the latest patch sets available using Oracle Support
    • Patching Using OPatch
    • Upgrading OPatch
    • Patching Using OPlan
    • Patching Using opatchauto
    • Overview of Patching
    • Types of patches
  4. Installing Oracle Database Software
    • Creating Operating System Groups and Users
    • Types of Installations
    • Oracle Database Installation: System Requirements
  5. Creating an Oracle Database by Using DBCA
    • Creating a Container Database by Using DBCA
    • Planning the Database
    • Using the DBCA to Create a Database
    • Creating a Database Design Template
    • Choosing the Appropriate Character Set
    • Understanding How Character Sets Are Used
    • Setting the NLS_LANG Initialization Parameter
    • Types of Databases
  6. Oracle Restart
    • Controlling Oracle Restart
    • Obtaining Help for the SRVCTL Utility
    • Using the SRVCTL Utility
    • Oracle Restart
    • Oracle Restart Configuration
    • Oracle Restart Process Startup
    • Choosing the Correct SRVCTL Utility
    • Starting Components by Using the SRVCTL Utility
  7. Introduction to Upgrading to Oracle Database 12c
    • Upgrade Paths
    • Upgrade Method Limitations
    • Database Upgrade Assistant: Advantages and Disadvantages
    • Upgrading to a New Release of Oracle Database
    • Defining Upgrade and Data Migration
    • Upgrade Methods
    • Manual Upgrade: Advantages and Disadvantages
    • Migration Methods
  8. Preparing to Upgrade to Oracle Database 12c
    • Requirements for Databases Using Oracle Label Security or Oracle Database Vault
    • Performance Testing
    • Developing a Test Plan
    • Planning the Upgrade
    • Requirement for Databases Using Oracle Warehouse Builder
    • Using the Pre-Upgrade Information Tool
    • Backing Up the Database
    • Preparing to Upgrade
  9. Upgrading to Oracle Database 12c
    • Manually Upgrading to Oracle Database 12c
    • Upgrading by Using the Database Upgrade Assistant (DBUA)
    • Plugging a Non-CDB Database into a CDB
    • Key DBUA Features
    • Migrating a Pre-12.1 or 12.1 Non-CDB to CDB
  10. Performing Post-Upgrade Tasks
    • Understanding Auditing Implementation
    • Recommended Tasks After Database Upgrade
    • Enabling Unified Auditing
    • Required Tasks After Database Upgrade
    • Administering the Roles Required for Auditing
  11. Migrating Data by Using Oracle Data Pump
    • Creating a New PDB from PDB$SEED
    • Exporting from a Non-CDB and Importing into a PDB
    • Oracle Data Pump: Overview
    • Importing by Using a Network Link
    • Migrating by Using Oracle Data Pump
    • Creating a Container Database by Using DBCA
    • Data Pump Utility: Interfaces and Modes
    • Data Pump Export and Import Clients: Overview


Información extra

Learn to

This Oracle Database 12c R2: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c Release 2 software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases.

  • Configure the Oracle Linux 7 operating system for Oracle software installation.
  • Install Oracle Grid Infrastructure for a Standalone Server (12.1) using Oracle Universal Installer.
  • Install Oracle Grid Infrastructure for an Independent Server (12.2) using a golden image.
  • Configure ASMLIB and create ASM disk groups.
  • Install Oracle Database software (12.1) using Oracle Universal Installer.
  • Install Oracle Database software (12.2) using a silent installation.
  • Apply patch set updates to Oracle software.
  • Use Oracle Restart to manage components.
  • Upgrade an existing Oracle Database to Oracle Database 12c Release 2 (12.2.0.0.3.
  • Create a container database and provision pluggable databases.

Benefits to you

Students will benefit from working with multiple install scenarios in the lab sessions. This will allow the new course to be relevant for both 12c R1 and 12c R2 setups. After the install of the Grid Infrastructure software, the student will then gain experience patching Oracle Software.

Related Training

Suggested Prerequisite

  • Basic knowledge of Linux operating system
  • Basic knowledge of Linux System Administration
  • Working knowledge of SQL and use of PL/SQL packages

Required Prerequisite

  • Oracle Linux 5 & 6 System Administration Ed 3
  • Oracle Database 12c: Introduction to SQL Ed 1.1
  • Oracle Database 12c: Administration Workshop Ed 2

 

Audience

  • Technical Administrator
  • Data Warehouse Administrator
  • Database Administrators
  • Support Engineer

 

Información general

Área formativa

Oracle Base de Datos

Fabricante

Oracle

Metodología

Presencial

Certificación

Garantía juvenil

 

¿TIENES DUDAS? PREGÚNTANOS

He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal

 

 

Fecha y precios de nuestros cursos

Fecha Horario de impartición Ubicación Precio por alumno Previsto en fecha
25 Mar 2019
De 9.00 a 15.00h
Core Madrid
858€ +IVA
10 Jun 2019
De 9.00 a 15.00h
Core Madrid
858€ +IVA
28 Oct 2019
De 9.00 a 15.00h
Core Madrid
858€ +IVA

¿Necesitas Ayuda?

Consúltanos si necesitas información de nuestros cursos o masters.

 

Contacta con Core Networks