Oracle Database 12c R2: Administration Workshop (D78846)

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
Learn To:
  • Manage an Oracle Database instance.
  • Configure the Oracle Network environment.
  • Create and manage storage structures.
  • Manage and move data.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Create and manage Database as a Cloud Service database deployments.
Benefits to You
You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. 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. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Target Audience
  • Database Administrators
  • Database Administrators
  • Database Designers
  • Database Designers
  • Support Engineer
  • Support Engineer
  • Technical Administrator
  • Technical Administrator
  • Data Warehouse Administrator
  • Data Warehouse Administrator
  • Data Warehouse Administrator
Course Objectives
  • Back up, restore, and patch DBCS database deployments
  • Describe the DBaaS and on-premises Oracle Database architectures
  • Manage database instances
  • Manage UNDO data
  • Move data between databases
  • Implement basic backup and recovery procedures
  • Monitor and tune database performance
  • Tune SQL to improve performance
  • Manage resources with Oracle Database Resource Manager
  • Create pluggable databases (PDBs)
  • Configure the Oracle network environment
  • Administer user security and implement auditing
  • Create and manage tablespaces
  • Manage storage space
  • Create and manage Database as a Cloud Service (DBCS) database deployments
  • Register databases and manage performance with Enterprise Manager Cloud Control
  • A working knowledge of SQL and PL/SQL packages is very helpful in the course.
  • Basic knowledge of Linux operating system
Details anzeigen
Course Topics
Getting Started
  • Course Objectives
Exploring Oracle Database Architecture
  • Querying the Oracle Data Dictionary
  • Oracle Database Tools
  • Oracle-Supplied User Accounts
  • Oracle Database Server Architecture
  • Oracle SQL and PL/SQL
  • Connecting to Oracle Databases
  • Introducing Oracle Database
  • Relation Database Models
Managing Database Instances
  • Initialization Parameter Files
  • Opening and Closing PDBs
  • Starting Up Oracle Databases
  • Shutting Down Oracle Databases
  • Querying Dynamic Performance Views
  • Working with the Automatic Diagnostic Repository (ADR)
Creating PDBs
  • Methods and Tools to Create PDBs
  • Dropping PDBs with SQL*Plus
  • Unplugging and Pluggin In PDBs with SQL*Plus
  • Cloning PDBs with SQL*Plus
  • Creating PDBs from Seed with SQL*Plus
Configuring the Oracle Network Environment
  • Configuring Listeners for Static Service Registration
  • Dedicated Versus Shared Server Configurations
  • How Listeners Work
  • Testing Oracle Net Connectivity with tnsping
  • Configuring Listeners for Dynamic Service Registration
  • Oracle Net Services
  • Configuring Local Naming for Connections
  • Configuring Communidation Between Databases
Administering User Security
  • Authenticating Users
  • Assigning Quotas to Users
  • Creating Users
  • Granting Privileges
  • Creating and Granting Roles
  • Creating and Assigning Profiles
  • Applying the Principal of Least Privilege
  • Revoking Privileges and Roles
Creating and Managing Tablespaces
  • Implementing Oracle Managed Files
  • Creating Tablespaces in SQL*Plus
  • Moving and Renaming Online Data Files in SQL*Plus
  • Viewing Tablespace Information in SQL*Plus
  • How Table Data is Stored
  • Altering and Dropping Tablespaces in SQL*Plus
Managing Storage Space
  • Block Space Management
  • Allocating Extents
  • Free Space Management Within Segments
  • Row Chaining and Migration
  • Space-Saving Features
  • Types of Segments
  • Oracle Database Space Management Features
  • Understanding Deferred Segment Creation
Managing UNDO Data
  • Local Undo Mode Versus Shared Undo Mode
  • Comparing Undo Data and Redo Data
  • Undo Data: Overview
  • Configuring Undo Retension
  • Categories of Undo
  • Storing Undo Information
  • Transactions and Undo Data
  • Managing Undo
Moving Data
  • Oracle Data Pump: Benefits
  • Data Pump Export and Import Clients
  • SQL*Loader Overview
  • Data Pump Utility: Interfaces and Modes
  • Loading Methods
  • Oracle Data Pump: Overview
  • Data Pump Import: Transformations
  • Moving Data: General Architecture
Backup and Recovery Concepts
  • Categories of Failure
  • Understanding Types of Backups
  • Understanding Instance Recovery
  • Flashback Technology
  • DBA Responsibilities
  • Oracle Data Protection Solutions
  • Comparing Complete and Incomplete Recovery
Monitoring and Tuning Database Performance
  • Database Maintenance
  • Automatic Database Diagnostic Monitor
  • Automatic Workload Repository (AWR)
  • Database Server Statistics and Metrics
  • Performance Tuning Methodology
  • Performance Planning Considerations
  • Managing Performance Activities
  • Performance Monitoring
SQL Tuning
  • Oracle Optimizer
  • SQL Access Advisor
  • SQL Plan Directives
  • SQL Tuning Advisor
  • SQL Tuning Process
  • Optimizer Statistics
  • Adaptive Execution Plans
  • SQL Performance Analyzer
Oracle Database Resource Manager
  • Resource Manager Elements
  • Limiting CPU Utilization at the Database Level
  • Using the Active Session Pool Feature
  • Creating a Complex Resource Plan
  • Oracle Database Resource Manager: Overview
  • Limiting CPU Utilization at the Server Level
  • Creating a Simple Resource Plan
  • Using Resource Manager to Allocate Resources
Enterprise Manager Cloud Control
  • Controlling the Enterprise Manager Cloud Control Framework
  • Starting the Enterprise Manager Cloud Control Framework
  • Stopping the Enterprise Manager Cloud Control Framework
Introduction to Oracle Database Cloud Service
  • DBCS Architecture
  • Oracle Cloud: Overview
  • Additional Database Configuration Options
  • Features and Tooling
  • Database Cloud Service Offerings
Creating DBCS Database Deployments
  • Creating a Database Deployment
  • Automated Database Provisioning
  • Creating an SSH Key Pair
  • How SSH Key Pairs are Used
  • Storage Used for Database Files
Managing DBCS Database Deployments
  • Managing Network Access to DBCS
  • Cloud Tooling
  • Accessing Tools and Features from the DBCS Console
  • Enabling Access to a Compute Node Port
  • Scaling a Database Deployment
  • Managing the Compute Node Associated With a Database Deployment
Backing Up and Restoring DBCS Database Deployments
  • Backing Up and Recovering Databases on DBCS
  • Creating an On-Demand Backup
  • Performing Recovery by Using the Console
  • Performing Recovery by Using the dbaascli Utility
  • Backup Configuration
  • Customizing the Backup Configuration
  • Backup Destination Choices
Patching DBCS Database Deployments
  • Using the dbaascli Utility to Manage Patches
  • Using the DBCS Console to Manage Patches
  • Patching DBCS
Creating Master Encryption Keys for PDBs
  • Creating and Activating an Encryption Key
  • Determining Whether You Need to Create and Activate and Encryption Key for a PDB
  • CDB and PDB Master Encryption Keys
Tablespace Encryption by Default
  • Using TDE
  • Defining the Keystore Location
  • Transparent Data Encryption (TDE) Overview
  • Managing the Software Keystore and Master Encryption Key
  • Managing the Keystore in CDBs and PDBs
  • Components of TDE
  • Tablespace Encryption by Default in DBCS
  • Controlling Tablespace Encryption by Default