0

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

  1. SqlPlus
  2. ASMCA

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

Thanks,

asked May 18, 2016 at 13:34
0

2 Answers 2

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
0

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

answered May 19, 2016 at 23:53
2
  • 2
    Is there any way to fire "alter system set_diskstring='whatever' scope=both;' when asm is down ? Commented 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? Commented May 20, 2016 at 22:09

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.