ASM Filter Drivers – disks not filtering on reboot



You’ve enabled ASM Filter Drivers, migrated your existing disks, and then after you reboot you see this:

[oracle@oel6solo ~]$ asmcmd afd_lsdsk
Label Filtering Path

You check the ASM Filter Driver state and it says it is loaded and filtering:

[oracle@oel6solo ~]$ asmcmd afd_state
ASMCMD-9526: The AFD state is 'LOADED' and filtering is 'DEFAULT' on host ''

There is one more step that much of the documenation is missing:

[oracle@oel6solo ~]$ $ORACLE_HOME/bin/asmcmd afd_filter -e

Now the ASM FD filtering will survive a reboot:

[oracle@oel6solo ~]$ asmcmd afd_lsdsk
Label Filtering Path
DATA2 ENABLED /dev/sdc
DATA4 ENABLED /dev/sde
DATA3 ENABLED /dev/sdd
DATA1 ENABLED /dev/sdb

Convert your database to use a BIGFILE tempfile

The following commands may be used to convert an 11g or 12c database to use a BIGFILE temporary tablespace datafile instead of the default regular file, which is limited to 32GB. BIGFILEs can grow to 32TB.

This can be useful when loading very large amounts of data into a database, for example for a POC test.

Continue reading

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