When running ora_chpwd in a RAC environment, some considerations need to be kept in mind. This solution delves on these.
General information.
To run ora_chpwd in a RAC environment, the following should be taken care of:
1.Make sure that the environment variable ORACLE_SID points to the tns alias that was created and used when the ora_setup was first ran when configuring the RAC.
2.When specifying the password while running ora_chpwd , use sql*net by appending password with @<tns_alias> as <password>@<tns_alias> instead of just <password>.
