Kursplan
ODA X11 Model Family and Platform Architecture
- Positioning of X11-S, X11-L, and X11-HA models.
- Compute, memory, and NVMe flash capacity specifications.
- Paired server configuration for Oracle RAC on X11-HA.
Oracle Linux, Appliance Software Stack, and Oracle Appliance Manager
- Overview of Oracle Linux and appliance software layers.
- Utilization of Oracle Appliance Manager and the odacli command line.
- Integration with Oracle Grid Infrastructure and ASM.
Deployment Planning, Network Design, and Checklists
- Inputs for site, power, and rack planning.
- Network topology, bonding, and VLAN design considerations.
- Pre-deployment checklists and validation checkpoints.
Appliance Deployment, Provisioning, and Validation
- Initial appliance configuration and registration processes.
- Tasks related to network and storage provisioning.
- Post-deployment validation procedures and health checks.
Oracle AI Database 26ai on ODA: AI-Native Capabilities
- Overview of the 26ai feature set on appliance hardware.
- Coexistence strategies with Oracle Database 19c homes.
- AI-native architecture and workload suitability.
AI Vector Search: Data Model and Vector Indexes
- The VECTOR data type and embedding dimensions.
- Structure of HNSW and IVF vector indexes.
- Selection of distance metrics and appropriate indexes.
AI Vector Search in Practice: Hybrid Search and Tuning
- Implementing hybrid vector indexes with keyword filtering.
- Balancing recall, accuracy, and latency trade-offs.
- Performance patterns for vector workloads.
Embedded Machine Learning and Select AI
- Converting natural language to SQL using Select AI.
- Configuration of AI Profiles and providers.
- In-database ONNX embedding models via DBMS_VECTOR_CHAIN.
- Oracle Machine Learning utilizing OML4SQL and OML4Py.
Database Provisioning, DB Systems, and Templates
- Creating database systems using odacli.
- Development of custom database templates and configurations.
- Consolidation patterns on a single appliance.
Oracle ASM and ACFS Storage Management
- ASM disk groups and redundancy levels.
- ACFS file systems and shared storage mechanisms.
- Rebalancing processes and capacity planning.
Database Security and Data Protection
- Management of users, roles, and privileges.
- Transparent data encryption and key management practices.
- Auditing, data masking, and compliance controls.
Backup and Recovery with RMAN
- RMAN backup strategies for appliance databases.
- Local and remote backup destination configuration.
- Restore and recovery validation drills.
Performance Monitoring, Diagnostics, and Query Optimization
- AWR, ASH, and SQL tuning workflows.
- Resource monitoring at the appliance level.
- Identification of I/O and storage bottlenecks.
Patching, Upgrades, and Migration to 26ai
- Appliance software release 19.32 and clone file management.
- Patching procedures for database homes and grid infrastructure.
- Migration strategies from 19c to 26ai.
High Availability, RAC, and Disaster Recovery
- RAC configuration specifics for X11-HA.
- 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).
- Procedures for FRU replacement and service.
- Health monitoring systems and alert thresholds.
Oracle ILOM and Out-of-Band Management
- Access and user administration via ILOM.
- Remote console and power control features.
- Management of firmware and event logs.
Oracle Linux KVM Virtualization and VM Administration
- Deployment of Oracle Linux KVM on ODA.
- Management of database systems and application VMs.
- VM lifecycle management and resource allocation.
- Hard partitioning techniques for licensing purposes.
Network Configuration, Redundancy, and Monitoring
- Bonded interfaces and link redundancy setups.
- VLAN configuration and client network separation.
- Network monitoring and fault isolation techniques.
Troubleshooting Workshop and Operational Handover
- Scenarios for structured fault isolation.
- Review of log, alert, and diagnostic evidence.
- Preparation of runbooks, escalation paths, and handover checklists.
Krav
- Arbetsbaserad erfarenhet av Oracle Database-administration
- Kännedom om Oracle Linux-kommandoradslinjeoperationer
- Grundläggande förståelse för begrepp inom lagring, nätverk och virtualisering
- Erfarenhet av Oracle Grid Infrastructure eller Oracle RAC är en fördel
Målgrupp
- Databasadministratörer som ansvarar för Oracle Database Appliance-plattformar
- Infrastruktur- och nätverksengineer som stödjer implementering av applikanser
- Teknisk personal som övergår till Oracle AI Database 26ai på specialbyggda system
Vittnesmål (2)
bra förklaring av varje punkt och ge inlämningsuppgifter för övning.
Piseth Ben - ACLEDA Bank Plc.
Kurs - Oracle Database 19c: SQL Tuning Workshop
Maskintolkat
Greg var mycket tålmodig och hjälpsam
Chris Havel - Encyclopaedia Britannica
Kurs - ORACLE SQL Fundamentals
Maskintolkat
