Tag Archives: asm

Delete a storage snapshot of an Oracle 19c RAC database using ASM diskgroups with Dell PowerMax.

Posted on by • Posted in ASM, Filter Driver, ASMFD, Filter Drivers,, Oracle, RAC • Tagged , , , , , , , , , , , , • Leave a comment

In this post I am going to explore deleting a storage snapshot of an Oracle 19c RAC database created on a Dell PowerMax storage array.

This post is a companion to the video Dell PowerMax – Refresh a storage snapshot of Oracle RAC database. and a follow on from the blog post Create a storage snapshot of an Oracle 19c RAC database using ASM diskgroups with Dell PowerMax.

This blog post assumes some basic knowledge of PowerMax storage concepts. If you need a basic introduction please check out my PowerMax basics video.

These examples will use the Solutions Enabler command line method of managing the PowerMax, unlike the video which uses the Unisphere graphical interface.

Continue reading →

Refresh a storage snapshot of an Oracle 19c RAC database using ASM diskgroups with Dell PowerMax.

Posted on by • Posted in ASM, Filter Driver, ASMFD, Filter Drivers,, Oracle, Video • Tagged , , , , , , , , , , , , • Leave a comment

In this post I am going to explore refreshing a storage snapshot of an Oracle 19c RAC database created on a Dell PowerMax storage array.

This post is a companion to the video Dell PowerMax – Refresh a storage snapshot of Oracle RAC database. and a follow on from the blog post Create a storage snapshot of an Oracle 19c RAC database using ASM diskgroups with Dell PowerMax.

This blog post assumes some basic knowledge of PowerMax storage concepts. If you need a basic introduction please check out my PowerMax basics video.

These examples will use the Solutions Enabler command line method of managing the PowerMax, unlike the video which uses the Unisphere graphical interface.

Continue reading →

Create a storage snapshot of an Oracle 19c RAC database using ASM diskgroups with Dell PowerMax.

Posted on by • Posted in ASM, Filter Driver, ASMFD, Filter Drivers,, Oracle, RAC • Tagged , , , , , , , , , , , • 1 Comment

In this post I am going to explore creating a storage snapshot of an Oracle 19c RAC database using ASM disks from PowerMax storage.

This post is a companion to the video Dell PowerMax – Create a snapshot of an Oracle RAC database.

This blog post assumes some basic knowledge of PowerMax storage concepts. If you need a basic introduction please check out my PowerMax basics video.

These examples will use the Solutions Enabler command line method of managing the PowerMax, unlike the video which uses the Unisphere graphical interface.

Continue reading →

Create Oracle ASM diskgroups with Dell PowerMax and PowerPath

Posted on by • Posted in ASM, ASMLib, Filter Driver, ASMFD, Filter Drivers,, Oracle, Video • Tagged , , , , , , , , , , , , • Leave a comment

In this post I am going to explore adding a new ASM diskgroup to an Oracle 19c RAC using PowerMax storage.

We will follow best practices as laid out in H17390 Deployment Best Practices Guide for Oracle with Powermax. This post is a companion to the video Create Oracle ASM diskgroups with Dell PowerMax and PowerPath.

This blog post assumes some basic knowledge of PowerMax storage concepts. If you need a basic introduction please check out my PowerMax basics video.

These examples will use the Solutions Enabler command line method of managing the PowerMax, unlike the video which uses the Unisphere graphical interface.

Continue reading →

Creating a Storage Snapshot of an Oracle database using Dell Powerstore

Posted on by • Posted in ASM, Linux, Oracle, Video, VMware • Tagged , , , , , • Leave a comment

Storage level snapshot are an incredibly fast and space efficient method to create usable clones of an Oracle database. In this post we’ll create a storage-level snapshot of a Oracle database using a Dell Powerstore storage array. Our database spans two ASM diskgroups, and will be mounted to a second server.

Note: There is a video of this post.
Continue reading →

Create ASM diskgroups with Dell Powerstore

Posted on by • Posted in ASM, Linux, Oracle, Video, VMware • Tagged , , , , , , , • 1 Comment

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 →

“grid infrastructure or clusterware home not found” when using DBCA on Oracle 11gR2 64-bit on Windows 2008

Posted on by • Posted in ASM, Oracle, VMware • Tagged , , , • 2 Comments

When using the DBCA tool under Oracle 11gR2 64-bit on Windows 2008, and trying to specify ASM as the file storage, the following error is encountered:

“grid infrastructure or clusterware home not found”

The DBCA tool must be run as Administrator, even if the account you are using is already an Administrator privileged account.

If you launch DBCA from the command line, the CMD executable must be launched with the Run As Administrator option.

 

Error while detecting Oracle Grid Infrastructure. ASMCA needs Oracle Grid Infrastructure to configure ASM

Posted on by • Posted in ASM, Linux, Oracle • Tagged , , , , • 1 Comment

You installed the Grid Infrastructure using the silent software-only option:

./runInstaller -silent -force -responseFile $HOME/grid.rsp

 
When you try to create the ASM instance and a diskgroup, the asmca command fails with:

Error while detecting Oracle Grid Infrastructure. 
ASMCA needs Oracle Grid Infrastructure to configure ASM.

 
This is because the CRS components still need to be configured, you can do this as the root user as follows:

[root@localhost ~]# $ORACLE_HOME/perl/bin/perl -I \
  $ORACLE_HOME/perl/lib -I \
  $ORACLE_HOME/crs/install $ORACLE_HOME/crs/install/roothas.pl
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE 
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE 
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node localhost successfully pinned.
Adding Clusterware entries to upstart

localhost     2013/01/10 15:06:48     /u01/app/11.2.0/grid/cdata/localhost/backup_20130110_150648.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server

 
Once this is done, the asmca command can be run successfully.

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part V

Posted on by • Posted in ASM, Linux, Oracle, RAC, VMware • Tagged , , , , , , , • Leave a comment

Time Required: 20 minutes

Class Materials:

  • oracleasm-support-2.1.7-1.el5.x86_64.rpm
  • oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm
  • oracleasmlib-2.0.4-1.el5.x86_64.rpm

Next we will install the ASMLib drivers that simplify management of ASM on Linux.

ASMLib is an interface between block devices presented to Linux, and the Oracle ASM software that executes as the Oracle user.

Continue reading →