I am beginner for Oracle ASM I know we can alter asm_diskstring with following ways
- SqlPlus
- 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
2 Answers 2
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
What's wrong with simply "alter system set asm_diskstring='whatever' scope=both;"
answered May 19, 2016 at 23:53
-
2Is there any way to fire "alter system set_diskstring='whatever' scope=both;' when asm is down ?Delta D– Delta D2016年05月20日 02:31:48 +00:00Commented 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– EdStevens2016年05月20日 22:09:34 +00:00Commented May 20, 2016 at 22:09
lang-sql