> > D77766

Oracle Database 12c R2: Install and Upgrade Workshop (D77766)

Cursusbeschrijving Beschikbare data
 

Who Should Attend

  • Data Warehouse Administrator
  • Database Administrator

Prerequisites

Working knowledge of SQL and use of PL/SQL packages

Course Objectives

  • Install Oracle Grid Infrastructure for a Standalone Server
  • Use Oracle Restart to manage components
  • Upgrade database to Oracle Database 12c
  • Create a container database
  • Create an Oracle Database
  • Install Oracle Database 12c software

Course Content

  • 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
Klassikale training
Modality: C

Duur 2 dagen

Prijs (excl. BTW)
  • Nederland: 1.354,- €
Beschikbare data
 
Klik op de plaats & boek online Beschikbare data
Instructor-Led Online Training
Nederland
27-05-2019 - 28-05-2019 Utrecht boek direct
Europa
Duitsland
02-05-2019 - 03-05-2019 Dresden boek direct
30-05-2019 - 31-05-2019 Online Training Tijdzone: Europe/London Taal: Engels boek direct
01-07-2019 - 02-07-2019 München boek direct
30-09-2019 - 01-10-2019 München boek direct
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!