7 Replies Latest reply: May 4, 2013 7:15 PM by Dude! 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
        • 1. Re: chanege ASM instance parameter
          DK2010
          Hi,

          Its show you ASM instance not using the spfile. its using pfile. please find out using unix find command and then, create new spfile from pfile and start you instance with that spfile.
          • 2. Re: chanege ASM instance parameter
            Mihael
            ASM instance can start without any parameter file. To create spfile, use:

            SQL> create spfile from memory;

            This will update OCR (or Grid profile).
            • 3. Re: chanege ASM instance parameter
              user11977218
              But How to change location of SPFILE of ASM instance in 11gR2 ?

              Now : asmcmd spget
              +OCR_DATA/tic-c1se/asmparameterfile/registry.253.814138809

              But OCR DATA asm dik group have been deleted and created new : OCR_DATA .
              How to update spfile location to new disk Group +OCR_DATA ?

              Thank's

              Edited by: user11977218 on May 3, 2013 7:41 AM
              • 4. Re: chanege ASM instance parameter
                Dude!
                I think your response is not correct. The ASM instance will require a parameter file, just like any other Oracle instance. As of 11gR2, the ASM spfile is stored automatically in the first disk group created during the Grid Infrastructure installation.

                The trick is that ASM can read the spfile stored on ASM disks through the css cluster daemon and reading the ASM device header. People here in the forum and on the Internet have written good and detailed information about this, for instance:

                Where is my Oracle ASM Instance spfile
                http://aychin.wordpress.com/2011/01/22/oracle-11gr2-asm-spfile-eng/
                • 5. Re: chanege ASM instance parameter
                  Mihael
                  I think your response is not correct. The ASM instance will require a parameter file, just like any other Oracle instance.
                  ASM can start with dummy file as RMAN. You can delete all parameter files for ASM and see.
                  • 6. Re: chanege ASM instance parameter
                    Mihael
                    But How to change location of SPFILE of ASM instance in 11gR2 ?
                    You can use ASMCMD spmove.
                    • 7. Re: chanege ASM instance parameter
                      Dude!
                      Ok , according to the documentation:
                      http://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#i1013970

                      A PFILE or SPFILE is required if your configuration uses non-default initialization parameters for the Oracle ASM instance.