This Oracle Database 19c Administration training is designed to empower learners with the fundamental skills and knowledge required to effectively administer Oracle Database 19c environments. The course provides comprehensive coverage of essential concepts, tools, and techniques essential for proficient database administration.
Participants will delve into key topics such as installation and configuration of Oracle Database 19c, including Oracle Multitenant Architecture. They will learn how to create and manage various database objects, such as tables, indexes, and views, ensuring optimal performance and data integrity. The course also covers backup and recovery strategies, enabling students to implement robust disaster recovery solutions.
Moreover, participants will gain proficiency in user and security management, understanding how to grant and revoke privileges, and secure sensitive data effectively. Advanced concepts like Oracle Database security features and auditing capabilities will also be explored to ensure comprehensive data protection.
Throughout the training, hands-on exercises and real-world scenarios provide practical experience in database administration tasks, enabling participants to confidently manage Oracle Database 19c environments in diverse organizational settings. By the end of the course, participants will possess the skills necessary to effectively administer Oracle Database 19c, ensuring smooth operation, optimal performance, and data security.
Upon completing the course, you will be able to:
● Understand the fundamental concepts and architecture of Oracle Database 19c.
● Learn to install and configure Oracle Database 19c effectively.
● Develop proficiency in managing database instances and storage structures.
● Acquire skills in implementing security measures to safeguard Oracle databases.
● Gain expertise in performing backup and recovery tasks to ensure data integrity.
● Explore advanced features and options for optimizing database performance.
● Master the techniques for troubleshooting common Oracle Database 19c issues.
● Learn to monitor and manage Oracle Database 19c using various tools and utilities.
● Understand the principles of high availability and disaster recovery in Oracle Database environments.
● Gain practical experience in administering Oracle Database 19c through hands-on exercises and simulations.
● Database administrators
● IT professionals responsible for Oracle Database management
● System administrators
● Database architects
● Individuals seeking to enhance their Oracle Database administration skills
● Basic understanding of relational database concepts
● Familiarity with SQL language
● Knowledge of operating systems (Linux, Windows, or Unix)
● Experience with basic command-line operations
● Course Goals
● Recommended Timetable
● Oracle Database Server Structure: Summary
● Oracle Database Instance Setup
● Accessing the Database Instance
● Oracle Database Memory Components
● Shared Cache
● Data Cache
● Transaction Log Cache
● Extended Pool
● Java Memory
● Streams Memory
● Global Program Area (PGA)
● Process Design
● Process Elements
● Database Writer Role (DBWn)
● Log Writer Role (LGWR)
● Checkpoint Role (CKPT)
● System Monitor Role (SMON)
● Process Monitor Role (PMON)
● Recovery Role (RECO)
● Listener Registration Role (LREG)
● Archiver Roles (ARCn)
● Database Storage Structure
● Logical and Physical Database Setup Segments, Portions, and Blocks Storage Spaces and Data Files
● SYSTEM and SYSAUX Storage Spaces
● Oracle Container Database: Overview
● Multi-Tenant Design
● Interacting with an Oracle Database: Memory, Processes, and Storage
● Introduction to Oracle Database Management Tools: SQLPlus
● Invoking SQLPlus from a Shell Script
● Executing a SQL Script in SQL*Plus
● Oracle SQL Developer: Establishing Connections
● Oracle SQL Developer: Administrative Tasks
● Oracle Enterprise Manager Database Express Structure
● Setting Up Enterprise Manager Database Express
● Accessing Oracle Enterprise Manager Database Express
● Navigating the Database Home Page
● Exploring Enterprise Manager Database Express Options
● Oracle Enterprise Manager Cloud Control Components
● Managing the Enterprise Manager Cloud Control Framework
● Initiating the Enterprise Manager Cloud Control Framework
● Terminating the Enterprise Manager Cloud Control Framework
● Categories of Enterprise Manager Cloud Control Targets
● Utilizing Enterprise Manager Cloud Control
● Initialization Parameter Configuration
● Categories of Initialization Parameters
● Illustrative Initialization Parameter Scenarios
● Inspecting Parameters with SQL*Plus
● Modifying Initialization Parameters
● Adjusting Parameter Values: Instances
● Initiating an Oracle Database Instance: NOMOUNT Stage
● Initiating an Oracle Database Instance: MOUNT Phase
● Initiating an Oracle Database Instance: OPEN Mode
● Startup Scenarios: Instances
● Termination Procedures
● Options for Termination
● Termination Scenarios: Instances
● Examining the Alert Log
● Utilizing Trace Files
● Managing the DDL Log
● Interpreting the Debug Log
● Exploring Dynamic Performance Insights
● Dynamic Performance Views: Illustrations
● Dynamic Performance Views: Tips
● Understanding the Data Dictionary
● Data Dictionary Perspectives
● Data Dictionary: Instances
● Oracle Net Services: Introduction
● Oracle Net Listener: Introduction
● Establishing Connections in Oracle Networking
● Accessing an Oracle Database
● Address Resolution
● Initiating a Connection
● User Interaction
● Naming Techniques
● Simplified Connection
● Local Addressing
● Directory-Based Addressing
● External Addressing Approach
● Tools for Oracle Net Services Management
● Defining Oracle Net Services Elements
● Utilizing Enterprise Manager Cloud Control
● Utilizing Oracle Net Manager
● Utilizing Oracle Net Configuration Assistant
● Utilizing the Listener Control Utility
● Syntax for Listener Control Utility
● Advanced Connection Features
● Verification of Oracle Net Connectivity
● Comparison of Dedicated and Shared Server Configurations
● User Interaction: Dedicated Server Model
● User Interaction: Shared Server Model
● Usage of SGA and PGA
● Considerations for Shared Server Configuration
● Establishing Inter-Database Communication
● Connecting to Another Database
● Database User Management
● Predefined Administrative Accounts
● Administrative Access Rights
● Securing Elevated Accounts
● User Authentication
● Administrator Verification
● OS Verification and Group Association
● User Administration
● User Creation
● Reactivating a User and Resetting Credentials
● Access Rights
● System Access Rights
● Withdrawal of System Access Rights with ADMIN OPTION
● Granting Object Access Rights
● Object Access Rights
● Withdrawal of Object Access Rights with GRANT OPTION
● Role-Based Access Control
● Allocation of Access Rights to Roles and Users
● Standardized Access Roles
● Role Creation
● Protected Roles
● Assignment of Roles to Users
● Access Right Analysis
● Analysis of Access Rights Workflow
● Profiles and Users
● Implementation of Password Protection Features
● Formation of a Password Profile
● Predefined Password Validation Functions
● Adjustments to the Default Profile
● Allocation of Quotas to Users
● Application of the Principle of Minimal Privilege
● Storage Mechanism for Table Data
● Contents of a Database Block
● Analysis of the Storage Architecture
● Formation of a New Tablespace
● Survey of Defaultly Created Tablespaces
● Modification of a Tablespace
● Incorporating a Data File into a Tablespace
● Modifications to Data Files
● Eliminating Tablespaces
● Reviewing Tablespace Details Oracle Managed Files (OMF)
● Expansion of the Database
● Relocation or Renaming of an Online Data File
● Space Management: Introduction
● Block-Level Space Management
● Row Chaining and Movement
● Management of Free Space in Segments
● Categories of Segments
● Extent Allocation
● Understanding Deferred Segment Creation
● Inspection of Deferred Segment Details
● Regulation of Deferred Segment Creation
● Constraints and Exemptions
● Additional Automated Capabilities
● Overview of Table Compression
● Compression for Direct Insert Operations
● Enhanced Row Compression for Data Manipulation Operations
● Specification of Table Compression
● Utilization of Compression Advisory
● Employing the DBMS_COMPRESSION Package
● Proactive Monitoring of Tablespaces
● Thresholds and Addressing Space Issues
● Monitoring Tablespaces for Space Utilization
● Segment Reduction
● Outcomes of Reduction Activities
● Reclaiming Space in Automatic Segment Space Management (ASSM) Segments
● Utilization of Segment Advisory
● Automatic Segment Advisory
● Segment Reduction via SQL
● Segment Reduction via Enterprise Manager
● Management of Resumable Space Assignment
● Execution of Resumable Space Assignment
● Continuation of Interrupted Operations
● Supported Resumable Operations
● Overview of Undo Data
● Transactions and Undo Records
● Storage of Undo Information
● Comparison Between Undo and Redo Data
● Management of Undo
● Configuration of Undo Retention
● Types of Undo
● Ensuring Undo Retention
● Converting an Undo Tablespace to Fixed Size
● Temporary Undo: Introduction
● Advantages of Temporary Undo
● Enabling Temporary Undo
● Monitoring Temporary Undo
● Viewing Undo Information
● Reviewing Undo Activity
● Utilizing the Undo Advisor
● Locking
● Locking System
● Concurrency Control
● Locks for Data Manipulation
● Enqueue System
● Conflict in Locking
● Reasons for Lock Conflicts
● Identification of Lock Conflicts
● Resolution of Lock Conflicts
● Addressing Lock Conflicts with SQL
● Deadlocks
● Security Measures for the Database
● Compliance Monitoring
● Types of Activities Subject to Audit
● Mandatory Audited Actions
● Understanding Audit Implementation
● Administration of Necessary Roles for Auditing
● Overview of Database Auditing
● Comprehension of Audit Framework
● Activation of Unified Auditing
● Configuration of Auditing Parameters
● Utilization of Enterprise Manager Cloud Control
● Development of Unified Audit Policy
● Creation of System-Wide Audit Policy
● Definition of Object-Specific Actions in Audit Policy
● Specification of Conditions in Audit Policy
● Enabling and Disabling Audit Policies
● Modification of Unified Audit Policy
● Inspection of Audit Policy Details
● Setting Write Mode for Audit Trail Entries
● Value-Based Audit Techniques
● Fine-Grained Auditing
● Policy for Fine-Grained Auditing
● Considerations for Audited DML Statements
● Guidelines for Fine-Grained Auditing
● Archiving and Purging Audit Trail Data
● Purge Operations for Audit Trail Records
● Database Administrator (DBA) Duties
● Failure Categories
● Statement Failures
● User Process Failures
● Network Failures
● User Errors
● Flashback Technology
● Instance Failures
● Comprehension of Instance Recovery: Checkpoint (CKPT) Process
● Comprehension of Instance Recovery: Redo Log Files and Log Writer
● Understanding Instance Recovery
● Stages of Instance Recovery
● Optimizing Instance Recovery
● Utilizing the MTTR Advisor
● Media Failures
● Comparison Between Complete and Incomplete Recovery
● Process of Complete Recovery
● Procedure for Point-in-Time Recovery
● Oracle Data Protection Solutions
● Overview of Backup Solutions
● Oracle Secure Backup
● User-Managed Backup
● Comprehension of Backup Vocabulary
● Varieties of Backups
● RMAN Backup Variants
● Employing Recovery Manager (RMAN)
● Setting Up Backup Parameters
● Oracle-Recommended Backup Practices
● Selection of Backup Approach
● Creating a Trace File Backup of the Control File
● Administration of Backups
● Utilization of RMAN Commands for Backup Creation
• Managing Memory Components
• Understanding the Automatic Workload Repository (AWR)
• Understanding the Advisory Framework
• Monitoring Wait Events, Sessions, and Services
• Managing Metric Thresholds and Alerts
• Understanding and Using the Performance Tuning Methodology
• Performing Performance Planning
• Understanding the Automatic Database Diagnostic Monitor (ADDM)
● Starting a Database
● Maintaining Database Availability
● Utilizing the Data Recovery Advisor
● Control File Failure Handling
● Redo Log File Loss Management
● Data File Loss in NOARCHIVELOG Mode
● Noncritical Data File Loss in ARCHIVELOG Mode
● Critical System Data File Loss in ARCHIVELOG Mode
● Data Migration: Basic Framework
● Introduction to Oracle Data Pump
● Advantages of Oracle Data Pump
● Directory Objects in Data Pump
● Creation of Directory Objects
● Overview of Data Pump Export and Import Clients
● Interfaces and Modes in Data Pump Utility
● Executing Data Pump Export through Enterprise Manager Cloud Control
● Executing Data Pump Import
● Transformations in Data Pump Import
● Monitoring Data Pump Jobs via Enterprise Manager Cloud Control
● Overview of SQLLoader
● Control File in SQLLoader
● Loading Techniques
● Loading Data via Enterprise Manager Cloud Control
● SQL*Loader Express Mode
● External Tables Concept
● Benefits of External Tables
● Definition of External Tables with ORACLE_LOADER
● Population of External Tables with ORACLE_DATAPUMP
● Utilization of External Tables
● Data Dictionary Information
● Maintenance of the Database
● Reviewing Alert History
● Introduction to Automatic Workload Repository (AWR)
● Infrastructure of AWR
● Automatic Workload Repository Essentials
● Management of AWR
● Levels of Statistics
● Automatic Database Diagnostic Monitor (ADDM)
● Advisory Framework
● Invocation of Advisors through Packages
● Automated Maintenance Activities
● Configuration of Automated Maintenance Tasks
● Alerts Generated by the Server
● Definition of Metric Thresholds
● Response to Alerts
● Types of Alerts and Clearing Procedures
● Performance Monitoring
● Tuning Strategies
● Performance Strategy Planning
● Instance Optimization
● Approach to Performance Tuning
● Data Sources for Performance Tuning
● Monitoring Session Performance
● Identifying Top Sessions for Performance Monitoring
● Examining Session-Related Metrics
● Monitoring Top Services
● Reviewing Service-Specific Metrics
● Observing Wait Events
● Understanding Oracle's Wait Events
● Introduction to Memory Management
● Administration of Memory Components
● Best Practices for Memory Utilization
● Overview of Automatic Memory Management
● Key Oracle Database Memory Parameters
● Configuring Automatic Memory Management (AMM) via EMCC
● Monitoring AMM Functionality
● Introduction to Automatic Shared Memory Management (ASMM)
● Activation of Automatic Shared Memory Management
● Insight into ASMM Operations
● Automatic Shared Memory Advisor
● Enabling and Disabling ASMM
● Using V$PARAMETER for Memory Component Size Insights
● Managing the Program Global Area (PGA)
● Dynamic Performance Metrics
● Views for Troubleshooting and Tuning
● SQL Optimization
● Introduction to Oracle Optimizer
● Collection of Optimizer Statistics
● Methods for Gathering Optimizer Statistics
● Utilizing the Manage Optimizer Statistics Page
● Configuration of Global Preferences
● Manual Collection of Optimizer Statistics
● Preferences for Optimizer Statistics
● Concurrent Collection of Statistics
● Accessing Statistical Information
● SQL Plan Directives
● Adaptive Execution Plans
● Employing SQL Advisors
● Results of Automatic SQL Tuning
● Application of Automatic Tuning Suggestions
● Overview of SQL Tuning Advisor
● Utilization of SQL Tuning Advisor
● Recommendations from SQL Tuning Advisor
● Identification of Duplicate SQL
● Introduction to SQL Access Advisor
● Utilizing SQL Access Advisor
● Source of Workload
● Options for Recommendations
● Reviewing Advisory Outputs
● Introduction to SQL Performance Analyzer
● Use Cases for SQL Performance Analyzer
● Implementation of SQL Performance Analyzer
• Restore and Recovering Databases with RMAN
• Perform Non-RMAN database recovery
Transporting Data
• Interpret the RMAN message output
• Diagnose RMAN performance issues
Create, Delete, and Configure Databases using DBCA
Configure and use Oracle Restart to manage components
• Plan for Upgrading an Oracle Database
• Upgrade an Oracle Database
• Perform Post-Upgrade tasks
Rapid Home Provisioning
Use an RMAN recovery catalog
Use Flashback Database
• Understanding the Oracle Optimizer
• Using the SQL Tuning Advisor
• Managing Optimizer Statistics
• Using the SQL Access Advisor
• Understanding the SQL Tuning Process
What is the course duration?
Oracle 19c database administration II (Oracle DBA II) (TTOR20619) is a five-day course.
Why should I enroll in this course by Vinsys?
The course content is designed to make sure that you get both a theoretical and practical understanding of the extended Oracle database administration functionality. With Vinsys, you will get the support of an experienced expert from the field who will enhance your learning efficiency in this course. Our courses are delivered through instructor-led training (ILT), private group training, and virtual instructor-led training (vLIT).
Can a beginner enroll in this course:
Out instructors led an instructor-peer session where discussions on the key concepts, e-learning platform, case studies, and Q&A sessions were held as the primary training delivery services for the client. In order to learn efficiently in this course, you must take the course below: TTORDBAADM19 Oracle 19c Database Administration I (Oracle DBA I).
Who should do this course?
This is an intermediate-level course that can be taken by IT professionals who have prior experience in Oracle 19c database concepts and skills.
How is the course program carried out at Vinsys?
Effective course material accessed throughout the program makes it easier to learn about concepts beyond the class. You can choose your learning path to upskill with Vinsys' subject matter experts upon customizing training needs to ensure 100% results. We believe everyone can succeed if given the right tools and knowledge to move toward their goal.
Is Oracle 19c Database Administration II difficult?
The course content is kept simple to ensure that it will be easy for learners to understand. At places where learners find difficulties, the experts will provide the required assistance.
What are the career opportunities after completing this course?
Learners can get recognized for their ability to use and manage databases using Oracle 19c database administration. The course will help you get better opportunities while dealing with complex databases, and you can get hired as an Oracle DBA.
What is the course code?
TTOR20619 is the code of the Oracle 19c database administration II (Oracle DBA II).
What are the related courses?
The related courses include-
• Oracle 19C Database Multitenant Architecture (TTOR20719)
• Oracle 19c Database Tuning (TTOR21519)
• Oracle Database 19c Backup and Recovery (TTOR21619)
• Oracle 19c Database Security