RE: sys password change in dataguard
Date: Wed, 9 Mar 2011 08:32:57 -0500
That's what we do. shutdown the standby and copy over the password file. Never had a problem.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kumar Madduri
Sent: Tuesday, March 08, 2011 9:04 PM
Subject: Re: sys password change in dataguard
At our place, we just copied the password file before the next redo log transport and log shipping was ok
On Tue, Mar 8, 2011 at 4:11 PM, K R <kp0773_at_gmail.com<mailto:kp0773_at_gmail.com>> wrote: All,
We have a need to change the sys user password in primary . and we have recently put a standby in place.
so what will be the recommended way to change the sys user password so that it wont break the physical standby .
on 11g doc it says
9.3.7 Refresh the Password File
If the REMOTE_LOGIN_PASSWORDFILE database initialization parameter is set to SHARED or EXCLUSIVE, the password file on a physical standby database must be replaced with a fresh copy from the primary database after granting or revoking administrative privileges or changing the password of a user with administrative privileges.
Failure to refresh the password file on the physical standby database MAY cause authentication of redo transport sessions or connections as SYSDBA or SYSOPER to the physical standby database to fail.
however it says it may cause to fail which confuses me . appreciate any suggestion.