My Oracle Support Banner

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:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Solaris on SPARC (64-bit)


Standalone -- 11204 -- Solaris10 (Oracle Solaris 10 8/11 SPARC) local containers -- non-Exadata

Configuring Oracle 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 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
* 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/
   -rwsr-x---   1 root     dba      1359104 Aug 21  2013 ./oracle/product/*


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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