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,

JSapkota · 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 '16 at 14:46

JSapkota

7,5161924

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 '16 at 23:53

EdStevens

1,11046

2

Is there any way to fire "alter system set_diskstring='whatever' scope=both;' when asm is down ? – Delta D May 20 '16 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 '16 at 22:09

add a comment |

2 Answers 2