Course Outline
ODA X11 Model Family and Platform Architecture
- Positioning of X11-S, X11-L, and X11-HA models.
- Compute, memory, and NVMe flash capacity specifications.
- X11-HA paired servers configured for Oracle RAC.
Oracle Linux, Appliance Software Stack, and Oracle Appliance Manager
- Overview of Oracle Linux and appliance software layers.
- Oracle Appliance Manager and odacli command-line utilities.
- Integration with Oracle Grid Infrastructure and ASM.
Deployment Planning, Network Design, and Checklists
- Site, power, and rack planning requirements.
- Network topology, bonding, and VLAN design considerations.
- Pre-deployment checklists and validation checkpoints.
Appliance Deployment, Provisioning, and Validation
- Initial appliance configuration and registration processes.
- Network and storage provisioning procedures.
- Post-deployment validation and health checks.
Oracle AI Database 26ai on ODA: AI-Native Capabilities
- 26ai feature set available on appliance hardware.
- Coexistence strategies with Oracle Database 19c homes.
- AI-native architecture and workload suitability.
AI Vector Search: Data Model and Vector Indexes
- VECTOR data type and embedding dimensions.
- HNSW and IVF vector index structures.
- Distance metrics and index selection criteria.
AI Vector Search in Practice: Hybrid Search and Tuning
- Hybrid vector indexing with keyword filtering.
- Trade-offs between recall, accuracy, and latency.
- Performance patterns for vector workloads.
Embedded Machine Learning and Select AI
- Select AI functionality for natural language to SQL conversion.
- AI Profiles and provider configuration.
- In-database ONNX embedding models via DBMS_VECTOR_CHAIN.
- Oracle Machine Learning using OML4SQL and OML4Py.
Database Provisioning, DB Systems, and Templates
- Creating database systems using odacli.
- Custom database templates and configuration settings.
- Consolidation patterns on a single appliance.
Oracle ASM and ACFS Storage Management
- ASM disk groups and redundancy levels.
- ACFS file systems and shared storage solutions.
- Rebalancing procedures and capacity planning.
Database Security and Data Protection
- Management of users, roles, and privileges.
- Transparent data encryption and key management practices.
- Auditing, masking, and compliance controls.
Backup and Recovery with RMAN
- RMAN backup strategies specific to appliance databases.
- Configuration of local and remote backup destinations.
- Restore and recovery validation drills.
Performance Monitoring, Diagnostics, and Query Optimization
- AWR, ASH, and SQL tuning workflows.
- Appliance-level resource monitoring techniques.
- Identification of I/O and storage bottlenecks.
Patching, Upgrades, and Migration to 26ai
- Appliance software release 19.32 and clone files.
- Patching database homes and grid infrastructure components.
- Migration procedures for 19c databases to 26ai.
High Availability, RAC, and Disaster Recovery
- RAC configuration on X11-HA systems.
- Failover behavior and service placement strategies.
- Data Guard and standby database strategies.
Hardware Architecture, FRU Replacement, and Health Monitoring
- Component layout and field-replaceable units (FRUs).
- FRU replacement and service procedures.
- Health monitoring and alert threshold configuration.
Oracle ILOM and Out-of-Band Management
- ILOM access and user administration tasks.
- Remote console access and power control mechanisms.
- Firmware updates and event log management.
Oracle Linux KVM Virtualization and VM Administration
- Oracle Linux KVM implementation on ODA.
- Management of database systems and application VMs.
- VM lifecycle management and resource allocation.
- Hard partitioning for licensing compliance.
Network Configuration, Redundancy, and Monitoring
- Bonded interfaces and link redundancy implementation.
- VLAN configuration and client network separation.
- Network monitoring and fault isolation techniques.
Troubleshooting Workshop and Operational Handover
- Structured fault isolation scenarios.
- Review of logs, alerts, and diagnostic evidence.
- Runbooks, escalation procedures, and handover checklists.
Requirements
- Practical experience in Oracle Database administration.
- Proficiency with Oracle Linux command-line operations.
- Foundational knowledge of storage, networking, and virtualization concepts.
- Exposure to Oracle Grid Infrastructure or Oracle RAC is advantageous.
Audience
- Database administrators overseeing Oracle Database Appliance platforms.
- Infrastructure and networking engineers supporting appliance deployments.
- Technical professionals transitioning to Oracle AI Database 26ai on engineered systems.
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Greg was very patient and helpful
