Oracle Database 12cR2 Install & Upgrade Training Course

Course Contents - DAY 1

Course Introduction

• • Administration and Course Materials
• • Course Structure and Agenda
• • Delegate and Trainer Introductions

Session 1: OVERVIEW OF ORACLE DATABASE 12cR2

• • Overview of the Oracle Database 12cR2
• • Overview of Oracle Database 12cR2 architecture
• • Oracle Database instance configuration
• • Oracle Background processes
• • Database storage architecture
• • Database logical and physical structures
• • Overview of container and pluggable database

Session 2: ORACLE DATABASE 12c MULTITENANT ARCHITECTURE

• • Overview of Container and Pluggable databases
• • The benefits of Multitenant Architecture
• • Files in a multitenant database
• • The structure of the root container
• • The structure of a pluggable container
• • CDB_ and DBA_ views

Session 3: INSTALL ORACLE GRID INFRASTRUCTURE ON A STANDALONE SERVER

• • Overview of Grid Infrastructure for a standalone server
• • System requirements and prerequisites
• • Create directories and groups for a Grid Infrastructure installation
• • Configure Grid Infrastructure for a standalone server
• • Overview of ASM storage
• • Install Grid Infrastructure for a standalone server
• • Upgrade Grid Infrastructure for a standalone server

Session 4: INSTALL THE ORACLE DATABASE SOFTWARE

• • Plan an installation
• • System requirements and operating system prerequisites
• • Oracle Flexible Architecture and directory structures
• • Carry out pre-installation tasks and checks
• • Set environment variables
• • Install the Oracle Database software with the Oracle Universal Installer
• • The Oracle Inventory
• • Silent mode installation
• • Use response files
• • Database Software De-install

Session 5: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

• • Select 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
• • Create a Database using a response file with DBCA silent mode
• • Create a Database with DBCA silent mode
• • Delete a database with DBCA silent mode
• • Create a database design template
• • Carry out post database creation tasks
• • Read-Only homes from Oracle 18c

Session 6: MANAGE ORACLE RESTART

• • The Benefits of Grid Infrastructure for a standalone server
• • Overview of using Oracle Restart
• • The ohasd daemon
• • Use commands to manage the Oracle Restart Stack
• • Add components to Oracle Restart
• • Use the srvctl utility to manage,start and stop and manage components
• • Upgrade and patch the 12.2 home

Oracle Database 12cR2 Install & Upgrade Training Course

Course Contents - DAY 2

Session 7: PREPARATION FOR UPGRADE

• • Upgrade process overview
• • Methods used to perform upgrade
• • Methods of data migration
• • Direct upgrade supported releases
• • Methods used to perform indirect upgrade
• • The Database Upgrade Assistant
• • Manual upgrade methods
• • Rolling Upgrade for Oracle Grid Infrastructure
• • Create an upgrade test plan
• • Carry out performance testing
• • Prepare to Upgrade a Database
• • Run the Pre-Upgrade Information tool
• • Check for compatibility issues
• • Use the ORAchk Utility
• • Backup the database
• • Create the new Oracle home
• • Install the Oracle Database 12cR2 software

Session 8: PERFORM AN UPGRADE TO ORACLE DATABASE 12cR2

• • Perform an upgrade of an Oracle Database to 12.2.0.n
• • Perform Post upgrade actions
• • Upgrade a database with the DBUA
• • Manually start a failed upgrade
• • Common installation errors
• • Run the DBUA in silent mode
• • Carry out post upgrade tasks
• • Migrate to Unified Auditing
• • Deprecated database features and parameters
• • De-supported database features and parameters

Session 9: MIGRATE DATA WITH DATA PUMP

• • Migrate data with Data Pump
• • Transport a database
• • Import data using a Data Pump network link