Oracle Database 19c: Administration Workshop
This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques.
Description
Overview
This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Course Objectives
After completing this course, students will be able to:
- Generate database creation scripts using the Database Configuration Assistant (DBCA) and create a container database (CDB)
- View and modify initialization parameters in SQL*Plus
- Work with the Automatic Diagnostic Repository (ADR)
- Implement Oracle Managed Files (OMF)
- Use techniques to save space
- Understand DBA responsibilities for security and auditing
- Transport tablespaces and databases
- Use performance views and tools to monitor database instance performance
Course Outline
Lesson 1: Introduction to Oracle Database
- Database Server Architecture
Lesson 2: Accessing an Oracle Database
- Accessing an Oracle Database
- Usage of general DBCA Tools to Interact with Database
Lesson 3: Creating an Oracle Database by Using DBCA
- Creating a Database Using DBCA
Labs
- Creating a New CDB
Lesson 4: Creating an Oracle Database by Using a SQL Command
- Creating Database using SQL Command
Labs
- Creating a New CDB
Lesson 5: Starting Up and Shutting Down a Database Instance
- Starting Up and Shutting Down a Database Instance
- Opening and Closing PDBs
Labs
- Shutting Down and Starting Up the Oracle Database
Lesson 6: Managing Database Instances
- Managing the Database
Labs
- Investigating Initialization Parameter Files
- Viewing Initialization Parameters by Using SQL*Plus
- Modifying Initialization Parameters by Using SQL*Plus
- Viewing Diagnostic Information
Lesson 7: Oracle Net Service: Overview
- Configuring and Administering Oracle Net Service
Lesson 8: Configuring Naming Methods
- Oracle Net Components
- Naming Method
Labs
- Configuring the Oracle Network to Access a Database
- Creating a Net Service Name for a PDB
Lesson 9: Configuring and Administering the Listener
- Configuring and Administering the Listener
Labs
- Exploring the Default Listener
- Creating a Second Listener
- Connecting to a Database Service Using the New Listener
Lesson 10: Configuring a Shared Server Architecture
- Configuring a Shared Server Architecture
Labs
- Configuring Shared Server Mode
- Configuring Clients to Use a Shared Server
Lesson 11: Configuring Oracle Connection Manager for Multiplexing and Access Control
- Configuring Oracle Connection Manager for Multiplexing and Access Control Connection Manager
Labs
- Installing Oracle Instant Client
- Configuring the cman.ora File
- Configuring the Database for Oracle Connection Manager
- Configuring Clients for Oracle Connection Manager
- Configuring the Oracle Database Server for Session Multiplexing
Lesson 12: Creating PDBs from Seed
- Creating PDBs from Seed
- Provisioning New Pluggable Databases
Labs
- Creating a New PDB from the PDB Seed
Lesson 13: Using Other Techniques to Create PDBs
- Using Other Techniques to Create PDBs
- Method of Creating and Migrating PDBs
Labs
- Cloning Remote PDBs in Hot Mode
- Relocating PDBs
Lesson 14: Managing PDBs
- Managing PDBs
Labs
- Renaming a PDB
- Setting Parameter Values for PDBs
Lesson 15: Database Storage Overview
- Database Storage Overview
- Purpose of the Default Tablespaces
- Storage of Data in Blocks
- Advantage of Deferred Segment Creation
Lesson 16: Creating and Managing Tablespaces
- Creating and Managing Tablespaces
- Viewing Tablespace Information
Labs
- Viewing Tablespace Information
- Creating a Tablespace
- Managing Temporary and Permanent Tablespaces
Lesson 17: Improving Space Usage
- Space Management Features
- Creating Global Temporary Tables
Labs
- Managing Space in Tablespaces
- Using Compression
- Enabling the Resumable Space Allocation Feature
Lesson 18: Managing Undo Data
- Managing the Undo
- Enabling Temporary Undo
Labs
- Managing Undo Tablespaces in a PDB
Lesson 19: Creating and Managing User Accounts
- Creating and Managing User Accounts
- Creating Common Users in the CDB and PDBs
- Assigning Quotas
Labs
- Creating Common and Local Users
- Creating a Local User for an Application
- Exploring OS and Password File Authentication
Lesson 20: Configuring Privilege and Roles Authorization
- Configuring Privilege and Roles Authorization
Labs
- Granting a Local Role (DBA) to PDBADMIN
- Using SQL*Developer to Create Local Roles
Lesson 21: Configuring User Resource Limits
- Configuring User Resource Limits
Labs
- Using SQL*Developer to Create a Local Profile
- Using SQL*Developer to Create Local Users
- Configuring a Default Role for a User
Lesson 22: Implementing Oracle Database Auditing
- Implementing Oracle Database Auditing
- Configuring Auditing
- Viewing Audit Policy Information
Labs
- Enabling Unified Auditing
- Creating Audit Users
- Creating an Audit Policy
Lesson 23: Introduction Loading and Transporting Data
- Introduction Loading and Transporting Data
Lesson 24: Loading Data
- Loading Data
Labs
- Loading Data into a PDB from an External File
Lesson 25: Transporting Data
- Transporting Data
- Using the RMAN Convert Command
Labs
- Moving Data from One PDB to Another PDB
- Transporting a Tablespace
Lesson 26: Using External Tables to Load and Transport Data
- Using External Tables to load Transport Data
- External Table Demo
Labs
- Querying External Tables
- Unloading External Tables
Lesson 27: Automated Maintenance Tasks: Overview
- Automated Maintenance Tasks: Overview
- Automated Maintenance Tasks: Components
Lesson 28: Automated Maintenance Tasks: Managing Tasks and Windows
- Configuring Automated Maintenance Tasks
Labs
- Enabling and Disabling Automated Maintenance Tasks
- Modifying the Duration of a Maintenance Window
Lesson 29: Database Monitoring and Performance Tuning Overview
- Database Monitoring and Tuning Performance Overview
Lesson 30: Monitoring Database Performance
- Understanding What Database Performance is Monitored
Lesson 31: Analyzing SQL and Optimizing Access Paths
- Analyzing SQL and Optimizing Access Paths
- Adaptive Execution Plans