Detailed Course Outline
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