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

news/2024/7/2 20:21:52

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

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

Blog： http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

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

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

聊天群：40132017 聊天2群：69087192