8178 Reviews star_rate star_rate star_rate star_rate star_half

Oracle Database 12c R2: Install and Upgrade Workshop Ed 2

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

By Request

$2,700 USD

Course Code D77768GC20

Duration 2 days

Available Formats Classroom

Enter your Email to Download Full Course Details

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.

Learn To:

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.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Skills Gained

Gain an understanding of the Oracle Database Cloud Service
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

Prerequisites

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

Course Details

Oracle Database 12c R2: Overview

Objectives
Oracle Database Innovation
Oracle Database Server Architecture: Overview
Oracle Database Instance Configurations
Connecting to the Database Instance
Oracle Database Memory Structures
Process Architecture
Database Storage Architecture

Oracle Software Installation Basics

Planning Your Installation
Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
Operating System Groups and Users
Environment Variables
Configuring the Oracle Software Owner Environment
Using Oracle Universal Installer (OUI)
Installation Option: Silent Mode

Installing Oracle Grid Infrastructure for a Standalone Server

Overview of Patching
Types of patches
Determining the latest patch sets available using Oracle Support
Upgrading OPatch
Patching Using OPatch
Post Patch steps using Datapatch
Patching Using opatchauto
Patching Using OPlan

Installing Oracle Database Software

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

Creating an Oracle Database by Using DBCA

Planning the Database
Types of Databases
Choosing the Appropriate Character Set
Understanding How Character Sets Are Used
Setting the NLS_LANG Initialization Parameter
Using the DBCA to Create a Database
Creating a Container Database by Using DBCA
Creating a Database Design Template

Oracle Restart

Oracle Restart
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

Defining Upgrade and Data Migration
Upgrade Methods
Database Upgrade Assistant: Advantages and Disadvantages
Manual Upgrade: Advantages and Disadvantages
Upgrade Paths
Upgrade Method Limitations
Upgrading to a New Release of Oracle Database
Migration Methods

Preparing to Upgrade to Oracle Database 12c

Preparing to Upgrade
Planning the Upgrade
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

Upgrading to Oracle Database 12c

Upgrading by Using the Database Upgrade Assistant (DBUA)
Key DBUA Features
Manually Upgrading to Oracle Database 12c
Migrating a Pre-12.1 or 12.1 Non-CDB to CDB
Plugging a Non-CDB Database into a CDB

Performing Post-Upgrade Tasks

Required Tasks After Database Upgrade
Recommended Tasks After Database Upgrade
Understanding Auditing Implementation
Enabling Unified Auditing
Administering the Roles Required for Auditing

Migrating Data by Using Oracle Data Pump

Oracle Data Pump: Overview
Data Pump Export and Import Clients: Overview
Data Pump Utility: Interfaces and Modes
Migrating by Using Oracle Data Pump
Importing by Using a Network Link
Creating a Container Database by Using DBCA
Creating a New PDB from PDB$SEED
Exporting from a Non-CDB and Importing into a PDB

Read Less

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Request Other Date Request On-site Course

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

How do I find an ExitCertified training location?

We have training locations across the United States and Canada. View a full list of classroom training locations.

Which delivery formats are available?

At ExitCertified we offer training that is Instructor-Led, Online, Virtual and Self-Paced.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact customerexp@exitcertified.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How to request a W9 for ExitCertified LLC?

View our filing status and how to request a W9.

ExitCertified provided great learning material and the instructor was great.

ExitCertified Student

ExitCertified

the course is good, covers many aspects, wish the lab is a little bit more in depth

ExitCertified Student

ExitCertified

You get detailed labs to guide you through the technical material giving you a hands on method of learning otherwise difficult material.

ExitCertified Student

ExitCertified

Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.

ExitCertified Student

ExitCertified

The class was very vast paced however the teacher was very good at checking in on us while giving us time to complete the labs.

ExitCertified Student

ExitCertified