Database 12c R2: Install and Upgrade Workshop NEW

Tópicos Principais:

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

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