Oracle ASM : Alter asm_diskstring when ASM Instance is Down,

Question

I am beginner for Oracle ASM I know we can alter asm_diskstring with following ways

but these requires +ASM to be UP and running. Is there way to set asm_diskstring when +ASM instance is down ?

Thanks,

atokpas · Accepted Answer · 2016-05-18 14:46:28Z

1

You can create pfile to set asm_diskstring.

$ vi asmpfile.ora
instance_type=asm
asm_diskstring=path_to_asmdisks

Then can start asm instance using this pfile and later can create spfile from pfile.

answered May 18, 2016 at 14:46

atokpas

8,4261 gold badge15 silver badges27 bronze badges

Add a comment |

EdStevens · Accepted Answer · 2016-05-19 23:53:26Z

0

What's wrong with simply "alter system set asm_diskstring='whatever' scope=both;"

answered May 19, 2016 at 23:53

EdStevens

1,9291 gold badge8 silver badges8 bronze badges

2

Is there any way to fire "alter system set_diskstring='whatever' scope=both;' when asm is down ?
– Delta D
May 20, 2016 at 2:31
In order to issue ANY sql statement to ANY instance - db or asm - the instance has to be at least STARTED. In the case of ASM instances, that means either started or mounted. Since the parm is dynamic and takes effect immediately, why would you need/want the instance to be down?
– EdStevens
May 20, 2016 at 22:09

Add a comment |

2 Answers 2