Oracle Database 19c/21c Administration

Module 1: Introduction to Oracle Database Administration

• Overview of Oracle Database 19c and 21c
• DBA roles and responsibilities
• Oracle database architecture: Instance and database
• Oracle memory structures: SGA and PGA
• Oracle background processes overview

Module 2: Oracle Installation and Configuration

• Prerequisites for Oracle 19c/21c installation
• Oracle Universal Installer (OUI)
• Database Configuration Assistant (DBCA)
• Oracle Net Configuration Assistant (NETCA)
• Post-installation tasks

Module 3: Oracle Database Storage

• Tablespace and datafile management
• Undo tablespace configuration
• Temporary tablespace management
• Oracle Managed Files (OMF)
• Space management and monitoring

Module 4: Oracle User and Security Management

• User creation and privilege management
• Roles and profiles
• Password policies and auditing
• Fine-grained auditing (FGA)
• Unified auditing in Oracle 12c+

Module 5: Oracle Network Configuration

• Oracle Net Services architecture
• Listener configuration and management
• TNS naming methods
• Connection pooling with DRCP
• Oracle Connection Manager (CMAN)

Module 6: Oracle Backup and Recovery Fundamentals

• ARCHIVELOG and NOARCHIVELOG modes
• RMAN backup strategy
• Flashback technologies overview
• Backup validation and testing
• Recovery scenarios and solutions

Module 7: Oracle Patching and Upgrades

• Oracle patch types: PSU, RU, RUR
• OPatch utility for patching
• In-place and out-of-place upgrade
• Database upgrade with DBUA
• AutoUpgrade tool for 19c/21c

Module 8: Oracle Performance Monitoring

• AWR and ADDM reports
• Active Session History (ASH)
• V$ dynamic performance views
• Oracle Enterprise Manager (OEM) monitoring
• Alert log and trace file analysis

Module 9: Oracle Scheduler and Automation

• DBMS_SCHEDULER job creation
• Job chains and windows
• File watcher jobs
• Scheduler monitoring
• Automating DBA tasks with scheduler

Module 10: Oracle High Availability

• Data Guard overview for HA
• Oracle restart and Grid Infrastructure
• Fast Recovery Area (FRA) configuration
• Online operations: Hot patching, online redefinition
• Maximum Availability Architecture (MAA)

Module 11: Oracle 21c New Features

• Blockchain tables
• Native JSON datatype
• Persistent memory database
• AutoML in Oracle 21c
• Oracle 21c on OCI and Autonomous DB

Module 12: Real-Time Projects and Case Studies

• Full DBA setup from scratch
• Production database administration simulation
• End-to-end Oracle DBA project
• Certification and interview preparation

Experience in the Industry Gain knowledge from experts with hands-on Oracle Database Administration experience in enterprise production environments.

Backgrounds at the Top Prominent corporations such as HCL, TCS, Wipro, and Oracle Consulting employ our Oracle DBA trainers.

Clear & Effective Teaching Excellent communication and real-world examples simplify complex Oracle architecture and administration tasks.

Hands-On Learning Focus Students apply skills using live Oracle 19c/21c environments with real DBA tasks and recovery scenarios.

Up-to-Date Knowledge Trainers stay current with Oracle 19c/21c features, AutoUpgrade, and latest Oracle DBA best practices.