7 Replies Latest reply: May 4, 2013 7:15 PM by Catch_22 RSS

    chanege ASM instance parameter

    user11977218
      PLease help ,

      How to change ASM instance parameter MEMORY_TARGET ?

      SQL> show parameter spfile

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      spfile string
      SQL>

      $ asmcmd spget
      +OCR_VOTE/c1se/asmparameterfile/registry.253.812471763

      SQL> alter system set MEMORY_TARGET=800M scope=both ;
      alter system set MEMORY_TARGET=800M scope=both
      *
      ERROR at line 1:
      ORA-32001: write to SPFILE requested but no SPFILE is in use

      How to modify Oracle ASM instance parameters ?

      Thank's