Adding VVols to vCenter from a Dell EMC Unity all flash array

The Dell EMC Unity array is a capable mid-market platform able to support a variety of workloads.

In the all-flash configuration it delivers good performance for Oracle databases, and with the ability to support VVols is a good choice for databases virtualized with VMware ESX 6.

The following blog post walks you through adding VVol based shared storage for an Oracle 12c RAC using ASM and virtualized on VMware ESX 6.

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

UDEV rules for ASM disks on RHEL7

On this blog and elsewhere you will find UDEV rules examples for setting device ownership and naming consistency on older versions of Linux.

With RHEL7 some of the syntax has changed slightly.

This example was created using OEL7 with the Red Hat kernel, but should also work on Red Hat and CentOS.

Continue reading

Oracle User Profiles; Verifying and Changing the default profile

This is an issue that keeps tripping me up in the development lab.

I create a quick database, and then after some time I go back to try to log in, and get:

ORA-28002: the password will expire within 7 days

And then I spend a while trying to figure out how to disable the password expiry component of the profile.

Here then, for my benefit as much as anyone else, is my quick guide to checking the user profile, and then disabling security components that cause headaches in the development lab.

Continue reading

IPO announced? Be sure your Oracle licenses are in order…

I have stated this before. I am not a lawyer.

Neither am I an investment expert. Heck I ploughed money into Transocean two months before the Deepwater Horizon sank to the bottom of the Gulf and left a destructive oily mess all over the Gulf Coast.

So don’t take any stock picks from me.

But on a recent trip to the Midwest I met with a customer in an interesting predicament.

Continue reading