Course Outline
ODA X11 Model Range and System Architecture
- Positioning of X11-S, X11-L, and X11-HA models
- Specifications for compute power, memory, and NVMe flash capacity
- X11-HA paired server configurations for Oracle RAC
Oracle Linux, Appliance Software Suite, and Oracle Appliance Manager
- Oracle Linux and appliance software layers
- Usage of Oracle Appliance Manager and the odacli interface
- Integration of Oracle Grid Infrastructure and ASM
Deployment Strategy, Network Topology, and Compliance Checklists
- Planning inputs for site, power, and rack layout
- Designing network topologies, bonding, and VLANs
- Pre-deployment verification checklists and validation milestones
Appliance Rollout, Provisioning, and Verification
- Initial configuration and registration of the appliance
- Tasks related to network and storage provisioning
- Post-deployment health checks and system validation
Oracle AI Database 26ai on ODA: Native AI Features
- 26ai feature capabilities on appliance hardware
- Coexistence with Oracle Database 19c instances
- AI-native architecture and workload suitability
AI Vector Search: Data Modeling and Vector Indexing
- VECTOR data types and embedding dimensions
- HNSW and IVF vector index structures
- Selection of distance metrics and optimal indexing
Practical AI Vector Search: Hybrid Retrieval and Optimization
- Hybrid vector indexes combined with keyword filtering
- Balancing recall, accuracy, and latency
- Performance patterns for vector-based workloads
Integrated Machine Learning and Select AI
- Convert natural language queries to SQL via Select AI
- Configuration of AI Profiles and service providers
- In-database ONNX embedding models using DBMS_VECTOR_CHAIN
- Oracle Machine Learning utilizing OML4SQL and OML4Py
Database Provisioning, DB Systems, and Templates
- Creating database systems via odacli
- Developing custom database templates and configurations
- Consolidation strategies on a single appliance
Oracle ASM and ACFS Storage Administration
- ASM disk groups and redundancy configurations
- ACFS file systems and shared storage setups
- Rebalancing operations and capacity forecasting
Database Security and Data Integrity
- Management of users, roles, and privileges
- Transparent Data Encryption and key management
- Auditing, data masking, and compliance controls
Backup and Recovery using RMAN
- RMAN backup strategies for appliance-hosted databases
- Configuring local and remote backup locations
- Validation drills for restore and recovery processes
Performance Monitoring, Diagnostics, and Query Tuning
- AWR, ASH, and SQL tuning workflows
- Resource monitoring at the appliance level
- Identification of I/O and storage performance constraints
Patching, Upgrades, and Migration to 26ai
- Appliance software release 19.32 and clone files
- Patching database homes and grid infrastructure
- Migrating 19c databases to 26ai
High Availability, RAC, and Disaster Recovery
- RAC setup on X11-HA systems
- Failover dynamics and service distribution
- Data Guard and standby architecture strategies
Hardware Design, FRU Swaps, and Health Tracking
- Component layout and field replaceable units (FRUs)
- Procedures for FRU replacement and service
- Health monitoring and alert threshold settings
Oracle ILOM and Out-of-Band Administration
- ILOM access and user management
- Remote console access and power control
- Firmware updates and event log management
Oracle Linux KVM Virtualization and VM Management
- Implementing Oracle Linux KVM on ODA
- Management of database systems and application VMs
- VM lifecycle management and resource distribution
- Hard partitioning for licensing compliance
Network Setup, Redundancy, and Oversight
- Bonded interfaces and link redundancy
- VLAN configuration and client network segmentation
- Network monitoring and fault isolation techniques
Troubleshooting Clinic and Operational Transition
- Scenario-based structured fault isolation
- Review of logs, alerts, and diagnostic evidence
- Runbooks, escalation protocols, and handover checklists
Requirements
- Practical experience in Oracle Database administration
- Proficiency with Oracle Linux command-line interfaces
- Foundational knowledge of storage, networking, and virtualization principles
- Previous exposure to Oracle Grid Infrastructure or Oracle RAC is beneficial
Target Audience
- Database administrators accountable for Oracle Database Appliance infrastructure
- Infrastructure and networking professionals supporting appliance rollout
- Technical personnel transitioning to Oracle AI Database 26ai on engineered platforms
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
