2 Replies Latest reply: Jul 3, 2014 12:22 AM by Aritra-Oracle RSS

    How to clear Preferred Read setting

    Artem Danielov

      Hi,

      I hope someone can advise me how to remove the Preferred Read setting in ASM 11.2.0.3?

      I’m trying to set an empty string, but it gives me an error.

      Thanks!

       

       

      SQL> alter system set asm_preferred_read_failure_groups='' sid='+ASM3';

      alter system set asm_preferred_read_failure_groups='' sid='+ASM3'

      *

      ERROR at line 1:

      ORA-02097: parameter cannot be modified because specified value is invalid

      ORA-01078: failure in processing system parameters