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

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

Running Swingbench oewizard in lights-out mode and connecting as SYSDBA

It seemed a simple enough thing to need to do;

Use the Swingbench oewizard tool to generate 1TB of data in my test database on DSSD, using the lights-out mode.

I am guessing everyone else knows how to do this, but it wasn’t obvious to me! And after spending nearly thirty minutes online trying to figure out how to connect through JDBC thin drivers as a SYSDBA privileged account, I finally realized that you specify the SYS password, but you DON’T specify the SYS username

So for any other DBAs as dense as me; here is how to create a 1TB Swingbench SOE schema using the oewizard in lights-out mode:

./oewizard -cl -create -scale 1000 -u soe -p soe -ts soe -tc 96 -df +DATA -cs //localhost:1521/dssd04 -dt thin -part -allindexes -bigfile -dbap oracle

After indexes are added, the SOE tablespace will be about 2.2TB.