Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 49 hours
Course Outline
Introduction and Core Fundamentals
- Overview of Oracle Database architecture
- Distinction between a database instance and a database
- Memory and process architecture, including SGA, PGA, and background processes
- Parameter files, control files, redo logs, alert logs, and trace files
- General introduction to Oracle Multitenant technology (CDB and PDB, and their scope in SE2)
Environment Setup and Installation
- Prerequisites and identification of supported platforms
- Step-by-step installation of Oracle Database 19c SE2
- Initial database creation using DBCA
- Post-installation configuration: setting up listeners, services, and Enterprise Manager Express
Administrative Tools and Connectivity
- Establishing connections to an Oracle Database instance
- SQL*Plus: essential commands and administrative tasks
- Utilizing Oracle SQL Developer for efficient management
- Oracle Enterprise Manager Express: monitoring and common administrative tasks
- Configuration of Net Services and listeners
Instance and Database Operations
- Various startup and shutdown modes
- Database creation via DBCA and SQL commands
- Management of initialization parameters and dynamic performance views (V$)
- Oversight of alert logs, trace files, and the Automatic Diagnostic Repository
- Utilization of the data dictionary
Connectivity and Naming Strategies
- Establishing stable network connections
- Naming methods: Easy Connect, Local Naming, and Directory Naming
- Management of database services
- Configuration of Listener agents (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Scope
- Understanding CDB and PDB concepts
- PDB creation utilizing PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters
- PDB management, including modes, parameters, and host/port configuration
- Procedures for PDB removal
- Shared server configuration involving SGA, PGA, and shared server mode
Storage Management
- Tablespaces and datafile management
- Temporary and undo tablespace administration
- Management of segments, extents, blocks, and space allocation
- Handling file growth, Oracle Managed Files (OMF), and datafile migration
Security and Audit Frameworks
- Users, roles, and privileges, adhering to the principle of least privilege
- Profiles, password policies, and resource limit enforcement
- Core auditing concepts specific to Oracle SE2
- Auditing of critical system operations
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery objectives
- RMAN configuration and catalog management
- Recovery scenarios addressing media failures, point-in-time recovery, and common issues
- Validation of backup integrity
Monitoring and Performance Tuning
- Utilizing execution plans via EXPLAIN PLAN and AUTOTRACE
- Diagnosis of wait events and common performance issues
- Proactive monitoring using data dictionaries and dynamic views
- Specific tuning methods applicable to SE2
Migration from Oracle 11g to 19c
- Review of upgrade paths and prerequisites
- Utilization of pre-auto-upgrade tools
- Validation steps and resolution of incompatibilities
- Post-upgrade tasks and handling of deprecated features
- Comprehensive post-migration testing
Course Conclusion
- General summary of key concepts
- Recommendations for best practices
Summary and Next Steps
Requirements
- A solid grasp of relational database concepts
- Proficiency in SQL
- Basic knowledge of operating systems such as Windows or Linux
Target Audience
- Database administrators
- System administrators
- IT professionals responsible for overseeing Oracle environments
Testimonials (1)
good explanation on each points and provide assignment for practices.
