Implementing Oracle on NetApp Storage Systems Training (ORONSS)

Implementing Oracle on NetApp Storage Systems Training

Course Delivery

This Course is available in the following format:

Request this course in a different delivery format

GSA Schedule 70 Saving for Government Customers

Course Overview:

Implementing Oracle on NetApp Storage Systems Training (ORONSS) Course Description

In this Implementing Oracle on NetApp Storage Systems Training (ORONSS) course you learn how to implement an Oracle Database solution in a NetApp storage environment. Through lecture and hands-on exercises, you practice discovering, planning, designing and provisioning an Oracle environment. In this class you install Oracle, configure an Oracle database; use several solutions to back up Oracle databases, and restore an Oracle database. The material of this class is not meant to provide an exhaustive study of Oracle. The purpose of this Implementing Oracle on NetApp Storage Systems Training (ORONSS) class is to practice the specific steps of the deployment and administration of an Oracle database using NetApp clustered Data ONTAP and NetApp integrated data protection technology.

Customize It:

● If you are familiar with some aspects of this course, we can omit or shorten their discussion.
● We can adjust the emphasis placed on the various topics or build the Implementing Oracle on NetApp Storage Systems Training course around the mix of technologies of interest to you (including technologies other than those included in this outline).
● If your background is nontechnical, we can exclude the more technical topics, include the topics that may be of special interest to you (e.g., as a manager or policy-maker), and present the Implementing Oracle on NetApp Storage Systems Training course in manner understandable to lay audiences.

Audience / Target Group:

The target audience for this Implementing Oracle on NetApp Storage Systems Training course:

Anyone familiar with Oracle database servers and NetApp storage systems is considered a typical student of this course.

Related Courses:

Implementing Microsoft SharePoint on NetApp Storage Systems (MSSP)
Implementing Microsoft SQL Server 2012 on NetApp Storage Systems Training (MSSQL)

Class Prerequisites:

The knowledge and skills that a learner must have before attending this Implementing Oracle on NetApp Storage Systems Training course are as follows:

● Data ONTAP Cluster-Mode Fundamentals (WBT)
● Familiar with Data ONTAP 7-Mode administration
● Familiar with Data ONTAP Cluster Mode Administration

What You Will Learn:

Upon completing this Implementing Oracle on NetApp Storage Systems Training course, learners will be able to meet these objectives:

● Describe key customer problems attending Oracle solutions and the advantages of implementing Oracle solutions on NetApp technology to solve these problems
● Describe key architecture decisions for planning the deployment of Oracle on NetApp Storage systems operating in 7-Mode or Cluster-Mode
● Set up NetApp storage systems for Oracle databases
● Install, configure and set up Oracle servers and Oracle databases on NetApp storage systems
● Use NetApp technology for backing up, recovering, and cloning of Oracle databases

Implementing Oracle on NetApp Storage Systems Training – Course Syllabus:

Module 1 Implementing Oracle on NetApp Storage Systems Overview

Describe components of Oracle databases
Describe key issues that are often experienced with Oracle deployments
Describe the advantages of implementing Oracle solutions on NetApp technology

Module 2 Designing and Planning an Oracle Implementation

Describe key design considerations for an Oracle deployment on NetApp storage systems
Create the storage design to implement Oracle databases on NetApp storage systems

Module 3 Setting Up NetApp Storage Systems of Oracle Databases

Configure clustered Data ONTAP network interface groups, logical interfaces (LIFs), and interface failover
Configure clustered Data ONTAP virtual storage servers (Vservers)
Provision storage for a Vserver
Access a Data ONTAP cluster
Configure export policies
Implement and validate a storage design on the clustered Data ONTAP operating system

Module 4 Installing an Oracle Server and Oracle Databases

Describe requirements and prerequisites for installing an Oracle server and databases
Install an Oracle database

Module 5 Oracle dNFS and NetApp Storage

Enable direct NFS (dNFS) for an Oracle database
Explain what dNFS is and how it differs from kernel Network File Systems (kNFS)
List the database objects that show you the dNFS database traffic
Configure multiple paths for dNFS

Module 6 Using Oracle ASM with NetApp Storage

Define Automatic Storage Management (ASM) for an Oracle database on NetApp storage
Define the Oracle ASM Library (ASMLib)
Describe how to install and configure ASM and ASMLib to provision and configure storage and LUNs
Create an ASM database
Use ASM to create an application database

Module 7 Backup and Recovery Methods for Oracle

Describe specific storage design requirements for the backup and recovery of Oracle databases
Back up and recover an Oracle database by using SnapManager for Oracle (SMO)
Back up and recover an Oracle database by using Snap Creator Framework

Module 8 Cloning Oracle Databases

Describe use cases for cloning Oracle databases
Identify the components that are needed for a clone creation
Identify which objects to clone
Use NetApp SnapManager for Oracle (SMO) to clone an Oracle database

Module 9 Disaster Recovery for Oracle Databases

Describe disaster recovery plans and issues for Oracle databases
Describe NetApp SnapMirror technology for Oracle databases
Describe a SnapMirror disaster recovery scenario
Implement recovery options
Leverage Oracle Data Guard when implementing Oracle on NetApp storage

Implementing Oracle on NetApp Storage Systems Training – Lab Exercises

Lab 1-1 Use login credentials for the Linux host
Lab 1-2 Verify the necessary file systems
Lab 1-3 Verify that initial databases are available
Lab 1-4 Identify NetApp cluster components
Lab 2-1 Identify the components of the Oracle database
Lab 2-2 Describe the use case that is associated with the storage design
Lab 3-1 Log in to cluster1_01 VSIM
Lab 3-2 Create a Vserver
Lab 3-3 Modify the Vserver to enable the NFS protocol, assign the default aggregates and add the appropriate DNS
Lab 3-4 Add the appropriate LIFS for your Vserver
Lab 3-5 Define the export policy for the Vserver
Lab 3-6 Modify the Vserver vsadmin user
Lab 3-7 Provision storage on the Vserver for the Oracle database server
Lab 4-1 Validate and prepare parameters for the Linux host
Lab 4-2 Validate and prepare parameters for the Data ONTAP host
Lab 4-3 Define the file systems for the Oracle database
Lab 4-4 Create an Oracle database
Lab 5-1 Enable dNFS for an Oracle database
Lab 5-2 Verify that the database is using dNFS
Lab 5-3 Disable dNFS for a database (optional)
Lab 6-1 Create a Vserver
Lab 6-2 Modify the Vserver to enable iSCSI protocol, assign the default aggregates and add the appropriate DNS information
Lab 6-3 Add the appropriate LIFs for your Vserver
Lab 6-4 Create groups, create users, and modify the Vserver vsadmin user
Lab 6-5 Start the iSCSI service for this Vserver
Lab 6-6 Provision storage for the database
Lab 6-7 Configure and validate iSCSI service on the Linux host
Lab 6-8 Prepare the Linux host for Device Mapper and discovery of LUNs
Lab 6-9 Start the Oracle Grid Infrastructure
Lab 6-10 Prepare the LUNs on the Linux host for use by ASM
Lab 6-11 Create ASM disk groups with iSCSI LUNs
Lab 6-12 Create the oraiscsi database through DBCA
Lab 6-13 Move the clustered Data ONTAP operating system and LUNs
Lab 7-1 Start the grid infrastructure
Lab 7-2 Install SnapDrive for UNIX
Lab 7-3 Install and configure SMO
Lab 7-4 Configure a SMO repository
Lab 7-5 Create an SMO profile for oraclass
Lab7-6 Create an SMO backup for oraclass
Lab 7-7 Restore an Oracle database
Lab 7-8 Install Snap Creator Framework for Oracle database servers
Lab 7-9 Set up the Snap Creator configuration file to back up your database
Lab 7-10 Restore the Oracle database using Snap Creator Framework
Lab 8-1 Create a SMO profile for oraclass
Lab 8-2 Delete a clone
Lab 8-3 Define the Snap Creator configuration for a clone workflow
Lab 8-4 Prepare a host for the new cloned database
Lab 8-5 Configure the Oracle database using Snap Creator Framework

Whether you are looking for general information or have a specific question, we want to help!

Request More Information

Print Friendly, PDF & Email