Oracle Database 12cR2 Install & Upgrade

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

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