ALTER DISKGROUP .. SET ATTRIBUTE 'storage.type'='zfssa': ORA-15032, ORA-15242, ORA-15287, ORA-15285 (Doc ID 1634592.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

Symptoms

Configuring Oracle 11.2.0.4.0 using an ASM diskgroup over a ZFS Storage through a FCC SAN and gettting following error:

Additional information:
* Customer states that this is working on Solaris11 (same configuration).
* The ZFS storage LUNS are not published with NAS but are published as devices withing Solaris.
* Using Oracle M4000 server with 64 GB of memory connected with FCAL technology (SAN) to a ZFS Storage 7320 using Oracle Enterprise Edition 11.2.0.4 using ASM.
   In the ZFS Storage two pools of 2TB capacity using read and write optimizers.

Already checked/tried, but same problem:
* The diskgroup is EXTERNAL and COMPATIBILITY and DATABASE COMPATIBILITY has been set to 11.2.0.4.0
* Tried without dNFS configured in ASM and with dNFS configured in ASM (Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0).
   When dNFS was enabled in ASM, 'select * from v$dnfs_servers;' returned no rows. This is likely caused because the LUNs are not shared through the NFS Share.
   User/Customer maintains that dNFS is not needed as they want to use HCC over FCAL connections (not NFS over Ethernet). Also this would not explain why they had it working
   on Solaris11 and it does not work on Solaris10 (same configuration).
* SNMP doesn't need to be enabled for zfssa raw disks
* Checked oradism permissions, and these are fine:
   $ ls -ltra ./oracle/product/11.2.0.4/grid/bin/oradism
   -rwsr-x---   1 root     dba      1359104 Aug 21  2013 ./oracle/product/11.2.0.4/grid/bin/oradism*

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.