This Oracle 11g training will provide the student a step-by-step guide for configuring and using the Oracle Grid Infrastructure in a single server environment, and it forms the basis for expanding this infrastructure to a clustered server configuration. Advanced database and storage administration tasks are considered, including Oracle Restart and Automatic Storage Management (ASM).

This course covers a portion of the requirements to complete the certification test ORACLE DATABASE 11G: CERTIFIED MASTER EXAM (OCM).

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are:

• ORACLE DATABASE: SQL FUNDAMENTALS

• ORACLE DATABASE: PL/SQL FUNDAMENTALS

• ORACLE DATABASE: ADMINISTRATION I

CONFIGURING THE SERVER FOR GRID INFRASTRUCTURE INSTALLATION

GRID INFRASTRUCTURE INSTALLATION

ORACLE RESTART

ASM CONCEPTS & ARCHITECTURE

USING ASM STORAGE

ASM INSTANCE ADMINISTRATION

ASM STORAGE ADMINISTRATION

This training course provides a step-by-step guide for configuring and using the Oracle Grid Infrastructure in a single server environment, and it forms the basis for expanding this infrastructure to a clustered server configuration. Advanced database and storage administration tasks are considered, including Oracle Restart and Automatic Storage Management (ASM). With this course you will learn about:
• Preparing a host system for the Grid Infrastructure and Oracle RDBMS installations and performing those installations.
• Preparing a host system for ASM storage management.
• Partitioning and configuration of storage devices for ASM storage on both Linux and MS Windows servers.
• Utilizing Oracle Restart for automatic sequencing and restarting of Oracle software components.
• Obtain an introduction to Oracle High-Availability Services including the Server Control and Clusterware Control utilities.
• Review the Oracle server stack architecture including operating system virtualization and storage subsystem virtualization layers.
• Using ASM for storage of some or all database files, thereby providing a database-centric and optimized storage and volume manager.
• Exploiting ASM storage from the Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) and the Enterprise Manager (EM) interface.
• Administration of an ASM instance and management of ASM disk groups.
• Implement advanced storage capabilities including Intelligent Data Placement, High-capacity disk drives and access control privileges.
• Manage storage systems using the ASM Configuration Assistant (ASMCA) and the ASM command-line interface (ASMCMD).
• Migrate a database from traditional file system storage to ASM storage.

Administrators may wish to proceed onto more focused and specialized courses:

• ORACLE DATABASE: ADMINISTRATION II

• ORACLE DATABASE: PERFORMANCE TUNING

• ORACLE DATABASE: SQL TUNING

• ORACLE DATABASE: PARTITIONING & PARALLEL SQL

• ORACLE DATABASE: DATA WAREHOUSING & ORACLE WAREHOUSE BUILDER