Training objectives
- Increase knowledge of the Oracle database architecture
- Configure Oracle databases according to best practices
- Secure the database (user management, privileges and roles)
- Administer Oracle databases
- Manage Oracle network protocols
- Acquire knowledge in Oracle Enterprise Manager Database Console (Monitoring) and Oracle Recovery Manager
- Maintenance management (patching)
Topics
- Storage, process and, memory structures as well as Oracle Automatic Storage Management (ASM)
- Oracle network infrastructure (Oracle Net, listener)
- Maintenance strategy (datapatch, optach)
- Space management
- Oracle Automatic Diagnostic Repository (ADR)
- Job Scheduler (DBA_SCHEDULER)
- Oracle Data Pump export/import utility
- Backup & recovery with RMAN
- Oracle optimizer
- Globalization support
- Oracle Database Upgrade Assistant
Method
- Presentation with countless practical exercises and trainings
- Case studies, live demos, discussions
- Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
Target groups
- Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting Oracle databases
Prerequisite Training to the Oracle DBA essentials
-
Our dbi InSite Workshop Oracle DBA Basics is a prerequisite if you don’t have any knowledge of Oracle.
Related Trainings & Events
- dbi InSite Workshop Linux for Oracle DBAs
- dbi InSite Workshop Oracle Backup & Recovery
- dbi InSite Workshop Oracle Performance Tuning
- dbi InSite Workshop Oracle Data Guard
- dbi InSite Workshop Oracle Database Appliance (ODA)
Language & documentation
- Workshop in English, French or German
- Documentation: content details, scripts, case study solutions as PDF file (in English)
Equipment
- On-site training: As this training is provided on a Cloud platform, participants must be equipped with a laptop in order to access the Cloud infrastructure through an ssh client.
More information on dbi services:
- Performance Management: Reviews and Tuning
- dbi services is Oracle Platinum Partner