Oracle Database 12c Install and Upgrade

Course

In London-City

£ 745 + VAT

Description

  • Type

    Course

  • Location

    London-city

This Oracle Database 12c Install and Upgrade course is designed to give the Oracle database administrator practical experience in installing Oracle Database 12c software. Delegates will learn how to create a container database and provision pluggable databases. Learning Objectives Course ObjectivesThis Oracle Database 12c Install and Upgrade course is designed to give database administrators the knowledge and skills needed to install and configure an Oracle 12c database. The Oracle Database 12c administrator will gain practical experience in upgrading a database to Oracle 12c database.

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

RequirementsDelegates who wish to attend the Oracle Database 12c Install and Upgrade course should have practical knowledge of administering an Oracle database. They should have attended the Oracle 12c Administration course or have a good working knowledge of Oracle administration.Pre-Requisite CoursesOracle Database 12c Administration

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Install
  • Database training
  • Database

Course programme

Course Contents - DAY 1Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions
Session 1: OVERVIEW OF ORACLE DATABASE 12c
  • Overview of the Oracle Database 12c
  • Overview of Oracle Database 12c architecture
  • Oracle Database instance configuration
  • Database storage architecture
  • Database logical and physical structures
  • Overview of container and pluggable database
Session 2: INSTALL ORACLE GRID INFRASTRUCTURE ON A STANDALONE SERVER
  • Overview of Grid Infrastructure for a standalone server
  • System requirements and prerequisites
  • Configure ASM storage
  • Install Grid Infrastructure for a standalone server
  • Upgrade Grid Infrastructure for a standalone server
Session 3: INSTALL THE ORACLE DATABASE SOFTWARE
  • Plan an installation
  • System requirements and operating system prerequisites
  • Carry out pre-installation checks
  • Set environment variables
  • Install the Oracle Database software with the Oracle Universal Installer
  • Silent mode installation
Session 4: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)
  • Selecting a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA
Session 5: ORACLE RESTART
  • Overview of Oracle Restart
  • Configuration of Oracle Restart
  • Control Oracle Restart
  • The SRVCTL utility
  • Use SRVCTL help
  • Use the SRVCTL utility to start and stop and manage components
Oracle Database 12c Install and Upgrade Training CourseCourse Contents - DAY 2Session 6: PREPARATION FOR UPGRADE TO ORACLE DATABASE 12c
  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • Upgrade process overview
  • Rolling upgrade
  • Upgrade a CDB
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information tool
  • Backup the database
  • Install the Oracle Database 12c software
  • Create the new Oracle home
Session 7: PERFORM AN UPGRADE TO ORACLE DATABASE 12c
  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Migrate a non-CDB to a CDB
Session 8: POST UPGRADE TASKS
  • Carry out post upgrade tasks after a manual upgrade
  • Migrate to unified auditing
Session 9: MIGRATE DATA WITH DATA PUMP
  • Migrate data with Data Pump
  • Import data using a Data Pump network link

NOTE: Course technical content is subject to change without notice.

Oracle Database 12c Install and Upgrade

£ 745 + VAT