Oracle Database 12c: Install and Upgrade Workshop
This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c software.
Description
This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.
What You'll Learn
- Install Oracle Grid Infrastructure for a Standalone Server.
- Use Oracle Restart to manage components.
- Upgrade an existing Oracle Database to Oracle Database 12c.
- Create a container database and provision pluggable databases.
- Gain an understanding of the Oracle Database Cloud Service.
Prerequisites
- Working knowledge of SQL and use of PL/SQL packages
Suggested Prerequisites
- Basic knowledge of Linux Operating System
Audience
Outline
10 modules
•
2 Days total
- 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
- 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
- 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
- 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)
- 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
- Upgrade Methods
- Data Migration Methods
- Supported Releases for Direct Upgrade
- Overview of Upgrade Process
- Performing a Rolling Upgrade
- Upgrading a CBD
- 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 by Using the Database Upgrade Assistant (DBUA)
- Manually Upgrading to Oracle Database 12c
- Migrating a non-CDB to a CDB
- Migrating to Unified Auditing
- Performing Post-Upgrade Tasks Following a Manual Upgrade
- Data Pump Overview
- Migrating by Using Data Pump
- Importing by Using a Network Link