HCC solaris

Robeen

Solaris 11.4

ZFS storage

Oracle DB 12.1.0.2 (RAC 2 nodes)

Hello Team,

I am getting error below when enabling HCC. Can anyone please help?

Please have a look at MOS 1634592.1

[email protected]:~$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 11 17:23:54 2019

Version 19.3.1.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.1.0.0

SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'cell.smart_scan_capable' = 'TRUE';

ALTER DISKGROUP DATA SET ATTRIBUTE 'cell.smart_scan_capable' = 'TRUE'

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15242: could not set attribute cell.smart_scan_capable

ORA-15287: could not set disk group attribute cell.smart_scan_capable due to

incompatible disks

ORA-15285: disk 'AFD:DATA1' violates disk group attribute

1. cell.smart_scan_capable

Thanks,

Joe

Nik

Hi.

Please more clear Your configuration:

   Are You use iSCSI or dNFS ?

  Is SNMP on ZFS storage  enabled ?

  What FW is installed on ZFS storage?

  What level set fo compatible.asm and compatible.rdbms?

And more about ASM configuration.

This Doc can be useful:  https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=2393108.1%3AHCC_ON_ZFSSA&action=inline

You can also open SR about this problem.

Regards,

   Nik

bornesel

Hi Joe,

The following command enables the smart storage features on the Exadata

SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'cell.smart_scan_capable' = 'TRUE';

enables the smart storage features on the Exadata: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ostmg/manage-diskgroup-attributes.html#GUID-5B8244D8-4CC3-4F52-B808-5BE0E6CF16E5

Check the link privided by Nik to configure ZFS and HCC. Check the Doc ID 1616275.1 too

Borys

Robeen

Hi,

I raised the SR. Please see below comments:

Hello,

The issue looks similar to the below MOS note

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

please check for any problem from OS where inquiry fails.

Regards,

Joe

Andris Perkons-Oracle

Maybe I don't understand the problem or what you are trying to do, but: just because you receive the same ORA-error, does not mean that your problem is related to the problem described in MOS 1634592.1

In your OP, you are trying to enable an Exadata-only feature on non-Exadata hardware. This can't possibly work. The documentation is clear:

CELL.SMART_SCAN_CAPABLE

This attribute is only applicable to the configuration of Oracle Exadata storage.

https://docs.oracle.com/database/121/OSTMG/GUID-7A52077C-DCE5-44E0-BFA9-D30F485B8079.htm#GUID-5B8244D8-4CC3-4F52-B808-5B…

Andris

Robeen

The below document says HCC can be enabled on ZFS

https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=2393108.1%3AHCC_ON_ZFSSA&action=inline

Andris Perkons-Oracle

That's not the point I am trying to make. Of course HCC can be enabled on ZFS Storage. But nowhere in this document it is mentioned to set "cell.smart_scan_capable".

You are trying to set features exclusively available on Exadata! Smart Scan is not HCC.

Robeen

OK I will check with the storage admin for the questions asked by Nick

Are You use iSCSI or dNFS ?

  Is SNMP on ZFS storage  enabled ?

  What FW is installed on ZFS storage?

  What level set fo compatible.asm and compatible.rdbms?

And more about ASM configuration.

Thanks.

Robeen

Hi,

DNFS is setup as per command below

no dnfs file is present

select * from v$dnfs_files;

How will I know these details?

compatible.asm and compatible.rdbms levels?

Regards,

Joe

Nik

Hi.

Check this Guide for enble HCC on ZFS-SA : https://www.oracle.com/technetwork/server-storage/sun-unified-storage/documentation/problemsolver-hcc-52014-2202692.pdf

About asm compatible level:  https://oracle-base.com/articles/11g/asm-enhancements-11gr1

About RDBMS compatible level:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ostmg/diskgroup-compatibility.html#GUID-AE540604-92D9-4C…

Regards,

Nik