This discussion is archived
7 Replies Latest reply: May 4, 2013 5:15 PM by Dude! RSS

chanege ASM instance parameter

user11977218 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points