This hands-on course addresses specific administration features available in Oracle Warehouse builder 10g Release 2 (OWB). The course covers the administration tasks that may be performed during a data warehouse development process and also the administration tasks that are performed to maintain a fast and efficient Warehouse Builder system.
Students will learn strategies of administering an OWB environment. The course discusses strategies on how to configure and manage repositories, on backup and recovery, on how to manage the Control Center service, utilizing Real Application Clusters and more. Guided lab practices will give the students a hands-on opportunity to learn the administrative functionalities of OWB. This course is targeted for OWB administrators; not Warehouse Builder ETL programmers.
Learn to:
- Diagnose and debug errors (not mapping debugging)
- Apply performance enhancement methods
- Install and setup OWB in a RAC environment
- Manage OWB security
- Configure OWB for a multi-user environment
- Manage configuration and runtime settings
Note:
The current version of this course is presented using OWB 10gR2, however this course is also suitable for OWB 11gR1 customers. The user interface differences between OWB 10gR2 and 11gR1 are very minor and hence are not included in this course's lab practices.