Description

This internship will teach you how to administer Oracle's Grid Infrastructure solution. You will see how to install and configure ASM to manage disk volumes and ensure performance. You will also learn how to use the Oracle Restart tool to manage the shutdown/startup of all components of a database.

Who is this training for ?

For whom ?

This course is aimed at database administrators, technical consultants, support engineers.

Prerequisites

Training objectives

Learn about Oracle Clusterware and ASM architecture Install the Grid Infrastructure tool Migrate a database to ASM Implement efficient disk volume management Manage a Database with the Oracle Restart Tool

Training program

• Introduction
  • Basic grid components.
  • Oracle Clusterware and ASM architecture.
  • Disk groups.
  • File systems clustered.
• Installer Grid Infrastructure
  • Hardware configuration and the SYSASM privilege.
  • Installing ASMLib.
  • Disk and network configuration.
  • DNS and DHCP configuration .
  • Grid Plug and Play considerations.
  • Tasks to complete after installation.
  • Exercise: Install the Grid Infrastructure tool.
• Oracle Restart
  • The installation phases.
  • Oracle Restart.
  • CRSCTL and SRVCTL utilities.
  • Exercise: Attach a base of data to be managed by the Oracle Restart tool.
• L'instance ASM
  • ASM initialization parameters.
  • Adjust the parameters of ASM instances in SPFILE files.
  • Dynamic views.
  • Start ASM instances with ASMCA and ASMCMD.
  • Start and stop the ASM listener process.
  • Managing ASM password files.
  • Exercise: rnConfigure the ASM instance and save the settings file.
• ASM disk groups
  • Create and delete ASM disk groups.
  • Attributes.
  • Maintenance tasks.
  • Dynamic rebalancing.
  • Preferred failure groups for reading.
  • Show ASM disk statistics.
  • Exercise: r nConfigure the disk groups needed for database migration.
• ASM files
  • Different client tools to access ASM files.
  • Fully qualified ASM file names.
  • Create ASM files, directories and aliases.
  • Manage disk group templates.
  • ASM file names.
  • Global ownership change (files/privileges).
  • Commands SQL and file names.
  • Exercise: Migrate a database to ASM.
• Flex ASM
  • Architecture and deployment alternatives.
  • Configure and manage Flex ASM.
  • Monitor Flex ASM connections.
  • Transfer an ASM client.
  • Exercise: Implementation of a Flex ASM architecture.