It's being long time writing a post in my blog ..
I've inherited newly installed RAC four nodes without OEM configuration and without SYS password which required to configure OEM.
Generally this post for how to change the sys password in RAC environment which seems very simple at the first instance but it has a trick. The trick is when you change the sys password in one instance, it doesn't reflect on other instances unlike any other user so you need to change it in all instances as follows:
SYS@ feco1> alter user sys identified by newPwd;
User altered.
Then login to node2 and do the same
SYS@ feco2> alter user sys identified by newPwd;
User altered.
and do so in all your RAC nodes.
the other solution which is the only one for 10g is to change the password in one instance and then copy your password file (orapw<instance_name>) located in '$ORACLE_HOME/dbs' to other nodes and amend the name accordingly,
I've inherited newly installed RAC four nodes without OEM configuration and without SYS password which required to configure OEM.
Generally this post for how to change the sys password in RAC environment which seems very simple at the first instance but it has a trick. The trick is when you change the sys password in one instance, it doesn't reflect on other instances unlike any other user so you need to change it in all instances as follows:
SYS@ feco1> alter user sys identified by newPwd;
User altered.
Then login to node2 and do the same
SYS@ feco2> alter user sys identified by newPwd;
User altered.
and do so in all your RAC nodes.
the other solution which is the only one for 10g is to change the password in one instance and then copy your password file (orapw<instance_name>) located in '$ORACLE_HOME/dbs' to other nodes and amend the name accordingly,
No comments:
Post a Comment