QUESTION POSED ON: 10 March 2008
In a two-node RAC (Oracle 10g R2, Windows 2003) environment, what would be the result when we do "alter user sys identified by pwd;" on one node after OS authentication?
Except modifying SYS password in data dictionary, will this synchronize SYS password in password file on the current node? Also, what about SYS password in password file on another node, will that be changed as well?
Is there any effect on SYS login OEM database control as sysdba after changing SYS password by "alter user sys identified by pwd;" on one code? (since the OEM database control login uses password file).
|
