Oracle DBA 21c Database Administration

Oracle 21c DBA: Master the Latest Oracle Database Innovation

Dive into the world of Oracle 21c DBA and become proficient with the newest release from Oracle! This course provides hands-on experience with Oracle Database 21c, an innovation release packed with exciting new features. Understand the key differences and considerations when working with innovation releases compared to long-term releases.

What is Oracle 21c?

Oracle 21c represents a significant leap forward in database technology. It's the first Oracle Database release with a CDB-only option, meaning you can no longer create non-CDB databases. Available on Oracle Cloud and on-premises for Linux, including Exadata, Oracle 21c offers a wealth of enhancements.

Upgrade Paths to Oracle 21c:

You can directly upgrade from:

• Oracle Database 19c
• Oracle Database 18c
• Oracle Database 12c Release 2 (12.2)

Key Features of Oracle Database 21c:

Explore cutting-edge capabilities including:

• Blockchain Tables: Securely manage blockchain data within your database.
• Immutable Tables: Ensure data integrity with immutable table functionality.
• Oracle Machine Learning: Integrate machine learning directly into your database workflows.
• Native JSON Datatype: Efficiently store and query JSON data.
• SQL Macros: Enhance SQL code with powerful macros.
• In-Database JavaScript Execution: Execute JavaScript directly within your database.
• Compare Explain Plans / Cursors: Gain deeper insights into query performance.

Course Highlights: Hands-on Oracle 21c DBA Skills

This course focuses on practical skills. You'll gain experience with:

• Oracle Architecture: A deep understanding of the database architecture.
• Installation: Learn to install Oracle Linux 8 on Oracle VM.
• CDB Creation: Practice creating a CDB (Container Database).
• PDB Creation: Practice creating PDBs (Pluggable Databases) from a seed.
• CDB Administration: Perform basic CDB administration tasks.
• User Management: Manage common and local users within the database.
• Backup & Recovery: Implement robust backup and recovery strategies for CDBs and PDBs.
• Flashback & Point-in-Time Recovery: Utilize Flashback technology for point-in-time recovery.

Important Considerations for Oracle 21c:

As an innovation release, Oracle 21c has a shorter support lifespan (2 years of premium support) compared to long-term releases like Oracle Database 19c (which has Premier Support until April 30, 2024, followed by Extended Support). Innovation releases introduce new features but lack extended support. Carefully evaluate your production environment before upgrading to Oracle Database 21c. Consider the stability and long-term support implications when planning your database upgrades.