How to Change ASM Home on a Node in RAC [ID 558508.1]

 

How to Change ASM Home on a Node in RAC

 

步骤如下：

1） Install a new Home to be used by ASM

 

2） Stop the listener, database, asm on the node

 

3） Listener is recommended to be run from asm home. We can reset the new home using the following command:

       $ srvctl modify listener -n <node_name> -l <listener_name_list> -o <new_asm_home>

 

4）Reset the ASM home with new value

       $ srvctl modify asm -n node1 -i <asm_instance_name> -o <new_asm_home>

 

5）  If TNS_ADMIN variable was used to point to ASM Home to find the listener, then it needs to be changed to the new ASM Home in OCR for listener and nodeapps.        Refer MOS DocID 420977.1 and 360575.1). Updating nodeapps via setenv must be done as root starting from 10.2.0.4, refer MOS DocID 779907.1.

 

6） We need to manually:

（1）.      move the (s)pfile and password file into the new home

（2）.      copy listener.ora/tnsnames.ora from old home into new home

（3）.      update /etc/oratab or /var/opt/oracle/oratab with the new home

（4）.      If dbcontrol/emcontrol is there for ASM then needs to be REconfigured. As at many places in the dbcontrol/emcontrol configuration files we hardcode the Oracle home

 

7） If you are on Windows then you need to delete the old ASM instance using oradim and then create the new one:

（1）.      Stop the Windows Service,
e.g OracleASMService+ASM1

（2）.      From command prompt
oradim -delete -asmsid +ASM1

（3）.      Set the New Oracle home/bin in the PATH so that you are running 'oradim' from the new home.
From command prompt
oradim -new -asmsid +ASM1 -intpwd xxx -m -pfile xxxx

 

8） This can be done on other nodes if required

 

 

 

 

From Oracle

-------------------------------------------------------------------------------------------------------

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

DBA1 群：62697716(满);   DBA2 群：62697977(满)   DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群： 83829929  DBA5群： 142216823   

聊天 群：40132017   聊天2群：69087192

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请