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

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

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

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

Solving INS-06006: Passwordless SSH connectivity during Oracle 19c RAC install

I was recently installing Oracle 19c RAC on a pair of servers running OEL8 UEK.

During the install of Grid Infrastructure the installer repeatedly failed the verification check stating that:

“[INS-06006] Passwordless SSH connectivity not set up between the following nodes(s)”

It is worth remembering that Oracle offers a relatively simple method to set up passwordless ssh connections between machines, which I had used prior to trying to install RAC:

In the Grid Infrastructure directory there is a script called sshUserSetup.sh

Continue reading

Relocating the OCR/Voting disks for a 12c RAC

There are many examples of this one, this is again more for my benefit than anyone else’s.

The following shows relocating the OCR and voting disks on a 12c RAC.

No downtime is needed.  You only need to execute these commands on one node.  Log in as root and source the Grid Infrastructure environment to make these changes:

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