Create ASM diskgroups with Dell Powerstore

I recently got an opportunity to do some testing with a Dell Powerstore 5000T all-flash storage array, so I thought I would share some of the notes I made during my testing, for the benefit of any DBAs who might be using one to deliver ASM disks to their Oracle databases.

This will be part of a series of posts that focus on the management of Oracle and ASM with Powerstore, so consider this post as a foundational topic. Nothing especially earth shattering, but some solid points nonetheless.

Oh, and there’s a video too

Continue reading

Configuring DD Boost on Linux for Oracle RMAN

In this post, we are going to install the DD Boost module for Oracle RMAN.

In the previous post, Configuring DD Boost Replication for Oracle RMAN, we enabled DD Boost on the Data Domain and set up storage units that replicate automatically between sites.

In this post, we are going to install and configure the DD Boost for Oracle RMAN module so that our RMAN backups can leverage the performance benefits of DD Boost.

Continue reading

Configuring DD Boost Replication for Oracle RMAN

In this post, we are going to install the DD Boost module for Oracle RMAN.

DD Boost is an optional module that works with Data Domain and a number of applications and databases, including Oracle. DD Boost moves some of the sophisticated deduplication process from the Data Domain appliance to the database server, resulting in a dramatic reduction in network bandwidth and backup times.

A greater than fifty percent reduction in backup times for a full level zero RMAN backup is typical when switching to DD Boost although as always, your mileage may vary.

Continue reading

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Introduction

A couple of weeks ago, Oracle released the long awaited Oracle 12c database, with lots of exciting new features.

A couple of great blog posts have already been done on how to install this, but from what I have seen they rely on Oracle’s OVM technology and/or Oracle Enterprise Linux.

This blog post is a detailed step-by-step of Oracle 12cR1 RAC using VMware Workstation and CentOS 6.4.

Continue reading

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Part XI

Time Required: 20 minutes

Class Materials:

  • Completed Oracle 12c install

The next step is to create a new 12c database!

The dbca is still the method used to create a new database in 12c. But before we launch the installer, we will modify the /etc/oratab file.

Continue reading

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Part X

Time Required: 60 minutes

Class Materials:

  • Oracle 12cR1 Database software

The next step is to install the Oracle 12c database software.

The database install process is largely unchanged from the 11g installer, so this should be familiar terriroty to most DBAs.

Continue reading

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Part IX

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Part IX

Time Required: 60 minutes

Class Materials:

  • Oracle 12cR1 Grid Infrastructure software

Now that we have completed all the preparation steps and the grid pre-install steps, we can install the 12c Oracle Grid Infrastructure software.

The Grid Infrastructure will provide the Cluster software that allows the RAC nodes to communicate, as well as the ASM software to manage the shared disks.

Continue reading

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Part VIII

Time Required: 30 minutes

Class Materials:

  • Oracle 11gR2 Grid Infrastructure software

Next we are going to perform some final steps before we can launch the Oracle Grid Infrastructure install.

The Grid Infrastructure will provide the cluster software that allows the RAC nodes to communicate, as well as the ASM software to manage the shared disks.

To begin, download the zip files from the Oracle software download website and unzip on Ruggero. Make sure you are logged in as the oracle user so that oracle owns the unzipped files.

Continue reading

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Part VII

Time Required: 60 minutes

Class Materials:

  • 20GB of disk space
  • an ASCII text editor

Next we are going to add shared disk for the RAC cluster to use.

In earlier releases of Oracle RAC, a mimimal RAC could be stood up on less than 5GB of ASM disk. With Oracle 12c that is no longer possible.

For this demonstration I am going to create a 20GB shared disk. If you are tight on space you just about shoe horn it into a 10GB disk.

Continue reading

Oracle 12cR1 12.1.0.1 2-node RAC on CentOS 6.4 on VMware Workstation 9 – Part VI

Time Required: 60 minutes

Class Materials:

  • none

Next we are going to clone Ruggero to create the second node of our 12c RAC Magda.

Shut down the VM and go to the VMware interface.

Continue reading