Получить консультацию
Training Center MUKКурсыOracleDatabaseOracle Database 12c R2: Install and Upgrade Workshop

Oracle Database 12c R2: Install and Upgrade Workshop

Код курса
Orcl_Db12_upgrade
Продолжительность
2 Дней, 16 Ак. Часов
Описание курса
Цели
Требования
Программа курса
Описание курса

Course overview

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.

Цели

Course Objectives

  • Upgrade database to Oracle Database 12c Release 2
  • Create a container database
  • Install Oracle Grid Infrastructure for a Standalone Server (12.1.0.2.0)
  • Configure ASMLIB and create ASM disk groups
  • Apply the latest patch set updates to the Grid Infrastructure software (12.1.0.2.160719)
  • Install Oracle Database 12c Release 2 software (12.2.0.0.3)
  • Use Oracle Restart to manage components
  • Prepare the Linux operating system for Oracle software installation
  • Install Oracle Grid Infrastructure for an Independent Server (12.2.0.0.3)
  • Install Oracle Database 12c software (12.1.0.2.0)
  • Create an Oracle Database using DBCA
  • Install the latest patch set updates to the Oracle database software (12.1.0.2.160719)
Требования

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
Программа курса

Course Topics

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. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. Installing Oracle Database Software

  • Creating Operating System Groups and Users
  • Types of Installations
  • Oracle Database Installation: System Requirements

9. 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

10. 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

11. 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
Регистрация на ближайший курс
Oracle Database 12c R2: Install and Upgrade Workshop
Код курса:
Orcl_Db12_upgrade
Продолжительность:
2 Дней, 16 Ак. Часов
Зарегистрироваться
Получить консультацию
Свяжитесь со мной
Получить консультацию
Отправить заявку
Регистрация на вебинар
Отправить заявку
Ваша заявка получена!
Мы свяжемся с вами в ближайшее время.